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 

[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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!