Functional Dependencies and Normalization

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

1. StdNo StdName, StdAdmitSems, StdAdmitYear, StdStatus, StdEmail

2. StdEmail StdNo, StdStatus

3. CourseNo CrsDesc, CrsUnits, CrsDeptName, CrsCollName

4. PlanNo PlanDate, PlanAdvName, StdNo, PlanApproval, StdName

5. PlanNo, CourseNo Semester, Year, CreditType, Grade

6. PlanNo, PaperNo DateSubmit, DateDecided, Decision, PaperTitle, StdNo