Explore BrainMass
Share

Entity relationship diagram

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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

© BrainMass Inc. brainmass.com October 16, 2018, 4:17 am ad1c9bdddf - https://brainmass.com/computer-science/data/entity-relationship-diagram-194515

Attachments

Solution Summary

This solution provides an entity relationship diagram for various datasets

$2.19