Question
Create tables for this database in 3NF form. Please note, - Look at the data in the excel sheet provided and determine the functional dependencies
Create tables for this database in 3NF form.
Please note, - Look at the data in the excel sheet provided and determine the functional dependencies in the data. (20 Points)
- Please provide detailed explanation about how you would proceed and split the data into multiple tables so that resulting tables do not contain redundancy so that it is in 3NF form. List each resulting table with its primary key(s), foreign key(s) properly identified. Remember to use the relational schema representation we used in class to show the list of tables, foreign keys.
Stud SSNBr Branch ID Branch Name Branch school Stud Name Stud Stud Street Stud LocationStud Zip School Ci School StateSchool Zip School Code Start Date End Date JSOM UTD r Rd Allen,TX 75080 4243 245698741 JSOM UTO Barnhill 21 Campbe Rd Frisco TX Richardson 75080 4243 22 CSC ERIK,UTD Elizabeth Smith TX 75253 Richardson 75080 4243 4123658749 21 MECH ERIK UTD Martin Jones Plano,TX 75080 4243 Valley Rd Richardson,TX Richardson 7 2146589635 2146589635 20 ITM JSOM UTD John Lewis John Lews 21 Pilot Dr 21 Pilot Dr Plano,TX Plano,TX 4243 3658 5080 5025 Austin 7871Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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