BCNF Example 2

Available under Creative Commons-ShareAlike 4.0 International License.

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 4^thFd.

Interview

StaffRoom

Figure 12.2 Source: http://db.grussell.org/section008.html