Question: Quick plz 100b||7 Marks) Consider the following relation Project_Inforamtion: Project Information (EID ProjCode. Proj_Title, Proj_Budget, Dep_No, Dep_Name, Hours, Emp Name, Emp Salary) As can be

Quick plz
100b||7 Marks) Consider the following relation Project_Inforamtion: Project Information (EID ProjCode. Proj_Title, Proj_Budget, Dep_No, Dep_Name, Hours, Emp Name, Emp Salary) As can be seen above, the key for this relation is (EID. Proj_Code). Further, assume the following functional dependencies: 1. fE1D, Proj_Code) -> {Proj_Title Proj_Budget, Dep_No, Dep Name, Hours, Emp Name Emp Salary 2. (E10) -> (Emp_Name Emp_Salary, Dep_No, Dep_Name) 3. ProCode) -> {Proj_Title Proj_Budget) + Dep Ng (Dep Name) This question has two parts. Answer all parts of the question: Part 1) What normal form is the relation in? Explain your answer against each normal form INE 2NF OF BNF Part 2) Apply the step by step normalization method to normalize the above relation up to BNE part 1) part 2 I F6 "") F8 100b||7 Marks) Consider the following relation Project_Inforamtion: Project Information (EID ProjCode. Proj_Title, Proj_Budget, Dep_No, Dep_Name, Hours, Emp Name, Emp Salary) As can be seen above, the key for this relation is (EID. Proj_Code). Further, assume the following functional dependencies: 1. fE1D, Proj_Code) -> {Proj_Title Proj_Budget, Dep_No, Dep Name, Hours, Emp Name Emp Salary 2. (E10) -> (Emp_Name Emp_Salary, Dep_No, Dep_Name) 3. ProCode) -> {Proj_Title Proj_Budget) + Dep Ng (Dep Name) This question has two parts. Answer all parts of the question: Part 1) What normal form is the relation in? Explain your answer against each normal form INE 2NF OF BNF Part 2) Apply the step by step normalization method to normalize the above relation up to BNE part 1) part 2 I F6 "") F8Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
