Explore BrainMass

Explore BrainMass

    Database help: Create an ERD, Relational Diagram, and do the tables exhibit entity integrity or referential integrity.

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    1.) Create the ERD to show the relationship between EMPLOYEE and JOB.
    2.) Create the relational diagram to show the relationship between EMPLOYEE and JOB.
    3.) Do the tables exhibit entity integrity? Yes or no and explain.
    4.) Do the tables exhibit referential integrity? Yes or no, then explain. Write not applicable if the table does not have a foreign key.
    5.) Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB AND PLAN.
    6.) Create the relational diagram to show the relationships among EMPLOYEE, BENEFIT, JOB AND PLAN.

    Please see attachment for full question details.

    © BrainMass Inc. brainmass.com March 5, 2021, 12:11 am ad1c9bdddf
    https://brainmass.com/computer-science/databases/create-erd-relational-diagram-tables-exhibit-490527

    Attachments

    Solution Preview

    Table name: EMPLOYEE Table name: BENEFIT
    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
    PLAN
    PLAN_CODE PLAN_DESCRIPTION
    1 Term life
    2 Stock purchase
    3 Long-term disability
    4 Dental
    Table name: JOB
    Table name: ...

    Solution Summary

    The expert creates an ERD, relational diagrams and determines whether tables exhibit entity integrity or referential integrity.

    $2.49

    ADVERTISEMENT