Given the relation with the following attributes ACFSBDM. Note that C is the key. This relation has
Fantastic news! We've Found the answer you've been seeking!
Question:
Given the relation with the following attributes ACFSBDM. Note that C is the key. This relation has this set of functional dependencies: FS -> B, A ->D.
a) Explain why this relation is not in BCNF.
b) Decompose this relation into BCNF.
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date: