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/20255/CST1600/41/13216232/Lab08/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/uploads/20255/CST1600/41/13216232/Lab08/ChaseAljets-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;2023-02-07; 	12
                                      				          
2,          Xerxes Hayes,   345678901, code;     name;                    date;       			hoursworked
                                       Kit0944; Kitchen counters;         2023-02-05;2023-02-06; 	16	
                                      				          
                                       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;2023-02-06; 	12		
                                       Chr0944; Dining room table chairs; 2023-02-05;	 		4
                                       




1NF:
Employee
 	   firstName,   lastName,       SSN,       projectWork,                                                  spouseName,   spouseSSN, spouseIsInsured
           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
           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
           Kristen 	Acosta, 	456789012,  code;     name;                   	date;       hoursworked, Kylee Acosta, 567890123, Yes
                                                    Kit0944;  Kitchen counters;       	2023-02-05; 8
           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

2NF:
Employees
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;2023-02-07; 	12
                                      				          
2,           Xerxes Hayes,  345678901, code;     name;                    date;       			hoursworked
                                       Kit0944; Kitchen counters;         2023-02-05;2023-02-06; 	16	
                                      				          
                                       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;2023-02-06; 	12		
                                       Chr0944; Dining room table chairs; 2023-02-05;	 		4

Project
Employee ID@	Projects
1		Dining room table chairs
1		Dining room table
1		Dining room table
2		Kitchen counters
2		Kitchen counters
2		Dining room table
3		Kitchen counters
4		Kitchen counters
4		Dining room table chairs
4		Kitchen counters




3NF:
Employees
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;2023-02-07; 	12
                                      				          
2,           Xerxes Hayes,   345678901, code;     name;                    date;       			hoursworked
                                       Kit0944; Kitchen counters;         2023-02-05;2023-02-06; 	16	
                                      				          
                                       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;2023-02-06; 	12		
                                       Chr0944; Dining room table chairs; 2023-02-05;	 		4

Project_Work
Project_Code*	Project_Name
Chr0944		Dining room table chairs
Tbl0944		Dining room table
Kit0944		Kitchen counters

Employee_Projects
Employee ID@	Project_Code@
1		Chr0944
1		Tbl0944
1		Tbl0944
2		Kit0944
2		Kit0944
2		Tbl0944
3		Kit0944
4		Kit0944
4		Chr0944
4		Kit0944

All data rows:
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

Anon7 - 2022
AnonSec Team