Home » Other » General » Help me to understand MVD
Help me to understand MVD [message #665155] Wed, 23 August 2017 09:00 Go to next message
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]
  • Attachment: questions.PNG
    (Size: 27.80KB, Downloaded 1093 times)

[Updated on: Mon, 02 October 2017 00:09] by Moderator

Report message to a moderator

Re: Help me to understand MVD [message #665175 is a reply to message #665155] Thu, 24 August 2017 04:00 Go to previous message
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
This doesn't have anything to do with Oracle but you might be able to find some more reading here.
Previous Topic: Oracle licensing worst
Next Topic: Issue with sending Swedish characters to table via SQLPLUS
Goto Forum:

Current Time: Fri Jun 05 05:08:01 CDT 2020