Question: 1 . Find all the attributes on the attached form ( from all 3 pages ) 2 . Establish the dependencies ( determinants ) .

1. Find all the attributes on the attached form (from all 3 pages)
2. Establish the dependencies (determinants).
3. Group attributes that have a common determinant into an entity type; name it.
4. Find directly-related entity type pairs.
5. Determine the connectivity for each pair.
6. Create the ERD in 3NF (3rd Normalization Form) and display the appropriate cardinality connecting the entities.
7.***Ensure that the ERD is in 3NF***

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!