| 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 : /nginx/html/uploads/20245/CST1600/41/15446424/Lab08/ |
Upload File : |
UNF: employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured) 1NF: multipul values in the projectWork which should be a 2nd table itself. employee(employeeId*, name, SSN, spouseID*@) projectWork(code*, name) employeeProjectHours(employeeId*@, code*@, date, hoursWorked) spouse(spouseId*, spouseName, spouseSSN, spouseIsInsured) 2NF: ok 3NF: employee(employeeId*, name, SSN, spouseID*@) projectWork(code*, name) spouse(spouseId*, spouseName, spouseSSN, spouseIsInsured) employeeProjectHours(employeeId*@, code*@, date, hoursWorked) All data rows: sample data: employeeId*, name, SSN, spouseId* 1, Avram Hinton, 1234567890, 1 2, Xerxes Hayes, 3456789012, 3, Kristen Acosta, 4567890123, 2 4, Harper Mcmahon, 567890123, code*, name Chr0944, Diningroom table chairs Tbl0944, Dining room table Kit0944, Kitchen counters spouseId*, spouseName, spouseSSN, spouseIsInsured 1, Lucy Merritt, 234567890, no 2, Kylee Acosta, 567890123, yes employeeId*@, code*@, 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