| 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/uploads/20253/CST1600/41/16347786/Lab08/ |
Upload File : |
UNF: employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured) 1NF: could be multiple projects employeework (employeeId*, name, SSN, spouseName, spouseSSN, spouseIsInsured) projectWork (employeeId*, projectCode*, projectName, date, hoursworked) 2NF: incase a project is canceled we don't want to lose the code or name employeework (employeeId*, name, SSN, spouseName, spouseSSN, spouseIsInsured) projectWork (employeeId*, projectCode*, date, hoursworked) project (projectCode*, projectName) 3NF: ok All data rows: This took the longest employee table employeeId | name | SSN | spouseName | spouseSSN | spouseIsInsured 1 Avram Hinton | 123456789 | Lucy Merritt | 234567890 | No 2 | Xerxes Hayes | 345678901 | NULL | NULL | NULL 3 | Kristen Acosta | 456789012 | kylee Acosta | 567890123 | Yes 4 | Harper Mcmahon | 567890123 | NULL | NULL | NULL project table projectCode | ProjectName Chr0944 | Dining room table chairs Tbl0944 | Dining room table Kit0944 | Kitchen counters projet work table employeeId | projectCode | date | hoursWorked 1 | Chr0944 | 2023-02-05 | 8 1 | Tbl0944 | 2023-02-06 | 6 1 | Tbl0944 | 2023-02-07 | 6 2 | Kit0944 | 2023-02-05 | 8 2 | Kit0944 | 2023-02-06 | 8 2 | Tbl0944 | 2023-02-07 | 4 3 | Kit0944 | 2023-02-05 | 8 4 | Kit0944 | 2023-02-05 | 4 4 | Chr0944 | 2023-02-05 | 4 4 | Kit0944 | 2023-02-06 | 8