Question: Modern businesses tend to provide continuous training to keep their employees productive in a fast-changing and competitive world. In addition, government regulations often require certain
Modern businesses tend to provide continuous training to keep their employees productive in a fast-changing and competitive world. In addition, government regulations often require certain types of training and periodic retraining. (For example, pilots must take semiannual courses involving weather, air regulations, and so on.) To make sure that an organization can track all training received by each of its employees, trace the development of the ERD segment in Figure QC.6 from the initial business rule that states:
An employee can take many courses, and each course can be taken by many employees. Once you have traced the development of the ERD segment, verify it and then provide sample data for each of the three tables to illustrate how the design would be implemented.
Figure QC.6:

EMPLOYEE TRAINING COURSE is used in PK EMP NUM H+ OPK,FK2 EMP NUM PK,FK1 +PK COURSE CODE receives COURSE CODE
Step by Step Solution
3.46 Rating (169 Votes )
There are 3 Steps involved in it
The composite TRAINING entity shown in Figure QC6 reflects part of the verification process that began with the MN relationship between EMPLOYEE and COURSC An employee can take many courses and many e... View full answer
Get step-by-step solutions from verified subject matter experts
