Exam 3: Data Modeling

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

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

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

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

Which attribute in the following class would make the best primary key? A. Customer B. Customer Name C. E-mail address D. Customer ID

Obligatory business rules state what should occur.

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

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

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

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

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

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

Identify the classes and associations in the following narrative and draw a class diagram with multiplicities: Barb maintains a real estate tracking system for Orange County. There are currently 34 incorporated cities and 15 unincorporated communities in the county. Barb tracks all of these as cities. Within each city, there is at least one and could be many neighborhoods. Within each neighborhood, there is at least one and likely many houses. For each house, Barb tracks information for all the sales in the last 20 years, although some houses have not been sold in the last 20 years.

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

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

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

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

Which of the following UML class diagrams depicts an aggregation relationship? A. B. C. (Correct) D.

A Class is a separately identifiable collection of business relationships.

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