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 24, 2018, 11:27 pm 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
See Also This Related BrainMass Solution

Mangement Analysis: Entity Relationship Diagram

Entity Relationship Diagram (ERD): What is the purpose of ERD? Can you explain using the below scenario? How can this be used to enhance my business?

AlohaPets put on events for local pet owners. The company needs a database designed to keep track of the sponsor for the event and where the event is located. Each event needs a description, data, and cost. Separate costs are negotiated for each event. The company would also like to have a list of potential sponsors that includes each sponsor's contact information, such as the name, phone number and address. Each event will have a single sponsor, but a particular sponsor may sponsor more than one event. Each location will need an ID, contact person, and phone number. A particular event will use only one location, but a location may be used for multiple events.

View Full Posting Details