Reference no: EM13949229

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.