11-01-2012, 12:06 AM
(This post was last modified: 11-01-2012, 12:09 AM by vuassignments.)
CS614 Data Warehousing Assignment No. 1 31st Fall Semester 31st October 2012
CS614 Data Warehousing Assignment No 1
Q: Normalize the given table (on the next page) up to 3rd normal form.
Read the below Guidelines carefully before solving the assignment.
Show the data along with table structure.
Do not send the archived file (.rar etc).
Understand the scenario on the basis of given data only.
Give the reason, if relation cannot be converted in any Particular Normal Form (1st, 2nd, 3rd ).
Don’t convert the relation in to 3rd normal form directly. Show each normal form of the relation.
Degree Program
Specialization
Course
Course Instructor
Degree Duration
Degree Supervisor
Degree Supervisor Office #
Campus
MBA
Finance
Prof Sadiq
2 years
Prof Naveed
Office # 4
LHR-1
MBA
Marketing
Prof Wajid
2 years
Prof Naveed
Office # 4
LHR-2
MBA Executive
Finance
Prof Khan
1 year
Prof Naveed
Office # 4
LHR-1
MBA Executive
Marketing
Prof Nazar
1 year
Prof Naveed
Office # 4
LHR-2
BBA
Finance
Prof Usman
4 years
Prof Zeshan
Office # 19
LHR-1
BBA
Marketing
Prof Khizar
4 years
Prof Zeshan
Office # 19
LHR-2
MCS
Artificial Intelligence
Prof Naeem
2 years
Prof Zafar
Office # 35
LHR-3
MCS
Networking
Prof Khalid
2 years
Prof Zafar
Office # 35
LHR-4
MIT
Artificial Intelligence
Prof Naveed
2 years
Prof Akram
Office # 40
LHR-3
MIT
Networking
Prof Zaman
2 years
Prof Akram
Office # 40
LHR-4
BCS
Artificial Intelligence
Prof Nawaz
4 years
Prof Zafar
Office # 35
LHR-3
BCS
Networking
Prof Fozia
4 years
Prof Zafar
Office # 35
LHR-4
BCS
Database
Prof Afifa
4 years
Prof Zafar
Office # 35
LHR-5