CS614 Data Warehousing Assignment 1 Solution Fall 2017

Question 1:   

Consider the following schema and convert into second normal form.  

Employee_Branch (Emp_id, EmpName, Designation, BranchID, BranchName, BranchLocation, Project)

 The following functional dependencies exist for above table.  

 Emp_id, BranchID -> Project  

Emp_id -> EmpName, Designation  

BranchID -> BranchName, , BranchLocation  

 Question 2:     

Consider the following four tables in normalized form. Your task is to De-Normalize these tables and to combine

 them into a single table using demoralization techniques you have studied so far. You are required to show all

steps of De-Normalization.