Question

4p 1g Let F = {A \rightarrow B, BC \rightarrow D} be a set of FDs on relation schema R = {A, B, C, D, E}. Which one of the following decompositions of R is NOT in BCNF? R decomposed into \{R1, R2, R3\}, where R1 = {A, B}, R2 = {A, C, D} and R3 = {A, C, E} R decomposed into \{R1, R2, R3\}, where R1 = {B, C, D}, R2 = {A, B} and R3 = {A, C, E} R decomposed into \{R1, R2, R3\}, where R1 = {A, C, D}, R2 = {A, B} and R3 = {A, C, E} R decomposed into \{R1, R2, R3\}, where R1 = {A, B, C}, R2 = {B, C, D} and R3 = {B, C, E}

          4p 1g Let F = {A \rightarrow B, BC \rightarrow D} be a set of FDs on relation schema R = {A, B, C, D, E}. Which one of
the following decompositions of R is NOT in BCNF?
R decomposed into \{R1, R2, R3\}, where R1 = {A, B}, R2 = {A, C, D} and R3 = {A, C, E}
R decomposed into \{R1, R2, R3\}, where R1 = {B, C, D}, R2 = {A, B} and R3 = {A, C, E}
R decomposed into \{R1, R2, R3\}, where R1 = {A, C, D}, R2 = {A, B} and R3 = {A, C, E}
R decomposed into \{R1, R2, R3\}, where R1 = {A, B, C}, R2 = {B, C, D} and R3 = {B, C, E}

Show more…

4p 1g Let F = A →B, BC →D be a set of FDs on relation schema R = A, B, C, D, E. Which one of
the following decompositions of R is NOT in BCNF?
R decomposed into {R1, R2, R3}, where R1 = A, B, R2 = A, C, D and R3 = A, C, E
R decomposed into {R1, R2, R3}, where R1 = B, C, D, R2 = A, B and R3 = A, C, E
R decomposed into {R1, R2, R3}, where R1 = A, C, D, R2 = A, B and R3 = A, C, E
R decomposed into {R1, R2, R3}, where R1 = A, B, C, R2 = B, C, D and R3 = B, C, E

Added by Jennifer P.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Manisha Sarker

Step 1

1) R decomposed into {R, R2, R3}, where R = {A, B}, R2 = {A, C, D}, and R3 = {A, C, E} - The FD A-B does not violate BCNF since A is a superkey in R. - The FD BC-D does not violate BCNF since BC is a superkey in R2. - Show more…

Show all steps

lock

Thanks for your feedback!

Let F = {A-B, BC-D} be a set of FDs on relation schema R = {A, B, C, D, E}. Which one of the following decompositions of R is NOT in BCNF? R decomposed into {R, R2, R3}, where R = {A, B}, R2 = {A, C, D}, and R3 = {A, C, E} R decomposed into {R, R2, R}, where R = {B, C, D}, R2 = {A, B}, and R3 = {A, C, E} R decomposed into {R, R2, R}, where R = {A, C, D}, R2 = {A, B}, and R3 = {A, C, E} R decomposed into {R, R2, R3}, where R = {A, B, C}, R2 = {B, C, D}, and R3 = {B, C, E}

Play audio

Feedback

Powered by NumerAI

Manisha Sarker and 91 other subject AP CS educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later