Exam 3: Data Modeling

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?

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

List the tables with primary keys,attributes,and foreign keys that implement the following UML Class diagram given the accompanying list of attributes.Identify primary keys with PK and foreign keys with FK.

Which of the following statements about foreign keys is not true?

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

Obligatory business rules state what should not occur.

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

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

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.

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

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

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

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?

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

Identify the classes and associations in the following narrative and draw a class diagram with multiplicities: To put himself through school,Zach operates an ice cream truck that travels through neighborhoods,ringing a bell to attract kids that want a cold ice cream treat.Zach's inventory includes many ice cream products and he tracks which items are sold in each sale.He occasionally adds new items to his list of ice cream products for sale.Zach only accepts cash for each sale.To identify the routes that generate the most sales,Zach summarizes sales by neighborhood but he only tracks neighborhoods with at least one sale.Zach deposits the cash received in his bank account at the end of each day.

Which of the following best describes the purpose of a primary key?

Which of the following is not a criterion for selection of a primary key?

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

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

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