Chapter 4, Problem 5P

a.

Program Plan Intro

Entity Relationship (ER) Diagram:

The following figure illustrates the ER Diagram for Hudson Engineering Group in (HEG) Crow’s Foot notation:

Explanation:

• In above ERD, A trainee can take several class and each class can have more trainees, so there is an “M: N” relationship between the entities TRAINEE and CLASS. Hence a composite entity “ENROLLMENT” is act as bridge between those entities.
  • The relationship between the entities INSTRUCTOR and CLASS is 1: M. Because a class is taken by only one instructor but an instructor can take more classes.
  • The relationship between the entities COURSE and CLASS is also1: M.

b.

Explanation of Solution

Relationship:

The relationship between the entities INSTRUCTOR and CLASS is 1: M. Because a class is taken by only one instructor but an instructor can take several classes...