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
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.