CS614 1st assignment

Due Date: 05/11/2012

Objective:
To learn and understand the basic concepts of Normalization.

Instructions:
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit (get zero marks) if:

o The assignment is submitted after due date.
o The submitted assignment does not open.
o The submitted assignment is in the format other than MS Word (doc).
o The assignment is copied from other student.

For any query about the assignment, contact at [You must be registered and logged in to see this link.]

GOOD LUCK


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