Normalization
The Assignment:
|
Student #
|
S_Name
|
S_Address
|
S_phone
|
Advisor
|
A_Room No
|
Course_code
|
Course_Name
|
Credit_
Hours
|
Instructor Name
|
Address
|
Major
|
|
1
|
John
|
NY
|
123
|
Jonah
|
307
|
Cs403
|
DBMS
|
3
|
Khan
|
VU
|
BCS
|
|
2
|
Smith
|
LHR
|
456
|
Jain
|
308
|
Cs403
|
DBMS
|
3
|
Khan
|
VU
|
BIT
|
|
3
|
Jason
|
KAR
|
789
|
Nasir
|
309
|
Cs401
|
NW
|
3
|
Habib
|
VU
|
MCS
|
|
1
|
John
|
NY
|
123
|
Jonah
|
308
|
Cs402
|
SWE
|
3
|
Lodhi
|
VU
|
BCS
|
|
4
|
Roberta
|
Texas
|
654
|
Sajid
|
310
|
Cs402
|
SWE
|
3
|
Lodhi
|
VU
|
MIT
|
|
5
|
Jack
|
NY
|
321
|
Sajid
|
310
|
Cs401
|
NW
|
3
|
Habib
|
VU
|
MIT
|
|
6
|
Jill
|
MTN
|
212
|
Nasir
|
309
|
Cs404
|
OS
|
3
|
A.D
|
VU
|
MCS
|
|
1
|
John
|
NY
|
123
|
Johan
|
307
|
Cs406
|
NC
|
3
|
Naseeb
|
VU
|
BCS
|
|
6
|
Jill
|
MTN
|
212
|
Sajid
|
310
|
Cs406
|
NC
|
3
|
Naseeb
|
VU
|
MIT
|
Normalize the above mentioned table up to 3rd normal form.
Purposes:
Ensure that you can able to normalize any relation
Objective
- This assignment has been designed so that you understand the concept of Normalization.