Question
Suppose that we are given a relation schema R with four attributes, ABCD, and the set of FDs F = (AC -> B, AD ->
Suppose that we are given a relation schema R with four attributes, ABCD, and the set of FDs
F = (AC -> B, AD -> C, B - D ).
Assuming those are the only dependencies that hold for R, answer the following questions:
1. Is R in 3rd normal form (3NF)?
2. Is R in Boyce-Codd normal form (BCNF)?
3. Is the decomposition d = {ABD, ABC | of R a lossless-join decomposition?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
MySQL/PHP Database Applications
Authors: Brad Bulger, Jay Greenspan, David Wall
2nd Edition
0764549634, 9780764549632
