| 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/14709590/Lab08/ |
Upload File : |
UNF:
employeework (employeeId*, name, SSN^, projectWork, spouseName, spouseSSN, spouseIsInsured)
1NF:
employees (employeeID*, name, SSN^, spouseName, spouseSSN, spouseIsInsured)
projects (employeeID@, projectCode*, projectName, projectDate, hoursWorked)
2NF:
employees (employeeID*, name, SSN^, spouseName, spouseSSN, spouseIsInsured)
projects (projectCode*, projectName)
projectinfo (employeeID@, projectCode@, projectDate, hoursWorked)
3NF:
employees (employeeID*, name, SSN^)
spouses (employeeID@, spouseName, spouseSSN^, spouseIsInsured)
projects (projectCode*, projectName)
projectinfo (employeeID@, projectCode@, projectDate, hoursWorked)
All data rows:
employees {
employeeID* name SSN^
1 Avram Hinton 123456789
2 Xerxes Hayes 345678901
3 Kristen Acosta 456789012
4 Harper Mcmahon 567890123
}
spouses {
employeeID@ spouseName spouseSSN spouseIsInsured
1 Lucy Merritt 234567890 No
3 Kylee Acosta 567890123 Yes
}
projects {
projectCode* projectName
Chr0944 Dining room table chairs
Tbl0944 Dining room table
Kit0944 Kitchen counters
}
projectinfo {
employeeID@ projectCode@ projectDate* 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
}