Chapter 9, Problem 10RQ

Explanation of Solution

Steps required in the development of an ER diagram:

The below are the eight steps that are required in the development of the ER diagram:

Step 1:

Business rules are identified, analyzed and refined.

Step 2:

Based on the results obtained from the step 1, the main entities can be obtained.

Step 3:

Based on the results obtained from the step 1 and 2, the relationships among the entities are obtained.

Step 4:

The attributes, primary keys and foreign key are defined for each of the entities...