Exam 3: Data Modeling

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

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

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

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.

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

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

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.