ACCT 310 CH 3

The entities in the domain of interest

Logical database structure models, including UML class diagrams, must be able to describe which of the following?

The business purpose of the association is not clear

Associations in UML class diagrams should include a description in which of the following situations?

Post the primary key of Cash Accounts as a foreign key in Cash Disbursements

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?

Post the primary key of Vendors as a foreign key in Cash Disbursements

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?

Post the primary key of Cities as a foreign key in Neighborhoods

Consider an association between a Cities class and a Neighborhoods class in a UML Class diagram. THe multiplicities next to the Cities class are 1...1 and the multiplicities next to the Neighborhoods class are 1...*. Which of the following is the best way to implement that association in your database?

Post the primary key of Customers as a foreign key in Sales

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?

Post the primary key of Shipping Companies as a foreign key in Deliverables

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?

Post the primary key of Pet Owners as a foreign key in Pets

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?

Create a linking table

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?

Create a linking table

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?

Associations

Entity-relationship diagrams are similar in content and purpose to UML class diagrams. Which of the following is not a basic building block of ERDs?

Foreign keys

When implementing the database from a UML class diagram, associations should be mapped to which of the following?

Fields

When implementing the database from a UML class diagram, attributes should be mapped to which of the following?

0 and 1

Which of the following are possible options for minimum multiplicities?

Uniquely identifies each instance of the class

Which of the following best describes the purpose of a primary key?

All of these (customers may not be under 18, customers must be over 18, customers must pay in USD)

Which of the following is a well-formed business rule?

The relationship between a blueprint and building

Which of the following is most similar to the relationship between the UML class diagram and the database?

Model each process separately

Which of the following is not a best practice in preparing UML class diagrams?

Event

Which of the following is not a category of operational decision used in creating business rules?

Longer key values are better than shorter key values

Which of the following is not a criterion for selection of a primary key?

Compulsory

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

Map associations to primary keys

Which of the following is not a step in using UML class model to prepare a database?

Events

Which of the following is not one of the building blocks used for creating UML class diagrams?

The sequence that entities are accessed

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

The relationship between two classes

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

A foreign key cannot be NULL

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

The number of trucks used in delivery

Which of the following would be least likely to be represented with a UML class?