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/20245/CST1600/41/15123653/Lab08/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /nginx/html/uploads/20245/CST1600/41/15123653/Lab08/AmeeraAbdelaziz-Lab08.txt
UNF:
employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured)
employeeId*, name,          SSN,       projectWork,                                                spouseName,   spouseSSN, spouseIsInsured
1,           Avram Hinton,  123456789, code;    projectName;              date;       hoursworked, Lucy Merritt, 234567890, No
                                       Chr0944; Dining room table chairs; 2023-02-05; 8
                                       Tbl0944; Dining room table;        2023-02-06; 6
                                       Tbl0944; Dining room table;        2023-02-07; 6
2,          Xerxes Hayes,   345678901, code;     name;                    date;       hoursworked
                                       Kit0944; Kitchen counters;         2023-02-05; 8
                                       Kit0944; Kitchen counters;         2023-02-06; 8
                                       Tbl0944; Dining room table;        2023-02-07; 4
3,          Kristen Acosta, 456789012, code;    name;                     date;       hoursworked, Kylee Acosta, 567890123, Yes
                                       Kit0944; Kitchen counters;         2023-02-05; 8
4,          Harper Mcmahon, 567890123, code;    name; date; hoursworked
                                       Kit0944; Kitchen counters;         2023-02-05; 4
                                       Chr0944; Dining room table chairs; 2023-02-05; 4
                                       Kit0944; Kitchen counters;         2023-02-06; 8
1NF:
The table violates 1NF because the "projectWork" field contains multiple values related to the work the employee performs. Also, the fields "name", "spouseName", "spouseSSN", and "spouseIsInsured" are repeating groups.

Create Tables:
employee(employeeId*, name, SSN)
projectwork(employeeId*@,code, projectName, date, hoursworked)
spouse(employeeId*@,spouseName, spouseSSN, spouseIsInsured)

2NF:
OK

3NF:
OK

All data rows:
employeework:
 employeeId*  name           SSN        spouseName    spouseSSN   spouseIsInsured 
 1            Avram Hinton   123456789  Lucy Merritt  234567890   No              
 2            Xerxes Hayes   345678901  NULL          NULL        NULL            
 3            Kristen Acosta 456789012  Kylee Acosta  567890123   Yes             
 4            Harper Mcmahon 567890123  NULL          NULL        NULL            

projects:
 employeeId*  projectWork  projectName                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           
 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           

spouse:
 employeeId*  spouseName    spouseSSN   spouseIsInsured 
 1            Lucy Merritt  234567890   No              
 3            Kylee Acosta  567890123   Yes

Anon7 - 2022
AnonSec Team