Questions from Database Systems

Q: Write the business rule(s) that governs the relationship between

Write the business rule(s) that governs the relationship between AGENT and CUSTOMER.

Q: United Broke Artists (UBA) is a broker for not-

United Broke Artists (UBA) is a broker for not-so-famous painters. UBA maintains a small network database to track painters, paintings, and galleries. A painting is painted by a particular artist, and...

Q: Using the ERD from Problem 10, create the relational schema.

Using the ERD from Problem 10, create the relational schema. (Create an appropriate collection of attributes for each of the entities. Make sure you use the appropriate naming conventions to name the...

Q: Given the business rule(s) you wrote in Problem 1

Given the business rule(s) you wrote in Problem 1, create the basic Crow’s Foot ERD.

Q: Using the ERD you drew in Problem 2, create the equivalent

Using the ERD you drew in Problem 2, create the equivalent Object representation and UML class diagram. (Use Figure 2.4 as your guide.) Data from problem 2:

Q: Identify each relationship type and write all of the business rules.

Identify each relationship type and write all of the business rules.

Q: Create the basic Crow’s Foot ERD for DealCo.

Create the basic Crow’s Foot ERD for DealCo.

Q: Identify each relationship type and write all of the business rules.

Identify each relationship type and write all of the business rules.

Q: How would you model Question 6 with an OODM? (Use

How would you model Question 6 with an OODM? (Use Figure 2.4 as your guide.)

Q: Create the basic Crow’s Foot ERD for Tiny College.

Create the basic Crow’s Foot ERD for Tiny College.