| 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/16459598/Lab08/ |
Upload File : |
UNF:
employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured)
1NF:
employeework (employeeId*, First_Name, Last_Name, SSN, projectWork, code, project_name, date, hoursworked, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured)
[Changed name to First_Name, Last_Name. Changed spouseName to spouseFirstName, spouseLastName added code, project_name, date, and hoursworked fields.]
2NF:
employeInfo (employeeId*, First_Name, Last_Name, SSN, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured)
projectWork (SSN@ projectWork, code, project_name, date, hoursworked)
[Renamed employeework to employeInfo. Changed projectWork into a table and moved code, project_name, date, hoursworked into it.]
3NF:
employeInfo (employeeId*, First_Name, Last_Name, SSN)
projectWork (employeeId@, code, date, hoursworked)
Spouse (employeeId@, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured)
[Created Spouse table and moved spouseName, spouseSSN, spouseIsInsured into it. removed project_name.]
All data rows:
employeInfo (employeeId*, First_Name, Last_Name, SSN)
1 Avram Hinton 123456789
2 Xerxes Hayes 345678901
3 Kristen Acosta 456789012
4 Harper Mcmahon 567890123
projectWork (employeeId@, code, date, hoursworked)
1 Chr0944 2023-02-05 20
1 Tbl0944 2032-02-06
1 tbl0944 2032-02-07
2 Kit0944 2023-02-05 20
2 Kit0944 2023-02-06
2 Tbl0944 2023-02-07
3 Kit0944 2023-02-05 8
4 Kit0944 2023-02-05 16
4 Chr0944 2023-02-05
4 Kit0944 2023-02-06
Spouse (employeeId@, spouseFirstName, spouseLastName spouseSSN, spouseIsInsured)
1 Lucy Merritt 234567890 No
3 Kylee Acosta 567890123 Yes