CS614 Data Warehousing Assignment 2 Solution Fall 2014

Question No. 1 [10]
You are given ERD as shown below. Perform appropriate de-normalization technique to any of the one-to-one and one-to-many relations.

Question No. 2 [10]
Consider the below given tables:
Student_ Info

Suppose we need to run the below given query more frequently. But the problem is that the given query links two tables which degrade performance. Perform the most appropriate de-normalization technique to enhance the performance so that we don’t need to perform join.

Select S.Roll_No, S.Name, A.Application_ID,A.Program,A. Application_date from Student_Info S, Application_Info A where A.Roll_No= S.Roll_No