1. Computer Science
2. Data
3. Data Structures
4. Databases
5. 159625

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

Attachments

• EntityRelationship Analysis.doc