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 five Advanced Technology courses, each of which may generate several classes. If a class has fewer than ten 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 two classes or may be assigned to do research only. Each trainee may take up to two classes per year. Given that information, do the following: a. Identify all of the main entities, relations and connectivities among entities. ENTITY RELATIONSHIP CONNECTIVITY ENTITY b. Draw the ERD for HEG.
The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected
The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offers
five Advanced Technology courses, each of which may generate several classes. If
a class has fewer than ten 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 two classes or may be assigned to do research only. Each trainee may take up to two classes per year.
Given that information, do the following:
a. Identify all of the main entities, relations and connectivities among entities.
| ENTITY | RELATIONSHIP | CONNECTIVITY | ENTITY |
b. Draw the ERD for HEG.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
