Apply the simple synthesis procedure to produce BCNF tables using the following FD list. Show the results of each step in your analysis.

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