Question 1

Consider an association between a Customers class and a Sale class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Customers class are 1..1 and the multiplicities next to the Sale class are 0..*. Which of the following is the best way to implement that association in your database?
A. Post the primary key of Customers as a foreign key in Sales
B. Post the primary key of Sales as a foreign key in Customers
C. Create a linking table
D. None of the above

Accepted Answer

The answer of Consider an association between a Customers class...

Question 2

Which of the following is the best description of an association?
A. A group of classes
B. The lines in a UML Class diagram
C. The relationship between two classes
D. The number of times one class is related to another

Accepted Answer

The answer of Which of the following is the best...

Question 3

When implementing the database from a UML class diagram, associations should be mapped to which of the following?
A. Tables
B. Fields
C. Relationships
D. Foreign keys

Accepted Answer

The answer of When implementing the database from a UML...

Question 4

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?
A. Relationships
B. Associations
C. Attributes
D. Entities

Accepted Answer

The answer of Entity-relationship diagrams (ERDs) are similar in content...

Question 5

Which of the following statements about foreign keys is not true?
A. A foreign key can be a combination of attributes
B. A foreign key cannot be NULL
C. Foreign key must match values of the linked primary key
D. Foreign keys support a defined association

Accepted Answer

The answer of Which of the following statements about foreign...

Question 6

When implementing the database from a UML class diagram, attributes should be mapped to which of the following?
A. Tables
B. Relationships
C. Fields
D. Indexes

Accepted Answer

The answer of When implementing the database from a UML...

Question 7

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?
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

Accepted Answer

The answer of Consider an association between a Cash Disbursements...

Question 8

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

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

Which of the following is not a valid enforcement level for business rules?
A. Authorization
B. Pre-override
C. Strict Enforcement
D. Post-override

Accepted Answer

The answer of Which of the following is not a...

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

Unified Modeling Language (UML) Class diagrams describe the logical structure of a database system.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following would be least likely to be represented with a Unified Modeling Language (UML) Class?
A. Trucks
B. The number of trucks used in the delivery
C. The employee driving the truck
D. The customer receiving the delivery

Accepted Answer

The answer of Which of the following would be least...

Question 15

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

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?
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

Accepted Answer

The answer of Consider an association between a Deliveries class...

Question 17

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?
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

Accepted Answer

The answer of Consider an association between a Sales class...

Question 18

What is the best description of the relationship between employee and vehicle in the following UML class diagram?
  
A. Zero-to-one
B. Zero-to-zero
C. One-to-one
D. One-to-many

Accepted Answer

The answer of What is the best description of the...

Question 19

Which of the following is not a category of operational decision used in creating business rules?
A. Calculation
B. Event
C. Risk
D. Opportunity

Accepted Answer

The answer of Which of the following is not a...

Question 20

A generalization relationship models a grouping of things that share common characteristics.

Accepted Answer

A) True 
 B)False

Exam 3: Data Modeling

Which of the following is the best description of an association? A. A group of classes B. The lines in a UML Class diagram C. The relationship between two classes D. The number of times one class is related to another

When implementing the database from a UML class diagram, associations should be mapped to which of the following? A. Tables B. Fields C. Relationships D. Foreign keys

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? A. Relationships B. Associations C. Attributes D. Entities

Which of the following statements about foreign keys is not true? A. A foreign key can be a combination of attributes B. A foreign key cannot be NULL C. Foreign key must match values of the linked primary key D. Foreign keys support a defined association

When implementing the database from a UML class diagram, attributes should be mapped to which of the following? A. Tables B. Relationships C. Fields D. Indexes

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

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

Which of the following is not a valid enforcement level for business rules? A. Authorization B. Pre-override C. Strict Enforcement D. Post-override

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.

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

Unified Modeling Language (UML) Class diagrams describe the logical structure of a database system.

Which of the following would be least likely to be represented with a Unified Modeling Language (UML) Class? A. Trucks B. The number of trucks used in the delivery C. The employee driving the truck D. The customer receiving the delivery

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

What is the best description of the relationship between employee and vehicle in the following UML class diagram? A. Zero-to-one B. Zero-to-zero C. One-to-one D. One-to-many

Which of the following is not a category of operational decision used in creating business rules? A. Calculation B. Event C. Risk D. Opportunity

A generalization relationship models a grouping of things that share common characteristics.