Question 1

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 2

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 3

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

Accepted Answer

Mapping associations to primary keys is not a step in using a UML Class model to prepare a database. Instead, associations are typically mapped to foreign keys in order to establish relationships between tables. The other listed steps, including mapping classes to tables and mapping attributes to table fields, are integral components of using a UML Class model to prepare a database.

Question 4

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 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 the above

Accepted Answer

The answer of Consider an association indicating professional licensing status...

Question 5

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 6

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 7

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. 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 the above

Accepted Answer

The answer of Consider an association between a Pet Owners...

Question 8

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 9

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 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 the above

Accepted Answer

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

Question 10

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 11

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 12

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 13

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

Accepted Answer

A model of database structures must be able to describe the entities or things in the domain of interest, the cardinalities that describe how many instances of one entity can be related to another, and the attributes or characteristics of the entities and relationships. However, it does not need to describe the sequence in which entities are accessed.

Question 14

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

Accepted Answer

The answer of Associations in UML Class Diagrams should include...

Question 15

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

Accepted Answer

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

Question 16

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. Primary keys with sequential values make it easier to spot gaps in the data
D. Longer key values are better than shorter key values

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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. Post the primary key of Cities as a foreign key in Neighborhoods
B. Post the primary key of Neighborhoods as a foreign key in Cities
C. Create a linking table
D. None of the above

Accepted Answer

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

Question 19

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

Accepted Answer

The answer of Logical database structure models, including UML Class...

Question 20

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

Quiz 3: Data Modeling

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 is not a step in using a Unified Modeling Language (UML) Class model to prepare a database? A. Map Classes to Tables B. Map Attributes to Table Fields C. Map Associations to Primary Keys D. Map Associations to Foreign Keys

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

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

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

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

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

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