Digital Communication: CS614 Assignment 1 Spring 2012

Friday 13 April 2012

Assignment No. 01
Semester Spring 2012
Data Warehousing-CS614

Total Marks: 15

Due Date: 16/04/2012

Objective:

To learn and understand 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:

The assignment is submitted after due date.
The submitted assignment does not open.
The submitted assignment is in the format other than MS Word (doc).
The assignment is copied (from other student or copy from handouts).
Student ID is not mentioned in the assignment File or name of file is other than student ID.

For any query about the assignment, contact at cs614@vu.edu.pk

GOOD LUCK

Q: Normalize the below table up to 3^rd normal form.

Read the Instructions (given on the next page) carefully before solving the assignment.

Guidelines / Instructions

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 (1^st, 2^nd,3^rd ).
Don’t convert the relation in to 3^rd normal form directly. Show each normal form of the relation.
Show the data along with table structure.

“Try to upload the assignment before BONUS day”

Pages