FUNDAMENTALS OF DATABASES
CLASS ACTIVITY – Chapter 2 & 3
PART A
Use the information below to answer the questions that follow
1. Create a Crow’s Foot ERD to include the following business rules for the ProdCo Company:
a. Each sales representative writes many invoices.
b. Each invoice is written by one sales representative.
c. Each sales representative is assigned to one department.
d. Each department has many sales representatives.
e. Each customer can generate many invoices.
f. Each invoice is generated by one customer.

PART B
Use the figure below to answer the questions that follow.

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

2. Create the basic Crow’s Foot ERD for DealCo.

PART C
Use the following information to answer the questions that follow.

Typically, a patient staying in a hospital 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. b. b. Create a Crow's Foot ERD that depicts a relational database model to capture these business rules.

PART D
Use the following information to answer the questions that follow.

XYZ School has asked you to design and implement an automated library management system. Given the following and assuming that the planning has already been done, (including initial study and feasibility): a. Indicate the MOST appropriate sequence of activities by labeling each of the following steps in the correct order. (For example, if you think that “Create the file” is the Ideal first step, place it as the first