| 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 a primary key of code* and fields called project, date, and hoursWorked 2) I replaced spouseName with spouseFirstName and spouseLastName so there is not a repeat in data or multiple values employees (employeeId*, firstName, lastName, SSN, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured) projectwork (code*, project, date, hoursWorked) 2NF: Note: Code being unique only allows working only once on a project 1) I will first make a new table called employeeprojects with two foreign keys of employeeid*@ and code*@ then two fields of date and hoursWorked so there can be multiple dates worked on one project 2) I will rename project work to projectinfo with a primary key of code* and a foreign key of projectName so each project is listed out employees (employeeId*, firstName, lastName, SSN, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured) employeework (employeeId*@, code*@, date, hoursWorked) projectinfo (code*, projectName) 3NF: Note: Everything is based on employeeId* OK All data rows: employees (employeeid*, firstName, lastName, SSN, spouseFirstName, spouseLastName, spouseSSN, spouseIsInsured) 1 avram hinton 123456789 lucy merritt 234567890 No 2 Xerxes Hayes 345678901 3 Kristen Acosta 456789012 Kylee Acosta 567890123 Yes 4 Harper Mcmahon 567890123 employeework (employeeid*@, Date, hoursWorked, code*@) 1 2/5/2023 8 Chr0944 1 2/6/2023 6 Tbl0944 1 2/7/2007 6 Tbl0944 2 2/5/2023 8 Chr0944 2 2/6/2023 8 Tbl0944 2 2/7/2023 4 Tbl0944 3 2/5/2023 8 Kit0944 4 2/5/2023 4 Kit0944 4 2/5/2023 4 Chr0944 4 2/6/2023 8 Kit0944 projectinfo (Code*, projectName) Chr0944 Dining room table chairs Kit0944 Kitchen counters Tbl0944 Dining room table