Question: 1 . Given that relation ( R ) has the following structure: R ( A , B , C , D , E ) with
Given that relation R has the following structure: RA B C D E with functional dependencies:
AB C
AB D
D E
a What is the lowest normal form that this relation violates? Lowest normal form is st followed by nd followed by rd followed by BoyceCodd Normal Form. If a relation, has a partial dependency, then it satisfies st normal form but violates nd normal form.
b Using the relational notation format above, modify the relation so that it is in BoyceCodd Normal Form BCNF
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
