You are given a relation R and the following set of functional dependencies F . Assume there
Fantastic news! We've Found the answer you've been seeking!
Question:
You are given a relation R and the following set of functional dependencies F Assume there are no setvalued attributes.
ROrder Product, Quantity, UnitPrice, Customer, Address
F Order Customer, Customer Address, Product UnitPrice,
Order Address
a Find all violations of NFNFNF and BCNF if any Clearly mark which violation is for which normal form.
b Which normal form is R in Depending on this, successively decompose R into NF then NF then NF then BCNF one after the other, in this order Your final result must be in BCNF
c Is your result at the end of part b a lossless join decomposition of R Why or why not?
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date: