Assignment No. 01
SEMESTER SPRING 2011
CS614- Data Warehousing

Total Marks: 20

Due Date: 20/04/2011

Instructions

Please read the following instructions carefully before submitting assignment:

It should be clear that your assignment will not get any credit if:

1. The assignment is submitted after due date.
2. The submitted assignment does not open or file corrupt.
3. The assignment is copied.
4. There is not mentioned the student Id in the assignment File or

name of file is other than student ID.

GOOD LUCK 

Marks: 20

Question 1: [10 marks]

You are given the following data.

Patient No, Patient First Name, Patient Last Name, Patient Address, Sex, Tel No, DOB, Marital Status, Date Reg., Next of Kin Name, Relationship, Next of Kin Address, Next of Kin Tel No, Local's Doctor's Name, Clinic No, Doctor's Address, Doctor's Tel No.

1. Normalize the given data in to 1st then 2nd and 3rd normal form. Give justification of conversion in to 1st then 2nd and 3rd normal form and the anomalies because of which you transformed it in to another normal form.

Question 2: [10 marks]

It is believed that Classical SDLC is not suitable for Data warehouse environment.  In your point of view why it is not suitable. Secondly what changes you suggest to be made in Classical SDLC to make it suitable for data warehouse. Give reasons to support your ideas?

Note: Try to write answer to the point and in your own words.

Uploading Instructions:

Upload your assignment as a word file. It should have name [YourRollNo.doc]

Deadline

Your assignment must be uploaded/submitted at or before Wednesday April 20, 2011.