Chap4 Tutorial2 answer0 1 .docx - Chapter 4 ER Modeling...

Chapter 4 ER Modeling Tutorial 4-2
The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose
application will meet the expected database requirements for the company’s training program.
The HEG administrator gives you the following description of the training group’s operating
environment.
The HEG has 12 instructors and can handle up to 30 trainees per class . HEG offers 5 Advanced
Technology courses , each of which may generate several classes. If a class has fewer than 10
trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes.
Each class is taught by one instructor. Each instructor may teach up to 2 classes or may be
assigned to do research only. Each trainee may take up to 2 classes per year.
Given that information, do the following:
a. Draw the ER diagram.
b. Describe the relationship between instructor and class in terms of connectivity,
cardinality, and existence dependence.

Chapter 4 ER Modeling