Question 1

Which of the following is not something a model of database structures must be able to describe?

Accepted Answer

A)  The entities or things in the domain of interest 
B)  The sequence that entities are accessed 
C)  The cardinalities that describe how many instances of one entity can be related to another 
D)  The attributes or characteristics of the entities and relationships 
A)  The entities or things in the domain of interest 
B)  The sequence that entities are accessed 
C)  The cardinalities that describe how many instances of one entity can be related to another 
D)  The attributes or characteristics of the entities and relationships

Question 2

The Object Management Group maintains the standard for Unified Modeling Language (UML)Class diagrams.

Accepted Answer

A) True 
 B)False

Question 3

Consider an association between a Cash Disbursements class and a Cash Accounts class in a Unified Modeling Language (UML)Class diagram.The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Cash Accounts class are 1..1.Which of the following is the best way to implement that association in your database?

Accepted Answer

A)  Post the primary key of Cash Disbursements as a foreign key in Cash Accounts. 
B)  Post the primary key of Cash Accounts as a foreign key in Cash Disbursements. 
C)  Create a linking table. 
D)  None of the above. 
A)  Post the primary key of Cash Disbursements as a foreign key in Cash Accounts. 
B)  Post the primary key of Cash Accounts as a foreign key in Cash Disbursements. 
C)  Create a linking table. 
D)  None of the above.

Question 4

A Class is a separately identifiable collection of business relationships.

Accepted Answer

A) True 
 B)False

Question 5

Consider an association between a Sales class and an Inventory class in a Unified Modeling Language (UML)Class diagram.The multiplicities next to the Sales class are 0..* and the multiplicities next to the Inventory class are 1..*.Which of the following is the best way to implement that association in your database?

Accepted Answer

A)  Post the primary key of Sales as a foreign key in Inventory. 
B)  Post the primary key of Inventory as a foreign key in Sales. 
C)  Create a linking table. 
D)  None of the above. 
A)  Post the primary key of Sales as a foreign key in Inventory. 
B)  Post the primary key of Inventory as a foreign key in Sales. 
C)  Create a linking table. 
D)  None of the above.

Question 6

List the tables with primary keys,attributes,and foreign keys that implement the following UML Class diagram given the accompanying list of attributes.

Accepted Answer

Types of Bicycles = Bicycle Type (PK),Bi

Question 7

Which of the following would be least likely to be represented with a Unified Modeling Language (UML)Class?

Accepted Answer

A)  Trucks 
B)  The number of trucks used in the delivery 
C)  The employee driving the truck 
D)  The customer receiving the delivery 
A)  Trucks 
B)  The number of trucks used in the delivery 
C)  The employee driving the truck 
D)  The customer receiving the delivery

Question 8

Entity-relationship diagrams (ERDs)are similar in content and purpose to Unified Modeling Language (UML)Class diagrams.Which of the following is not a basic building block of ERDs?

Accepted Answer

A)  Relationships 
B)  Associations 
C)  Attributes 
D)  Entities 
A)  Relationships 
B)  Associations 
C)  Attributes 
D)  Entities

Question 9

Consider an association between a Deliveries class and a Shipping Companies class in a Unified Modeling Language (UML)Class diagram.The multiplicities next to the Deliveries class are 0..* and the multiplicities next to the Shipping Companies class are 1..1.Which of the following is the best way to implement that association in your database?

Accepted Answer

A)  Post the primary key of Deliveries as a foreign key in Shipping Companies. 
B)  Post the primary key of Shipping Companies as a foreign key in Deliveries. 
C)  Create a linking table. 
D)  None of the above. 
A)  Post the primary key of Deliveries as a foreign key in Shipping Companies. 
B)  Post the primary key of Shipping Companies as a foreign key in Deliveries. 
C)  Create a linking table. 
D)  None of the above.

Question 10

In Unified Modeling Language (UML)Class diagrams,a Class is represented by a rectangle.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is not a form of business rules?

Accepted Answer

A)  Compulsory 
B)  Obligatory 
C)  Prohibited 
D)  Allowed 
A)  Compulsory 
B)  Obligatory 
C)  Prohibited 
D)  Allowed

Question 12

Consider an association between a Cash Disbursements class and a Vendors class in a Unified Modeling Language (UML)Class diagram.The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Vendors class are 1..1.Which of the following is the best way to implement that association in your database?

Accepted Answer

A)  Post the primary key of Cash Disbursements as a foreign key in Vendors. 
B)  Post the primary key of Vendors as a foreign key in Cash Disbursements. 
C)  Create a linking table. 
D)  None of the above. 
A)  Post the primary key of Cash Disbursements as a foreign key in Vendors. 
B)  Post the primary key of Vendors as a foreign key in Cash Disbursements. 
C)  Create a linking table. 
D)  None of the above.

Question 13

An aggregation relationship is a form of generalization relationships.

Accepted Answer

A) True 
 B)False

Question 14

Consider an association between a Pet Owners class and a Pets class in a Unified Modeling Language (UML)Class diagram.The multiplicities next to the Pet Owners class are 1..1 and the multiplicities next to the Pets class are 1..*.Which of the following is the best way to implement that association in your database?

Accepted Answer

A)  Post the primary key of Pet Owners as a foreign key in the Pets. 
B)  Post the primary key of Pets as a foreign key in Pet Owners. 
C)  Create a linking table. 
D)  None of the above. 
A)  Post the primary key of Pet Owners as a foreign key in the Pets. 
B)  Post the primary key of Pets as a foreign key in Pet Owners. 
C)  Create a linking table. 
D)  None of the above.

Question 15

Which of the following is not a step in using a Unified Modeling Language (UML)Class model to prepare a database?

Accepted Answer

A)  Map Classes to Tables. 
B)  Map Attributes to Table Fields. 
C)  Map Associations to Primary Keys. 
D)  Map Associations to Foreign Keys. 
A)  Map Classes to Tables. 
B)  Map Attributes to Table Fields. 
C)  Map Associations to Primary Keys. 
D)  Map Associations to Foreign Keys.

Question 16

Which of following are possible options for minimum multiplicities?

Accepted Answer

A)  0 and 1 
B)  0 and * 
C)  * and 1 
D)  0, 1, and * 
A)  0 and 1 
B)  0 and * 
C)  * and 1 
D)  0, 1, and *

Question 17

In Unified Modeling Language (UML)attributes are characteristics of individual instances of a Class.

Accepted Answer

A) True 
 B)False

Question 18

When building a database from Unified Modeling Language (UML)Class diagrams,each instance of each Class becomes a row in the corresponding table.

Accepted Answer

A) True 
 B)False

Question 19

In Unified Modeling Language (UML)foreign keys allow tables to be linked together in a database.

Accepted Answer

A) True 
 B)False

Question 20

Consider an association indicating professional licensing status between an Accountant class and a States class in a Unified Modeling Language (UML)Class diagram.The multiplicities next to the Accountants class are 0..* and the multiplicities next to the States class are 0..*.Which of the following is the best way to implement that association in your database?

Accepted Answer

A)  Post the primary key of Accountants as a foreign key in States. 
B)  Post the primary key of States as a foreign key in Accountants. 
C)  Create a linking table. 
D)  None of the above. 
A)  Post the primary key of Accountants as a foreign key in States. 
B)  Post the primary key of States as a foreign key in Accountants. 
C)  Create a linking table. 
D)  None of the above.

Which of the following is not something a model of database structures must be able to describe?

The Object Management Group maintains the standard for Unified Modeling Language (UML)Class diagrams.

A Class is a separately identifiable collection of business relationships.

List the tables with primary keys,attributes,and foreign keys that implement the following UML Class diagram given the accompanying list of attributes.

Which of the following would be least likely to be represented with a Unified Modeling Language (UML)Class?

Entity-relationship diagrams (ERDs)are similar in content and purpose to Unified Modeling Language (UML)Class diagrams.Which of the following is not a basic building block of ERDs?

In Unified Modeling Language (UML)Class diagrams,a Class is represented by a rectangle.

Which of the following is not a form of business rules?

An aggregation relationship is a form of generalization relationships.

Which of the following is not a step in using a Unified Modeling Language (UML)Class model to prepare a database?

Which of following are possible options for minimum multiplicities?

In Unified Modeling Language (UML)attributes are characteristics of individual instances of a Class.

When building a database from Unified Modeling Language (UML)Class diagrams,each instance of each Class becomes a row in the corresponding table.

In Unified Modeling Language (UML)foreign keys allow tables to be linked together in a database.

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Relational Databases and Enterprise Systems

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language XBRL

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing AIS

The Balanced Scorecard and Business Value of Information Technology

Evaluating AIS Investments

The Systems Development Life Cycle and Project Management: Addressing the Challenges of Building Ais Systems

Filters

Exam 3: Data Modeling

Which of the following is not something a model of database structures must be able to describe?

The Object Management Group maintains the standard for Unified Modeling Language (UML)Class diagrams.

A Class is a separately identifiable collection of business relationships.

List the tables with primary keys,attributes,and foreign keys that implement the following UML Class diagram given the accompanying list of attributes.

Which of the following would be least likely to be represented with a Unified Modeling Language (UML)Class?

Entity-relationship diagrams (ERDs)are similar in content and purpose to Unified Modeling Language (UML)Class diagrams.Which of the following is not a basic building block of ERDs?

In Unified Modeling Language (UML)Class diagrams,a Class is represented by a rectangle.

Which of the following is not a form of business rules?

An aggregation relationship is a form of generalization relationships.

Which of the following is not a step in using a Unified Modeling Language (UML)Class model to prepare a database?

Which of following are possible options for minimum multiplicities?

In Unified Modeling Language (UML)attributes are characteristics of individual instances of a Class.

When building a database from Unified Modeling Language (UML)Class diagrams,each instance of each Class becomes a row in the corresponding table.

In Unified Modeling Language (UML)foreign keys allow tables to be linked together in a database.

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Relational Databases and Enterprise Systems

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language XBRL

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing AIS

The Balanced Scorecard and Business Value of Information Technology

Evaluating AIS Investments

The Systems Development Life Cycle and Project Management: Addressing the Challenges of Building Ais Systems

Filters