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

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 "") F8

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!