[5] We have an (over simplified) university database, with attributes CLASS, SECTION, STUDENT, MAJOR INSTRUCTOR, RANK,...

 

Transcribed Image Text:

[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. [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.

Answer rating: 100% (QA)

If a functional dependency XY holds true where Y is not a subset of X then this dependency is called ... View the full answer