Question: [5] We have an (over simplified) university database, with attributes CLASS, SECTION, STUDENT, MAJOR INSTRUCTOR, RANK, SALARY, and TEXT. Intuitively a given CLASS (such
[5] We have an (over simplified) university database, with attributes CLASS, SECTION, STUDENT, MAJOR INSTRUCTOR, RANK, SALARY, and TEXT. Intuitively a given CLASS (such as IS702) is divided into SECTION (such as Section 2) each of which has one INSTRUCTOR and various STUDENTS. Each CLASS has a set of TEXT BOOKS, which are used by all SECTIONS of the CLASS. Each STUDENT has one MAJOR. Each INSTRUCTOR has one RANK and one SALARY. Starting with one relation: R(CLASS, SECTION, STUDENT, MAJOR, INSTRUCTOR, RANK, SALARY, TEXT) Find all non-trivial functional and multi-valued dependencies Decompose into 4NF (and hence BCNF) 1. 2.
Step by Step Solution
3.42 Rating (152 Votes )
There are 3 Steps involved in it
If a functional dependency XY holds true where Y is not a subset of X then this dependency is called ... View full answer
Get step-by-step solutions from verified subject matter experts
