cs614 Assignment no 1 fall 2012

Posted by : Anonymous Monday, 5 November 2012


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. 






“Try to upload the assignment before BONUS day”


TABLE
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





                                                                                                                            



Leave a Reply

Subscribe to Posts | Subscribe to Comments

- Copyright © virtual university of pakistan - Skyblue - Powered by Blogger - Designed by Johanes Djogan -