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 description $($see below$)$ of the training group$$s operating environment. $($Hint: Some of the following sentences identify the volume of data rather than cardinalities. Can you tell which ones?$)$

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 cancelled. Therefore, it is possible that a course not 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.

Do the following based on the above narration:

A$.$ Define all the entities and their attributes. Use schema to represent entities and their attributes. $(1$ Mark$)$

INSTRUCTOR $($insID$,$ insFirstName, insLastName, insFaculty$)$

CLASS $($classID$,$ classNumTrainees, classStatus$)$

TRAINEE $($traineeID$,$ traineeFirstName, traineeLastName, traineePhNum$)$

COURSE $($crsCode$,$ crsName, crsCapacity, crsTime$)$

B$.$ Relate the entities together based on the narration. If any, break down a M:N relationship by introducing a bridge entity. $($Use the following table as a template$)(1$ Mark$)$

Entity Relationship Name Connectivity Entity

INSTRUCTOR CLASS

TRAINEE CLASS

COURSE CLASS

C$.$ Write down the business rules that govern each relationship. $(2$ Marks$)$

D$.$ Create an ER diagram using Erwin, clearly indicating model properties such as connectivity, cardinality, existence$-$dependence, etc. Copy the model from Erwin, paste it into a Word file and submit it$.$ Do not submit the Erwin file. $(3$ Marks$)$