Suppose that we decompose the schema R = (A, B, C, D, E) into (A, B, C)

Question:

Suppose that we decompose the schema R = (A, B, C, D, E) into (A, B, C)

(A, D, E). Show that this decomposition is a loss less-join decomposition if the following set F of functional dependencies holds:

A → BC

CD → E

B → D

E → A

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database System Concepts

ISBN: 978-0072554816

4th Edition

Authors: Henry F. Korth, S. Sudarshan

Question Posted: