Question
Normalise the table below to 3NF. Describe each of the steps involved aided by dependency diagrams. Label all partial and transitive dependencies in the dependency
Normalise the table below to 3NF. Describe each of the steps involved aided by dependency diagrams. Label all partial and transitive dependencies in the dependency diagram as well as the normal form of the table.
Note: You only have to draw the dependency diagrams. you do not need to redraw the table.
TEAM_ID | TEAM_NAME | STUD_ID | STUD_ NAME | MAJOR_ CODE | MAJOR_ DESC | FAC_ CODE | FAC_ DESC |
T001 | Decepticons | 123518 | Ahmad | AI | Artificial Intelligence | CS | Computer Science |
|
| 122548 | Brad | AI | Artificial Intelligence | CS | Computer Science |
|
| 115224 | Hock | NANO | Nanotech | EE | Electrical and Electronics |
|
| 115488 | Eve | SE | Software Engineering | CS | Computer Science |
T002 | Autobots | 121589 | Chris | AI | Artificial Intelligence | CS | Computer Science |
|
| 123334 | Jane | SEC | Security | CS | Computer Science |
|
| 236587 | Siti | EE | Electrical/ Electronics | EE | Electrical and Electronics |
|
| 123123 | Selvan | AI | Artificial Intelligence | CS | Computer Science |
T003 | Transformers | 112558 | Sandeep | EE | Electrical/ Electronics | EE | Electrical and Electronics |
|
| 232569 | Kenneth | SE | Software Engineering | CS | Computer Science |
|
| 112358 | Shan | SEC | Security | CS | Computer Science |
|
| 101225 | Danial | NANO | Nanotech | EE | Electrical and Electronics |
T004 | Beast Wars | 212111 | Shafiq | AI | Artificial Intelligence | CS | Computer Science |
|
| 123542 | Syed | EE | Electrical/ Electronics | EE | Electrical and Electronics |
|
| 111358 | Jimmy | SE | Software Engineering | CS | Computer Science |
|
| 112251 | Angelina | SE | Software Engineering | CS | Computer Science |
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