In the following relation scheme, a student can take the same course more than o

Question

In the following relation scheme, a student can take the same course more than once each in a different term (of the same or different year), where S# is student-number, Sname is student-name, and so forth. Stud(S#, Sname, C#, Cname, Credit, Year, Term, Grade). In the context of "good database design", state whether this scheme is efficient and justify your answer. Identify the main functional dependencies satified the given scehem. Find a BCNF decomposition for the given scheme.

Explanation / Answer

(a) The scheme is not efficient. It is so because; the table will have more redundancies. As each student can take same course all the values except the entity term can have the same values. It has to suffer from anomalies like updation and deletion anomalies. (b) Functional dependencies: S# -> Sname C# -> Cname {Term, C#} -> Cname (c) BCNF Decomposition: Student (S#, Sname, Term, Grade) Course (C#, Cname, Term, Credit, Year)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.