| 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/20255/CST1600/41/11365835/Lab08/ |
Upload File : |
UNF:
employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured)
employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured
1, Avram Hinton, 123456789, code; projectName; date; hoursworked, Lucy Merritt, 234567890, No
Chr0944; Dining room table chairs; 2023-02-05; 8
Tbl0944; Dining room table; 2023-02-06; 6
Tbl0944; Dining room table; 2023-02-07; 6
2, Xerxes Hayes, 345678901, code; name; date; hoursworked
Kit0944; Kitchen counters; 2023-02-05; 8
Kit0944; Kitchen counters; 2023-02-06; 8
Tbl0944; Dining room table; 2023-02-07; 4
3, Kristen Acosta, 456789012, code; name; date; hoursworked, Kylee Acosta, 567890123, Yes
Kit0944; Kitchen counters; 2023-02-05; 8
4, Harper Mcmahon, 567890123, code; name; date; hoursworked
Kit0944; Kitchen counters; 2023-02-05; 4
Chr0944; Dining room table chairs; 2023-02-05; 4
Kit0944; Kitchen counters; 2023-02-06; 8
1NF:
Employee
Employee_ID* Name SSN Project_Work_Code* Project_Name Date Hours_Worked Spouse_Name Spouse_SSN Spouse_Insured
1 Avram Hinton 123-45-6789 Chr0944 Dining Room Table Chairs 2023-02-05 8 Lucy Merritt 234-56-7890 No
1 Avram Hinton 123-45-6789 Tbl0944 Dining Room Table 2023-02-06 6 Lucy Merritt 234-56-7890 No
1 Avram Hinton 123-45-6789 Tbl0944 Dining Room table 2023-02-07 6 Lucy Merritt 234-56-7890 No
2 Xerxes Hayes 345-67-8901 Kit0944 Kitchen Counters 2023-02-05 8
2 Xerxes Hayes 345-67-8901 kit0944 Kitchen Counters 2023-02-07 8
2 Xerxes Hayes 345-67-8901 Tbl0944 Dining Room Table 2023-02-07 4
3 Kristen Acosta 456-78-9012 Kit0944 Kitchen Counters 2023-02-05 8 Kylee Acosta 567-89-0123 Yes
4 Harper Mcmahon 567-89-0123 Kit0944 Kitchen Counters 2023-02-05 4
4 Harper Mcmahon 567-89-0123 Chr0944 Dining Room Table Chairs 2023-02-05 4
4 Harper Mcmahon 567-89-0123 Kit0944 Kitchen Counters 2023-02-06 8
Table Changes: Separated data to eliminate separation of data by comma or semicolons; changed SpouseIsInsured column name to shorten it.
2NF:
Employee
Employee_ID* Emp_Name Emp_SSN Spouse_Name Spouse_SSN Spouse_Insured
1 Avram Hinton 123-45-6789 Lucy Merritt 234-56-7890 No
2 Xerxes Hayes 345-67-8901
3 Kristen Acosta 456-78-9012 Kylee Acosta 567-89-0123 Yes
4 Harper Mcmahon 567-89-0123
Project
Employee_ID* Project_Code* Project_Name Date_Worked Hours_Worked
1 Chr0944 Dining Room Table Chairs 2023-02-05 8
1 Tbl0944 Dining Room Table 2023-02-06 6
1 Tbl0944 Dining Room Table 2023-02-07 6
2 Kit0944 Kitchen Counters 2023-02-05 8
2 Kit0944 Kitchen Counters 2023-02-07 8
2 Tbl0944 Dining Room Table 2023-02-07 4
3 Kit0944 Kitchen Counters 2023-02-05 8
4 Kit0944 Kitchen Counters 2023-02-05 4
4 Chr0944 Dining Room Table Chairs 2032-02-05 4
4 Kit0944 Kitchen Counters 2023-02-06 8
Table Changes: Shortened project code name for easier reading, and added additional table for work project information. Also, renamed SSN, Name, and Date for information clarification.
3NF:
Employee
Employee_ID* Emp_Name Emp_SSN
1 Avram Hinton 123-45-6789
2 Xerxes Hayes 345-67-8901
3 Kristen Acosta 456-78-9012
4 Harper Mcmahon 567-89-0123
Project
Employee_ID* Project_Code* Project_Name Date_Worked Hours_Worked
1 Chr0944 Dining Room Table Chairs 2023-02-05 8
1 Tbl0944 Dining Room Table 2023-02-06 6
1 Tbl0944 Dining Room Table 2023-02-07 6
2 Kit0944 Kitchen Counters 2023-02-05 8
2 Kit0944 Kitchen Counters 2023-02-07 8
2 Tbl0944 Dining Room Table 2023-02-07 4
3 Kit0944 Kitchen Counters 2023-02-05 8
4 Kit0944 Kitchen Counters 2023-02-05 4
4 Chr0944 Dining Room Table Chairs 2032-02-05 4
4 Kit0944 Kitchen Counters 2023-02-06 8
Employee_Spouse
Employee_ID* Spouse_Name Spouse_SSN Spouse_Insured
1 Lucy Merritt 234-56-7890 No
3 Kylee Acosta 567-89-0123 Yes
Table Changes: Created table for employee spouse information.
All data rows:
Employee
Employee_ID* Emp_Name Emp_SSN
1 Avram Hinton 123-45-6789
2 Xerxes Hayes 345-67-8901
3 Kristen Acosta 456-78-9012
4 Harper Mcmahon 567-89-0123
Project
Employee_ID* Project_Code* Project_Name Date_Worked Hours_Worked
1 Chr0944 Dining Room Table Chairs 2023-02-05 8
1 Tbl0944 Dining Room Table 2023-02-06 6
1 Tbl0944 Dining Room Table 2023-02-07 6
2 Kit0944 Kitchen Counters 2023-02-05 8
2 Kit0944 Kitchen Counters 2023-02-07 8
2 Tbl0944 Dining Room Table 2023-02-07 4
3 Kit0944 Kitchen Counters 2023-02-05 8
4 Kit0944 Kitchen Counters 2023-02-05 4
4 Chr0944 Dining Room Table Chairs 2032-02-05 4
4 Kit0944 Kitchen Counters 2023-02-06 8
Employee_Spouse
Employee_ID* Spouse_Name Spouse_SSN Spouse_Insured
1 Lucy Merritt 234-56-7890 No
3 Kylee Acosta 567-89-0123 Yes