Database Design 2nd Edition pp70

3NF:
Client_Interview:
ClientNo InterviewDate InterviewTime StaffNo RoomNo
CR76     13-May-02     10:30         SG5     G101
CR56     13-May-02     12:00         SG5     G101
CR74     13-May-02     12:00         SG3     G102
CR56     1-July-02     10:30         SG5     G102

BCNF:
Client_Interview2:
ClientNo	InterviewDate	InterViewTime	StaffNo
CR76 		13-May-02 		10.30 			SG5
CR56 		13-May-02 		12.00 			SG5
CR74 		13-May-02 		12.00 			SG37
CR56 		1-July-02 		10.30 			SG5
StaffRoom:
StaffNo InterviewDate	RoomNo
SG5 	13-May-02 		G101
SG37 	13-May-02 		G102
SG5 	1-July-02 		G102

Ensure that no client can have a meeting at the same date/time.
Ensure that no room can have a meeting at the same date/time.
Ensure that no staff can have a meeting at the same date/time.
Ensure that a meeting must have a client, a room, and staff.

4NF:
client         (ClientNo*)
room           (RoomNo*)
staff          (StaffNo*)
client_meeting (ClientNo*@, InterviewDate*, InterviewTime*)
room_meeting   (RoomNo*@, InterviewDate*, InterviewTime*)
staff_meeting  (StaffNo*@, InterviewDate*, InterviewTime*)

Ensure that a meeting must have a client, a room, and staff.
	This cannot be ensured by the database, only through program logic.