Question No. 1 
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 
Consider the below given tables:
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_NoDOWNLOAD SOLUTION HERE