Question: Assignment 5 includes problems finding functional dependencies, converting ERDs to table designs, applying the rules of normalization, and working with narrative problems. This assignment contains

Assignment 5 includes problems finding functional dependencies, converting ERDs to table designs, applying the rules of normalization, and working with narrative problems. This assignment contains problems 21, 24, 33, 34, and 35 on Page 260 of the textbook (Chapter 7). Label the problems in a Word document to align with the problems in the textbook. 21. Apply the simple synthesis procedure to produce BCNF tables using the following FD list. Show the results of each step in your analysis. StdNo--StdName, StdAdmitsems, StdAdmitYear, StdStatus, StdEmail StdEmail StdNo, StdStatus CourseNo >CrsDesc, CrsUnits, CrsDeptName, CrsCollName PlanNo->PlanDate, PlanAdvName, StdNo, PlanApproval, StdName PlanNo, CourseNo Semester, Year, CreditType, Grade . PlanNo, PaperNo-DateSubmit, DateDecided, Decision, PaperTitle, StdNo
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
