| 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/16843769/Lab08/ |
Upload File : |
UNF:
employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured)
1NF:
Notes:
1)projectWork was also causing multiple hours to show on the same date.
2)Got rid of projectWork and split it up.
3)Made project_hours to find total hours in one date. To stop multiple hours being logged on one day.
4)projectName and employeeName to make the difference when splitting projectWork for no confusion.
employee_id(employeeID*)
project_code(code*)
employee(employeeID*@, employeeName, SSN)
spouse(employeeID*@, spouseName, spouseSSN, spouseIsInsured)
project_hours(employeeID*@, date, hoursworked)
projects(code*@, projectName)
employee_projects(employeeID*@, code*@)
2NF:
1)OK
3NF:
1)OK
employee_id(employeeID*)
project_code(code*)
employee(employeeID*@, employeeName, SSN)
spouse(employeeID*@, spouseName, spouseSSN, spouseIsInsured)
project_hours(employeeID*@, date, hoursworked)
projects(code*@, projectName)
employee_projects(employeeID*@, code*@)
All data rows:
employee_id (employeeID*)
1
2
3
4
project_code (code*)
Chr0944
Tbl0944
Kit0944
employee (employeeID*@, employeeName, SSN)
1, Avram Hinton, 123456789
2, Xerxes Hayes, 345678901
3, Kristen Acosta, 456789012
4, Harper Mcmahon, 567890123
spouse (employeeID*@, spouseName, spouseSSN, spouseIsInsured)
1, Lucy Merrit, 234567890, No
2, null, null, null
3, Kylee Acosta, 567890123, Yes
4, null, null, null
project_hours(employeeID*@, data, hoursworked)
1, 2023-02-05, 8
1, 2023-02-06, 6
1, 2023-02-07, 6
2, 2023-02-05, 8
2, 2023-02-06, 8
2, 2023-02-07, 4
3, 2023-02-05, 8
4, 2023-02-05, 8
4, 2023-02-06, 8
projects (code*@, projectName)
Chr0944, Dining room table chairs
Tbl0944, Dining room table
Kit0944, Kitchen counters
employee_projects (employeeID*@, code*@)
1, Chr0944
1, Tbl0944
2, Tbl0944
2, Kit0944
3, Kit0944
4, Kit0944
4, Chr0944
---