ACCT 310 Chapter 3

Which of following are possible options for minimum multiplicities? A. * and 1 B. 0 and 1 C. 0 and * D. 0, 1, and *

B. 0 and 1

The following UML class diagram should result in how many tables in the relational database? ITEMS PURCHASE ORDERS VENDORS EMPLOYEES A. 4 B. 5 C. 6 D. 7

B. 5

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

B. Authorization

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

B. Foreign keys

Which of the following is not a best practice in preparing Unified Modeling Language (UML) Class diagrams? A. Avoid confusing abbreviations B. Model each process separately C. Opt for simplicity D. Avoid crossing lines whenever possible

B. Model each process separately

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

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

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. Create a linking table B. Post the primary key of Shipping Companies as a foreign key in Deliveries C. Post the primary key of Deliveries as a foreign key in Shipping Companies D. None of the options are correct

B. Post the primary key of Shipping Companies as a foreign key in Deliveries

Logical database structure models, including UML Class Diagrams, must be able to describe which of the following? A. The activities performed in the business process B. The entities in the domain of interest C. The Bachman diagram D. The operations performed on the database

B. The entities in the domain of interest

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 customer receiving the delivery D. The employee driving the truck

B. The number of trucks used in the delivery

Which of the following is not something a model of database structures must be able to describe? 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

B. The sequence that entities are accessed

The following UML class diagram should result in how many tables in the relational database? PLANTS LANDSCAPING JOBS EMPLOYEES CUSTOMERS Laborer Manager A. 7 B. 4 C. 5 D. 6

D. 6

Which of the following is a well-formed business rule? A. Customers may not be under 18 years of age B. Customers must be over 18 years of age C. Customers must pay in U. S. dollars D. All of these are well-formed business rules

D. All of these are well-formed business rules

Which attribute in the following class would make the best primary key? A. Customer Name B. Customer C. Email Address D. Customer ID

D. Customer ID

Which of the following is not a step in using a Unified Modeling Language (UML) Class model to prepare a database? A. Map Associations to Foreign Keys B. Map Classes to Tables C. Map Attributes to Table Fields D. Map Associations to Primary Keys

D. Map Associations to Primary Keys

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

D. One-to-many

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

D. The relationship between two classes

Which of the following best describes the purpose of a primary key? A. Allows linking two or more tables B. Indicates the minimum multiplicities for an association C. Matches values of foreign keys in other classes D. Uniquely identifies each instance of the class

D. Uniquely identifies each instance of the 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? A. Associations B. Attributes C. Relationships D. Entities

A. Associations

Which of the following is not a form of business rules? A. Compulsory B. Allowed C. Prohibited D. Obligatory

A. Compulsory

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. Create a linking table B. Post the primary key of Inventory as a foreign key in Sales C. Post the primary key of Sales as a foreign key in Inventory D. None of the options are correct

A. Create a linking table

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

A. Event

Which of the following is not one of the building blocks used for creating UML Class Diagrams? A. Events B. Classes C. Associations D. None of the other options are used in UML Class Diagrams

A. Events

What is the best description of the relationship between instructor and course in the following UML class diagram? Instructor 1...* Course 0...* A. Many-to-many B. One-to-many C. One-to-zero D. Zero-to-many

A. Many-to-many

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. Create a linking table C. Post the primary key of Sales as a foreign key in Customers D.

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

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? A. Post the primary key of Vendors as a foreign key in Cash Disbursements B. Create a linking table C. Post the primary key of Cash Disbursements as a foreign key in Vendors D. None of the options are correct

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

Associations in UML Class Diagrams should include a description in which of the following situations? A. The business purpose of the association is not clear B. The attributes of the related class are not clear C. The decision criterion(a) affecting the process flow direction is not clear D. Associations should always include descriptions

A. The business purpose of the association is not clear

Which of the following is most similar to the relationship between the UML class diagram and the database? A. The relationship between a blueprint and building B. The relationship between cooking instructions and ingredients C. The relationship between raw materials and finished goods D. The relationship between driving directions and a map

A. The relationship between a blueprint and building

Which of the following UML class diagrams depicts an aggregation relationship? A. open diamond B. arrows pointing C. relationship D. closed diamond

A. open diamond

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

C. A foreign key cannot be NULL

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? A. Post the primary key of States as a foreign key in Accountants B. Post the primary key of Accountants as a foreign key in States C. Create a linking table D. None of the options are correct

C. Create a linking table

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

C. Fields

Which of the following is not a criterion for selection of a primary key? A. The primary key cannot be NULL (blank) B. The primary key should be controlled by the organization assigning it C. Longer key values are better than shorter key values D. Primary keys with sequential values make it easier to spot gaps in the data

C. Longer key values are better than shorter key values

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

C. One-to-one

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. Create a linking table C. Post the primary key of Cash Accounts as a foreign key in Cash Disbursements D. None of the options are correct

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

Consider an association between a Cities class and a Neighborhoods class in a Unified Modeling Language (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? A. Create a linking table B. Post the primary key of Neighborhoods as a foreign key in Cities C. Post the primary key of Cities as a foreign key in Neighborhoods D. None of the options are correct

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