Question 1

The following UML class diagram should result in how many tables in the relational database?

Accepted Answer

A) 4 
B) 5 
C) 6 
D) 7 
A) 4 
B) 5 
C) 6 
D) 7 C

Question 2

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 Pets. 
B) Post the primary key of Pets as a foreign key in Pet Owners. 
C) Create a linking table. 
D) None of these choices are correct. 
A) Post the primary key of Pet Owners as a foreign key in Pets. 
B) Post the primary key of Pets as a foreign key in Pet Owners. 
C) Create a linking table. 
D) None of these choices are correct. A

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 these choices are correct. 
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 these choices are correct. B

Question 4

In Unified Modeling Language (UML)primary keys cannot by NULL.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is the best description of an association?

Accepted Answer

A) A group of classes. 
B) Grouping of items. 
C) The relationship between two classes. 
D) The number of times one class is related to another. 
A) A group of classes. 
B) Grouping of items. 
C) The relationship between two classes. 
D) The number of times one class is related to another.

Question 6

A database being built to support customer purchase information would likely have the following classes except:

Accepted Answer

A) Customer 
B) Order 
C) Inventory 
D) Color 
A) Customer 
B) Order 
C) Inventory 
D) Color

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Associations can indicate the roles that one Class takes in its business relationship with another Class.

Accepted Answer

A) True 
 B)False

Question 9

In Unified Modeling Language (UML)the options for minimum multiplicity values are 0,1,and 2.

Accepted Answer

A) True 
 B)False

Question 10

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 these choices are correct. 
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 these choices are correct.

Question 11

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

Accepted Answer

A) Trucks 
B) Currency 
C) Employees 
D) Bank Account 
A) Trucks 
B) Currency 
C) Employees 
D) Bank Account

Question 12

The following UML class diagram should result in how many tables in the relational database?

Accepted Answer

A) 4 
B) 5 
C) 6 
D) 7 
A) 4 
B) 5 
C) 6 
D) 7

Question 13

In Unified Modeling Language (UML)Class diagrams,Associations are represented by dashed lines.

Accepted Answer

A) True 
 B)False

Question 14

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 15

A database should have exactly the same number of tables as there are Classes in the Unified Modeling Language (UML)Class diagram from which the database is developed.

Accepted Answer

A) True 
 B)False

Question 16

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 these choices are correct. 
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 these choices are correct.

Question 17

Which of the following statements about foreign keys is not true?

Accepted Answer

A) A foreign key can be a combination of attributes. 
B) A foreign key should never be linked to a primary key in another table. 
C) Foreign key must match values of the linked primary key. 
D) Foreign keys support a defined association. 
A) A foreign key can be a combination of attributes. 
B) A foreign key should never be linked to a primary key in another table. 
C) Foreign key must match values of the linked primary key. 
D) Foreign keys support a defined association.

Question 18

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 19

Which attribute in the following class would make the best primary key?

Accepted Answer

A) Customer 
B) Customer Name 
C) E-mail address 
D) Customer ID 
A) Customer 
B) Customer Name 
C) E-mail address 
D) Customer ID

Question 20

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 these choices are correct. 
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 these choices are correct.

The following UML class diagram should result in how many tables in the relational database?

In Unified Modeling Language (UML)primary keys cannot by NULL.

Which of the following is the best description of an association?

A database being built to support customer purchase information would likely have the following classes except:

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

Associations can indicate the roles that one Class takes in its business relationship with another Class.

In Unified Modeling Language (UML)the options for minimum multiplicity values are 0,1,and 2.

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

The following UML class diagram should result in how many tables in the relational database?

In Unified Modeling Language (UML)Class diagrams,Associations are represented by dashed lines.

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

A database should have exactly the same number of tables as there are Classes in the Unified Modeling Language (UML)Class diagram from which the database is developed.

Which of the following statements about foreign keys is not true?

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

Which attribute in the following class would make the best primary key?

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

Data Analytics in Accounting: Concepts and the Amps Model

Data Analytics in Accounting: Tools and Practice

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters

Exam 3: Data Modeling

The following UML class diagram should result in how many tables in the relational database?

In Unified Modeling Language (UML)primary keys cannot by NULL.

Which of the following is the best description of an association?

A database being built to support customer purchase information would likely have the following classes except:

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

Associations can indicate the roles that one Class takes in its business relationship with another Class.

In Unified Modeling Language (UML)the options for minimum multiplicity values are 0,1,and 2.

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

The following UML class diagram should result in how many tables in the relational database?

In Unified Modeling Language (UML)Class diagrams,Associations are represented by dashed lines.

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

A database should have exactly the same number of tables as there are Classes in the Unified Modeling Language (UML)Class diagram from which the database is developed.

Which of the following statements about foreign keys is not true?

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

Which attribute in the following class would make the best primary key?

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

Data Analytics in Accounting: Concepts and the Amps Model

Data Analytics in Accounting: Tools and Practice

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters