Explore BrainMass

Explore BrainMass

    3NF database design based on functional dependencies

    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!

    Consider the following functional dependencies:
    Applicant_ID -> Applicant_Name
    Applicant_ID -> Applicant_Address
    Position_ID -> Positoin_Title
    Position_ID -> Date_Position_Opens
    Position_ID -> Department
    Applicant_ID + Position_ID -> Date_Applied
    Applicant_ID + Position_ID + Date_Interviewed ->

    a. Represent these attributes with 3NF relations. Provide meaningful relation names.
    b. Represent these attributes using an E-R diagram. Provide meaningful entity names.

    © BrainMass Inc. brainmass.com October 4, 2022, 3:05 pm ad1c9bdddf

    Solution Summary

    Solution is a bitmap image of an E-R diagram (ERD) showing tables holding the data with 3NF relations marked.