Client Interview Table
Fd1 – ClientNo, InterviewDate –> interviewTime, staffNo, roomNo (PK)
Fd2 – staffNo, InterviewDate, InterviewTime –> ClientNO (CK)
Fd3 – roomNo, InterviewDate, InterviewTime –> StaffNo, clientNo (CK)
Fd4 – staffNo, interviewDate –> roomNo
A relation is in BCNF if and only if every determinant is a candidate key. We need to create a table that incorporates the first 3 Fds and another table for the 4thFd.