Consider the relation Interview CandidateNo InterviewDate-05088
Consider the relation Interview(CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo) and the following functional dependencies. <br>FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo <br>FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo <br>FD3 : StaffNo, InterviewDate -> RoomNo <br>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.2.
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 relation Interview is in 3NF
The relation Interview is in BCNF.
The FD3 violates 3NF.
The FD2 violates 2NF
