Question: Consider the schema R = (A, B, C, D, E) and let the following set F of functional dependencies holdforR: F = {A -> BC,

Consider the schema R = (A, B, C, D, E) and let the following set F of functional dependencies holdforR:

F = {A -> BC, CD -> E,C -> A, B -> D}

Q: Suppose that the schema R = (A, B, C, D, E) is decomposed into R1 = (A, B, C) and R2 = (A, D, E). Show if this decomposition is a lossless decomposition with respect to the given set of functional dependencies F.

Q: Give a lossless, dependency-preserving decomposition into 3NF of schema R.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Databases Questions!