| Help me to understand MVD [message #665155] |
Wed, 23 August 2017 09:00  |
 |
oceanb70
Messages: 1
Registered: August 2017
|
Junior Member |
|
|
Sorry, i can't find a better place to ask and i thought there got alot of expert
this is my first time studying multivalued dependencies and there is a question that post by my lecturer as a class exercise. I had completed the answer but I have doubt on it. Please tell me where I did wrong?
see attached for question
My answer will be as follow
Multi-valued dependencies
courseCode -->-> lecturerId
courseCode -->-> (startDate, StartTime)
(courseCode, startDate, StartTime) -->-> learnerId
learnerId -->-> (courseCode, startDate)
Functional dependencies
courseCode --> (courseName, weeklyHours, noofWeeks)
(courseCode, startDate,StartTime) --> lecturerId
(courseCode, lecturerId) --> (startDate, StartTime)//i'm not sure if this is even needed
lecturerId --> (lecturerName, lecturerEmail, lecturerGender)
learnerId --> (learnerName, learnerEmail)
[mod-edit: image inserted into message body by bb]
[Updated on: Mon, 02 October 2017 00:09] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
