| 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 : |
teacher table teacher_id subject teacher_age 111 Maths 38 111 Physics 38 222 Biology 38 333 Physics 40 333 Chemistry 40 One solution: Find PK teacher table teacher_id* subject* teacher_age 111 Maths 38 111 Physics 38 222 Biology 38 333 Physics 40 333 Chemistry 40 Fix 2NF, teacher_age does not depent on subject. Make a teacher_subject table and a teacher table teacher table teacher_id* teacher_age 111 38 222 38 333 40 teacher_subject table teacher_id*@ subject* 111 Maths 111 Physics 222 Biology 333 Physics 333 Chemistry Does not solve delete anomoly. Best solution was to decide that subject is an entity. So we have a subject table. teacher table teacher_id* teacher_age 111 38 222 38 333 40 teacher_subject table teacher_id*@ subjectId*@ 111 1 111 2 222 3 333 2 333 4 subject table subjectId* subject* 1 Maths 2 Physics 3 Biology 4 Chemistry