| 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/JimMartinson/Classes/CST1600/Week/11/ |
Upload File : |
* = primary key (PK) @ = foreign key (FK) ^ = unique field (UNI) Client_Interview(ClientNo, InterviewDate, InterviewTime, StaffNo, RoomNo) 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 SG37 G102 CR56 1-July-02 10.30 SG5 G102 3NF: Deleting an interview can delete staff and room information. Need a table for staff and rooms. Make a StaffRoom table to link staff to rooms. Rename tables. Staff(StaffNo*) SG5 SG37 Client_Interview2(ClientNo*, InterviewDate*@, InterViewTime*, StaffNo@) 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*@) StaffNo InterviewDate RoomNo SG5 13-May-02 G101 SG37 13-May-02 G102 SG5 1-July-02 G102 Room(RoomNo*) RoomNo G101 G102 G102