Create the basic crows foot erd for tiny college

Jordan Camba
3/13/2017
CIS223

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

Using Figure P2.4 as your guide, work Problems 4–5. The DealCo relational diagram shows the initial entities and attributes for the DealCo stores, which are located in two regions of the country.

FIGURE P2.4 The DealCo relational diagram

STORE and EMPLOYEE is 1:M
EMPLOYEE and JOB is 1:M
5. Create the basic Crow’s Foot ERD for DealCo.

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

COURSE to CLASS 1:M
CLASS to ENROLL 1:M
ENROLL to STUDENT 1:M
7. Create the basic Crow’s Foot ERD for Tiny College.

9. Typically, a hospital patient receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between PATIENT and ORDER. Similarly, each order can include several medications, creating a 1:M relationship between ORDER and MEDICATION.

a. Identify the business rules for PATIENT, ORDER, and MEDICATION.

10. United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database to track painters, paintings, and galleries. A painting is created by a particular artist and then exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is created by a single painter, but each painter can create many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relational database:

a. What tables would you create, and what would the table components be?

Jordan Camba
3/13/2017
CIS223