AIS ch3

false

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

true

In Unified Modeling Language (UML) Class diagrams, a Class is represented by a rectangle.

true

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

true

In Unified Modeling Language (UML) foreign keys allow tables to be linked together in a database.

true

In Unified Modeling Language (UML) primary keys cannot by NULL.

false

In Unified Modeling Language (UML) primary keys may be blank.

false

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

true

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

false

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

false

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

false

Obligatory business rules state what should not occur.

false

A Class is a separately identifiable collection of business relationships

false

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.

true

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

true

Associations can indicate the roles that one Class takes in its business relationship with another Class.

false

An aggregation relationship is a form of generalization relationships.

true

Business rules set criteria for branching in activity models.

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

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

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

true

The Object Management Group maintains the standard for Unified Modeling Language (UML) Class diagrams

true

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

true

When building a database from Unified Modeling Language (UML) Class diagrams, each instance of each Class becomes a row in the corresponding table.

0 and 1

Which of 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 are well-formed business rules.

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

Model each process separately.

Which of the following is not a best practice in preparing Unified Modeling Language (UML) Class diagrams?

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 a Unified Modeling Language (UML) Class model to prepare a database?

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

Which of the following would be least likely to be represented with a Unified Modeling Language (UML) Class?