Question
Please normalize this table up to 3 normal form. You need to explain the steps of normalization by showing functional dependencies and show the final
Please normalize this table up to 3 normal form. You need to explain the steps of normalization by showing functional dependencies and show the final normalized tables.
(Ex. Sname Saddress, Sphone ) ** Note : without any explanation, showing the final tables will get partial credits. No proper steps -15; Incorrect steps - 1~4 per each; Incorrect final tables (missing table -5/each)
| STU_NUM | STU_LNAME | STU_MAJOR | DEPT_CODE | DEPT_NAME | DEPT_PHONE | COLLEGE_NAME | ADVISOR_LNAME | ADVISOR_OFFICE | ADVISOR_BLDG | ADVISOR_PHONE | STU_GPA | STU_HOURS | STU_CLASS |
| 211343 | Stephanos | Accounting | ACCT | Accounting | 4356 | Business Admin | Grastrand | T201 | Torre Building | 2115 | 3.87 | 75 | Junior |
| 200128 | Smith | Accounting | ACCT | Accounting | 4356 | Business Admin | Grastrand | T201 | Torre Building | 2115 | 2.78 | 45 | Sophomore |
| 199876 | Jones | Marketing | MKTG | Marketing | 4378 | Business Admin | Gentry | T228 | Torre Building | 2123 | 2.31 | 117 | Senior |
| 199886 | Ortiz | Marketing | MKTG | Marketing | 4378 | Business Admin | Tillery | T356 | Torre Building | 2159 | 3.45 | 113 | Senior |
| 223456 | McKulski | Statistics | MATH | Mathematics | 3420 | Arts & Sciences | Chen | J331 | Jones Building | 3209 | 3.58 | 87 | Junior |
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
Practical Azure SQL Database For Modern Developers Building Applications In The Microsoft Cloud
Authors: Davide Mauri, Silvano Coriani, Anna Hoffma, Sanjay Mishra, Jovan Popovic
1st Edition
1484263693, 978-1484263693
