Question
Normalize the following table to 3NF. State any assumptions you make about the data shown in the table. Student Id Student Name Subject Code Subject
Normalize the following table to 3NF. State any assumptions you make about the data shown in the table.
| Student Id | Student Name | Subject Code | Subject Name | Advisor Code | Advisor Name |
| S1011 | Ali | COMP211 | Programming | P33 | Dr. Roy |
| S1012 | Khurram | COMP233 | Database | P34 | Mr. Ijaz |
| S1013 | Aleena | COMP 234 | Networking | P44 | Mr. Waseem |
| S1014 | Hamza | COMP 333 | Web Design | P45 | Mr. Naushad |
| S1015 | Salem | COMP 444 | Cloud computing | P46 | Mr. Natrajan |
| S1016 | Muna | COMP 234 | Networking | P44 | Mr. Waseem |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Intelligent Information And Database Systems 6th Asian Conference Aciids 2014 Bangkok Thailand April 7 9 2014 Proceedings Part I 9 2014 Proceedings Part 1 Lnai 8397
Authors: Ngoc-Thanh Nguyen ,Boonwat Attachoo ,Bogdan Trawinski ,Kulwadee Somboonviwat
2014th Edition
