Reference no: EM132183890
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