Exam 3: Data Modeling

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

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

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

Business rules set criteria for branching in activity models.

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

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

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 driving directions and a map C. The relationship between raw materials and finished goods D. The relationship between cooking instructions and ingredients

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

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

An aggregation relationship is a form of generalization relationships.