I got following Relation in first normal form: R(A,B,C,D,E,F) with ABC candidate

Question

I got following Relation in first normal form: R(A,B,C,D,E,F) with ABC candidate key and AB->DE, C->E as functional dependencies, can some give me a real world example of the what this would look like if decomposed into separate tables using real names? I got following Relation in first normal form: R(A,B,C,D,E,F) with ABC candidate key and AB->DE, C->E as functional dependencies, can some give me a real world example of the what this would look like if decomposed into separate tables using real names?

Explanation / Answer

Example for R(A,B,C,D,E,F) with ABC candidate key and AB->DE, C->E as functional dependencies
Student(StudentId,Name, University,CourseId,CourseName)
--3NF
Course(CourseId,CourseName)
Student(StudentId,Name,University,CourseId)

StudentId,Name are functional dependencies of CourseId,CourseName
University functional dependencies of functional dependencies of

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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