Explore BrainMass

Explore BrainMass

    Relations - Determinants - Dependencies

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

    Consider the following relation definition and sample data:

    EmployeeName PeojectID TaskID Phone TotalHours
    Don 100A B-1 12345 12
    Don 100A P-1 12345 12
    Don 200B B-1 1345 12
    Don 200B P-1 12345 12
    Pam 100A C-1 67890 26
    Pam 200A C-1 67890 26
    Pam 200D C-1 67890 26

    PROJECT-HOURS (EmployeeName, ProjectID, TaskID, Phone, TotalHours)

    Where EmployeeName is the name of an employee
    ProjectID is the name of a project
    TaskID is the name standard work task
    Phone is the employee's telephone number
    TotalHours is the hours worked by the employee on this project
    Assuming that all of the functional dependencies and constraints are apparent in this data, which of the following statements is true?

    A. EmployeeName > ProjectID
    B. EmployeeName >> ProjecID
    C. EmployeeName > TaskID
    D. EmployeeName >> TaskID
    E. EmployeeName >: Phone
    F. EmployeeName >: TotalHours
    G. (EmployeeName, ProjectID) > TotalHours
    H. (EmployeeName, Phone) > TaskID
    I. ProjectID > TaskID
    J. TaskID > ProjectID

    Answer these questions:

    K. What are all of the determinants?
    L. Does this relation contain a partial dependency? If so, what is it?
    M. Does this relation contain a multi-value dependency? If so, what are the unrelated attributes?
    N. Redesign this relation to eliminate the modification anomalies. How many relations did you use? How many themes does each of your new relations contain?

    © BrainMass Inc. brainmass.com October 9, 2019, 8:08 pm ad1c9bdddf


    Solution Summary

    Relations are emphasized.