Table name: EMPLOYEE
|
EMPLOYEE
|
|
EMP_CODE
|
EMP_LNAME
|
JOB_CODE
|
|
14
|
Rudell
|
2
|
|
15
|
McDade
|
1
|
|
16
|
Ruellardo
|
1
|
|
17
|
Smith
|
3
|
|
20
|
Smith
|
2
|
Table name: JOB
|
JOB
|
|
JOB_CODE
|
JOB_DESCRIPTION
|
|
1
|
Clerical
|
|
2
|
Technical
|
|
3
|
Managerial
|
Table name: BENEFIT
|
BENEFIT
|
|
EMP_CODE
|
PLAN_CODE
|
|
15
|
2
|
|
15
|
3
|
|
16
|
1
|
|
17
|
1
|
|
17
|
3
|
|
17
|
4
|
|
20
|
3
|
Table name:PLAN
|
PLAN
|
|
PLAN_CODE
|
PLAN_DESCRIPTION
|
|
1
|
Term life
|
|
2
|
Stock purchase
|
|
3
|
Long-term disability
|
|
4
|
Dental
|
1.) Create the ERD to show the relationship between EMPLOYEE and JOB.
2.) Create the relational diagram to show the relationship between EMPLOYEE and JOB.
3.) Do the tables exhibit entity integrity? Yes or no and explain.
4.) Do the tables exhibit referential integrity? Yes or no, then explain. Write not applicable if the table does not have a foreign key.
5.) Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB AND PLAN.
6.) Create the relational diagram to show the relationships among EMPLOYEE, BENEFIT, JOB AND PLAN.