| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/MichaelMalz/CST1600/_Examples/Normilization/ |
Upload File : |
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.