| 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/20243/CST1600/41/16290651/Lab08/ |
Upload File : |
* (asterisk) to denote a primary key field. @ (at sign) to denote a foreign key field. ^ (caret) to denote a unique field that is not a primary key. UNF: employeework (employeeId*, name, SSN, projectWork, spouseName, spouseSSN, spouseIsInsured) 1NF:No employeework(employeeId*, name, SSN, projectCode*, projectName, date, hoursWorked, spouseName, spouseSSN, spouseIsInsured) 2NF:No employeework(employeeId*, name, SSN) project(projectCode*, projectName) work_entry(employeeId@, projectCode@, date@, hoursWorked) spouse(employeeId@, spouseName, spouseSSN, spouseIsInsured) 3NF:OK All data rows: employeework:(employeeId*, name, SSN, spouseName, spouseSSN, spouseInsured) 1, Avream Hinton, 123456789, Lucy Marritt, 234567890, No 2, Xerxes Hayes, 345678901, N/A, N/A, N/A) 3, Kristen Acosta, 456789012, Kylee Ascosta, 567890123, Yes 4, Harper Mcmahon, 567890123, N/A, N/A, N/A) project:(projectCode*, projectName) Chr0944, Dining room table chairs Tb10944, Dining room table Kit0944. Kitchen counters work_entry:(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-05, 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