| 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/20253/CST1600/41/15812201/Lab08/ |
Upload File : |
UNF: employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured) 1NF: employeeId* name SSN projectCode^ projectName date hoursworked spouseName spouseSSN spouseIsInsured 1 Avram Hinton 123456789 Chr0944 Dining room table chairs 2023-02-05 8 Lucy Merritt 234567890 No 1 Avram Hinton 123456789 Tbl0944 Dining room table 2023-02-06 6 Lucy Merritt 234567890 No 1 Avram Hinton 123456789 Tbl0944 Dining room table 2023-02-07 6 Lucy Merritt 234567890 No 2 Xerxes Hayes 345678901 Kit0944 Kitchen counters 2023-02-05 8 NULL NULL NULL 2 Xerxes Hayes 345678901 Kit0944 Kitchen counters 2023-02-06 8 NULL NULL NULL 2 Xerxes Hayes 345678901 Tbl0944 Dining room table 2023-02-07 4 NULL NULL NULL 3 Kristen Acosta 456789012 Kit0944 Kitchen counters 2023-02-05 8 Kylee Acosta 567890123 Yes 4 Harper Mcmahon 567890123 Kit0944 Kitchen counters 2023-02-05 4 NULL NULL NULL 4 Harper Mcmahon 567890123 Chr0944 Dining room table chairs 2023-02-05 4 NULL NULL NULL 4 Harper Mcmahon 567890123 Kit0944 Kitchen counters 2023-02-06 8 NULL NULL NULL Note: 1. projectWork is a multi-valued attribute (it contains multiple entries per project per day). To bring it to 1NF, this should be split into separate records or tables. 2. spouseName, spouseSSN, spouseIsInsured can be NULL if the employee is unmarried, but since this data may vary across employees, they should be treated as optional attributes. 2NF: employeeId@Employees.employeeId projectCode^ 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 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 Note: 1. EmployeeName, SSN, spouseName, spouseSSN, spouseIsInsured are only related to the employeeId (not the combination of employeeId + projectCode + date), so they should be moved into a separate table. In the ProjectWork table, these attributes violate 2NF. 3NF: employeeId@Employees.employeeId projectCode^ 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 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 Note: There are no transitive dependencies in the Employees or ProjectWork tables. All attributes are either part of the primary key or directly dependent on the primary key. All data rows: 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 employeeId@Employees.employeeId projectCode^ 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 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