CS614 Spring 2012 Second Assignment
CS614 Spring 2012 First Assignment Solution
Q: Normalize the below table up to 3rd normal form.
Read the Instructions (given on the next page) carefully before solving the assignment.
CS614 Fall 2011 4th Assignment
Question 1: [10 marks]
Data warehouse makes the enterprise’s current and historical information easily available for decision making. Suppose you have to analyze the data warehouse of a telecommunication company like telenor or u-fone or any other company. How the current and historical information can benefit the managers in decision making?
CS614 Fall 2011 First Assignment
Fifth Assignment CS614 5 Spring 2011
Fourth 4th Assignment Spring 2011 CS614 4
Spring 2011 CS614 2
Question 1: [13 marks]
In this paper [1] hierarchical denormalization is used to optimize the performance of data warehouse design. Study the paper and prepare a summary of how the technique is used for optimization.
Spring 2011 CS614 Data Warehousing 1
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.