Question

1. 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 me 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 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:

1. Define all the entities and relationships. (use the below table as a guide)

ENTITY	RELATIONSHIP	CONNECTIVITY	ENTITY
X	verb	1:M	Y

Note that X refers to an entity in the narrative. The verb in the table shows the relationship. For e.g. students enroll in a course.

ii.      Create the necessary ERD for HEG. [Hint: Pay Attention to connectivity, cardinality, and existence-dependence.]

Answer 1

ENTITY	RELATIONSHIP	CONNECTIVITY	ENTITY
TRAINEE	Trainee instructed by an Instructor	M:1	INSTRUCTOR
INSTRUCTOR	Instructor instructs trainees	1:M	TRAINEE
COURSE	Course has classes	1:M	CLASS
CLASS	Classes belongs to Course	M:1	COURSE
CLASS	Class tought by an Instructor	M:1	INSTRUCTOR
INSTRUCTOR	Instrucrotr teaches classes	1:M	CLASS
ENROLL	Trainee enroll for classes	M:N	CLASS

ERD

INSTRUCTOR TRAINEE PK InstructorID 1 PK Traineel 1..30 Name Name Instructs Phone Phone teaches entoll to Qualification Address FK Instructorld ..2 1..2 COURSE CLASS ENROLL PK CourselD PK ClassID enroll PK,FK1 Traineeld Name Name 1 0..M PK,FK2 ClassID 10.M Duration Duration has StartDate Fees FK TutorID EndDate FK Coursel

• Some of the attributes of entities are shown in the ERD
• The primary keys of each entity are shown in the ERD'
• The foreign keys of each entity are shown in the ERD'
• The relationships are shown by using connecting lines with entities
• Cardinalities are represented in the connecting lines

Answer 2

ESTION ONE (1) 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 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 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 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) Define all the ENTITIES. b) Describe the RELATIONSHIPS between ENTITIES in terms of CONNECTIVITY, CARDINALITY, and EXISTENCE DEPENDENCE.