| 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/20255/CST1600/41/16607463/Lab08/ |
Upload File : |
UNF: employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured) 1NF: 2NF: 3NF: All data rows: 1NF: Issues Violating 1NF: Repeating groups in the projectWork field. Mixing of multiple values in one field (e.g., code; name; date; hoursworked in a single field). Resolution: Create separate tables for Employee, Project, WorkLog, and Spouse. Remove repeating groups by assigning a single value per field. 1NF Tables: Employee employeeId* name SSN^ 1 Avram Hinton 123456789 2 Xerxes Hayes 345678901 3 Kristen Acosta 456789012 4 Harper McMahon 567890123 Spouse employeeId@*[Employee.employeeId] spouseName spouseSSN^ spouseIsInsured 1 Lucy Merritt 234567890 No 3 Kylee Acosta 567890123 Yes Project projectCode* projectName Chr0944 Dining room table chairs Tbl0944 Dining room table Kit0944 Kitchen counters WorkLog employeeId@*[Employee.employeeId] projectCode@[Project.projectCode] date hoursWorked 1 Chr0944 2023-02-05 8 1 Tbl0944 2023-02-06 6 1 Tbl0944 2023-02-07 6 2 Kit0944 2023-02-05 8 2 Kit0944 2023-02-06 8 2 Tbl0944 2023-02-07 4 3 Kit0944 2023-02-05 8 4 Kit0944 2023-02-05 4 4 Chr0944 2023-02-05 4 4 Kit0944 2023-02-06 8 ✔ 1NF: All violations resolved. 2NF: Issue Violating 2NF: Partial dependency would exist if we used a composite key in WorkLog, which we avoided by keeping it minimal with appropriate foreign keys. 2NF: All tables are in 2NF. No partial dependencies exist. Each non-key attribute depends on the whole key. 3NF: Potential Issues: Ensure no transitive dependencies exist. Spouse table is already separated, so spouseIsInsured depends only on spouseSSN, not employeeId. 3NF: All non-key fields are fully and only dependent on their table's primary key. OK. All data rows: Employee employeeId name SSN 1 Avram Hinton 123456789 2 Xerxes Hayes 345678901 3 Kristen Acosta 456789012 4 Harper McMahon 567890123 Spouse employeeId spouseName spouseSSN spouseIsInsured 1 Lucy Merritt 234567890 No 3 Kylee Acosta 567890123 Yes Project projectCode projectName Chr0944 Dining room table chairs Tbl0944 Dining room table Kit0944 Kitchen counters WorkLog employeeId projectCode date hoursWorked 1 Chr0944 2023-02-05 8 1 Tbl0944 2023-02-06 6 1 Tbl0944 2023-02-07 6 2 Kit0944 2023-02-05 8 2 Kit0944 2023-02-06 8 2 Tbl0944 2023-02-07 4 3 Kit0944 2023-02-05 8 4 Kit0944 2023-02-05 4 4 Chr0944 2023-02-05 4 4 Kit0944 2023-02-06 8