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/20243/CST1600/41/16241522/Lab08/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

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

1NF:
The provided table violates the first normal form (1NF) due to its structure where multiple pieces of information are 
grouped together in the projectWork column. This violates the rule of atomicity,
as the projectWork column contains multiple sets of data, causing repetition and making it difficult to discern individual values
To achieve the first normal form (1NF) for the provided data, we'll break down the initial unnormalized form into separate tables to eliminate repeating groups and ensure atomicity.
2NF:Both tables are already in 2NF as there are no partial dependencies. The primary keys and other attributes in the tables are functionally dependent on the primary key.ok

3NF:The tables are already in 3NF as there are no transitive dependencies present.ok

All data rows:
Employees Table:
name           | SSN       | spouseName   | spouseSSN  | spouseIsInsured
1           | Avram Hinton   | 123456789 | Lucy Merritt | 234567890  | No
2           | Xerxes Hayes   | 345678901 | -            | -          | -
3           | Kristen Acosta | 456789012 | Kylee Acosta | 567890123  | Yes
4           | Harper Mcmahon | 567890123 | -            | -          | -
ProjectWork Table:
employeeId@ | code     | name                    | date       | hoursWorked
1           | Chr0944  | Dining room table chairs| 2023-02-05| 8
1           | Tbl0944  | Dining room table       | 2023-02-06| 6
1           | Tbl0944  | Dining room table       | 2023-02-07| 6
2           | Kit0944  | Kitchen counters        | 2023-02-05| 8
2           | Kit0944  | Kitchen counters        | 2023-02-06| 8
2           | Tbl0944  | Dining room table       | 2023-02-07| 4
3           | Kit0944  | Kitchen counters        | 2023-02-05| 8
4           | Kit0944  | Kitchen counters        | 2023-02-05| 4
4           | Chr0944  | Dining room table chairs| 2023-02-05| 4
4           | Kit0944  | Kitchen counters        | 2023-02-06| 8

Anon7 - 2022
AnonSec Team