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
Attachment:- EntityRelationship Analysis.doc