Explore BrainMass
Share

Explore BrainMass

    FDD Diagram

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

    Draw the FDD from the FD below

    FD
    1) Student must be signed up for at least one Course
    i) Registration Code ->Course Name

    2) Given student may have taken a given exam on a certain date, receiving a grade for it:
    i) StudentRegistrationNumber + Course code + Date ->Mark

    3) A Course will be taught be only one Lecturer
    i) Course_code->employee number

    4) A Course is presented in one or more classrooms, on prescribed days and times
    Please help with the following problem.

    i) Course + day + time -> classroom

    5) Students are each assigned a lecturer as a Personal Tutor
    i) Registration Code -> employee number

    I derived these FD from the given attributes
    The attributes are found in the attachment
    Correct me if I am wrong
    Please refer to this link on how to draw a FDD http://www.dsm.fordham.edu/~moniot/Classes/DatabaseSp04/FD-diagrams.html

    © BrainMass Inc. brainmass.com October 9, 2019, 8:41 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/fdd-diagram-159625

    Attachments

    Solution Preview

    FD
    1) Student must be signed up for at least one Course
    i) Registration_Code ->Course_code

    2) Given student may have taken a given ...

    Solution Summary

    This solution helps with a problem regarding FDD diagrams.

    $2.19