Explore BrainMass
Share

Explore BrainMass

    Entity relationship diagram

    This content was COPIED 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 9, 2019, 9:41 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