Assignment #4 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 HG 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. Identify the connectivity (1:1; 1:M; M:N) of each relationship. Identify the minimum cardinality (Optional=0; Mandatory =1) of each relationship. Add in attributes for each entity. Identify Attributes serving as the primary key (PK) in the parent table. Identify Attributes serving as the foreign key (FK) in the child or associative tables. Step 2 Relationship (1:1; 1:M; M:N) Cardinality Entity Min: Entity Max: Min: Max: Min: Max: : Min: Max: AaBbccbdEe Aa8bccdee AaBbCcDc ABCD Heading 1 Heading III III Normat No Spacing Step 1 Entity Name 1 Attribute Attribute Entity Name 2 Attribute Attribute Attribute Entity Name 3 Attribute Attribute Attribute Entity Name 4 Attribute Attribute Attribute Entity Name 5 Attribute Attribute Attribute