Discuss the below:
Q: Draw the entity relationship diagram for the relationship between EMPLOYEE and JOB.
Employee
EMP_CODE | EMP_LNAME | JOB_CODE
14 Rudell 2
15 McDade 1
16 Ruellardo 1
17 Smith 3
20 Smith 2
Benefit
EMP_CODE | PLAN_CODE
15 2
15 3
16 1
17 1
17 3
17 4
20 3
Job
JOB_CODE | JOB_DESCRIPTION
1 Clerical
2 Technical
3 Managerial
Benefit
Plan
PLAN_CODE | PLAN_DESCRIPTION
1 Term Life
2 Stock Purchase
3 Long-life disability
4 Dental