Share
Explore BrainMass

Entity relationship diagram

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

Attachments

Solution Summary

This solution provides an entity relationship diagram for various datasets

$2.19