| 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/16422751/Lab08/ |
Upload File : |
UNF:
employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured)
1NF
- Primary key in employeework is employeeId as that is the indentifying feidl of each line
- projectwork has multiple values which violates 1NF so we will take this feild and create a new table called 'projectwork' to house this data this table will house-
‘code’ as the unique code that is given to a project.
‘name’ as the name of the project.
‘date’ as the date the employee worked on the project.
‘hours’ worked as the number of hours the employee worked on the project that day.
We also add a ‘projectId’ field to this table this is a unique id given to each person completing each task
- we are going to rename 'spouseIsInsured' to 'marriedTo' to make the name more relevant
- we will create a new table called 'spouseInformation' to hold all the spouse information ('spouseName' , 'spouseSSN', 'marriedTo') without given null values in the othe table
projectWork ( code, name, date, hours, projectId* , employeeId)
employeework (employeeId*, name, SSN,)
spouseInformation(spouseName, spouseSSN ,marriedTo^*)
2NF: the tables we have only has one primary key so none of the fields can be partially dependent so it is ok for 2NF
3NF: again since there is only primary keys all of the non primary keys In each table relys on the primary key so the tables are also in complice with 3NF
employeework
employeeId*, name, SSN,
1, Avram Hinton, 123456789,
2, Xerxes Hayes, 345678901,
3, Kristen Acosta, 456789012,
4, Harper Mcmahon, 567890123,
projectwork
employeeId, projectId*, code, name, date, hours,
1 1 Chr0944, Dining room table chairs, 2023-02-05, 8
1 2 Tbl0944, Dining room table, 2023-02-06, 6
1 3 Tbl0944, Dining room table, 2023-02-07, 6
2 4 Kit0944, Kitchen Counters, 2023-02-05, 8
2 5 kit0944, Kitchen Counters, 2023-02-06, 8
2 6 Tbl0944, Dining room table, 2023-02-07, 4
3 7 Kit0944, Kitchen Counter, 2023-02-05, 8
4 8 Kit0944, Kitchen counters, 2023-02-05, 4
4 9 Chr0944, Dining room table chairs, 2023-03-05, 4
4 10 Kit0944, Kitchen Counters, 2023-02-06, 8
spouseInformation
spouseName, spouseSSN, marriedTo*,
Lucy Merritt, 234567890, Avram Hinton
Kylee Acosta, 567890123, Kirsten Acosta