Are 3NF decompostions and BCNF decompostions unique? Are 4NF important for GATE (since I’ve left them :( )
See, I am asking this question because I want to know whether they’ll ask about no. of tables we get after normalizing upto 3nf or bcnf. Now, if the decompostions are unique, then whatever method I use, I will get the same answer, but what if they are not unique? How am I supposed to know that my answer is the right one?
Till now, I don’t think they’ve asked such questions, but in some test series, they did ask such questions.
(I don’t know whether this is a duplicate question or not… I am in a bit hurry to search for that.. so please forgive me if it has been already asked.)
Thank you.