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
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)

/forum/fa/13604/0/

[mod-edit: image inserted into message body by bb]
  • Attachment: questions.PNG
    (Size: 27.80KB, Downloaded 2757 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
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, 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: Thu Mar 28 06:18:58 CDT 2024