| 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/JimMartinson/Classes/CST1600/Week/12/ |
Upload File : |
Find PK. employee table emp_id* emp_name emp_address emp_dept* 101 Rick Delhi D001 101 Rick Delhi D002 123 Maggie Agra D890 166 Glenn Chennai D900 166 Glenn Chennai D004 This table is in 1NF. It is not 2NF, because not every field is dependent on the full PK. Make two tables. Decide that dept is an entity. So we end up with three tables, one for employee, one for dept, and one to link them. employee table emp_id* emp_name emp_address 101 Rick Delhi 123 Maggie Agra 166 Glenn Chennai dept table deptId* dept^ 1 D001 2 D002 3 D890 4 D900 5 D004 employee_dept table emp_id*@ deptId*@ 101 1 101 2 123 3 166 4 166 5