| 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/16318726/Lab08/ |
Upload File : |
UNF:
employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured)
1NF:
Note: Name, projectWork, and spouseName all have multiple values
1) First I will replace the name attribute for two different attributes called firstName and lastName. Then I will make a new table called projectwork with code* as the primary key and the foreign key being employeeId*@ the fields being projectName, date, and hoursWorked and remove projectWork from the employeework table.
2) I replaced spouseName with spouseFirstName and spouseLastName so there is not a repeat in data or multiple values
employeework (employeeId*, firstName, lastName, SSN, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured)
projectwork (projectId*, employeeId*@, code^, project, date, hoursWorked)
2NF:
Note: things related to spouse are soley dependent on primary employeeId*
1) I will make a table called spouse with spouseId* as the primary key and employeeId*@ as the foreign key. Then will move spouseFirstName, spouseLastName, spouseSSN, and spouseIsInsured to the spouse table to give an area for soley the spouse
employeework (employeeId*, firstName, lastName, SSN)
spouse (spouseId* employeeId*@, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured)
projectwork (projectId* employeeId*@, code^, project, date, hoursWorked)
3NF:
Note: Everything is based on employeeId*
OK
All data rows:
employeework (employeeId*, firstName, lastName, SSN)
1, Avram, Hinton, 123456789
2, Xerxes, Hayes, 345678901
3, Kristen, Acosta, 456789012
4, Harper, Mcmahon, 567890123
spouse (spouseId* employeeId*@, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured)
1, 1, Lucy, Merritt, 234567890, No
2, 3, Kylee, Acosta, 567890123, Yes
projectwork (projectId* employeeId*@, code^, project, date, hoursWorked)
1, 1, Chr0944; Dining room table chairs; 2023-02-05; 8
2, 1, Tbl0944; Dining room table; 2023-02-06; 6
3, 1, Tbl0944; Dining room table; 2023-02-07; 6
4, 2, Chr0944; Dining room table chairs; 2023-02-05; 8
5, 2, Tbl0944; Dining room table; 2023-02-06; 6
6, 2, Tbl0944; Dining room table; 2023-02-07; 6
7, 3, Kit0944; Kitchen counters; 2023-02-05; 8
8, 4, Kit0944; Kitchen counters; 2023-02-05; 4
9, 4, Chr0944; Dining room table chairs; 2023-02-05; 4
10, 4, Kit0944; Kitchen counters; 2023-02-06; 8