Reference no: EM132400964

Suppose that the relation BILL(StudentID, FirstName, LastName, Major, Tuition) has the set of functional dependencies F = { StudentID, MajorFirstName, LastName, Tuition ; StudentID FirstName, LastName, Major }. Consider the following decomposition of BILL:

R1(StudentID, FirstName) R2(StudentID, LastName) R3(StudentID, Major, Tuition)

a. Give the projections of F on R1, R2, and R3. Does the decomposition have the dependency preservation property? Give a detailed explanation why or why not. (Don't just state the definition of the dependency preservation property, but rather show why the decomposition either has or does not have this property by showing whether or not each functional dependency in F can be derived from the union of the projections.)

b. Does the decomposition have the lossless join property? Give a detailed explanation why or why not.