Consider the relation Interview CandidateNo InterviewDate-05093
Consider the relation Interview (CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo) and the following functional dependencies.</strong><br/>FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo<br/>FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo<br/>FD3 : StaffNo, InterviewDate -> RoomNo<br/><strong>Which of the following is correct?
This multiple choice question (MCQ) is related to the book/course
vu cs403 Database Management Systems.
It can also be found in
vu cs403 Mid Term - Quiz No.3.
Consider the relation Interview (CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo) and the following functional dependencies.
FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo
FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo
FD3 : StaffNo, InterviewDate -> RoomNo
Which of the following is correct?
FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo
FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo
FD3 : StaffNo, InterviewDate -> RoomNo
Which of the following is correct?
The FD3 violates 3NF.
The relation Interview is in 3NF
The relation Interview is in BCNF.
The FD2 violates 2NF.
