Given a relation R (A, B, C, D, E).
check weather is 3NF or not
Answers
Answer:
Pata Nahi Yarrrrrrrtrrrrrrr
Answer:
a relation is in BCNF, 3NF, or both.
The textbook that I use is “Database Management System” by Ramakrishnan and Gehrke and though it is a very comprehensive textbook, it is not that easy to understand. The discussion about BCNF, and 3NF was so wordy and has few examples.
So this is my way of making notes that will help myself on the final exam later, and I hope it can help you also understanding the BCNF and 3NF relation.
Explanation:
ABCD
AB → CD
The steps are the same with checking for BCNF.
Candidate key is AB, and
Our only FD’s left hand side is equal to that candidate key, so it is in 3NF.
Honestly, you don’t need to check for 3NF for the first example, because all relation that is in BCNF is also in 3NF.