Canonical cover is in which normal form ?

Question

I am just having one confusion that if we have a canonical cover so it doesn't have any extraneous attributes or redundancy , so is it always in normal form, or not always true ,i.e it may depend on whether it satisfies all the conditions for being in normal form .

Answer 1

basically when we have a canonical cover that mens we have the non redundant functional dependecy . it will be in first normal form only . the actuall use of canonical cover in the process of normalization is to remove the reduent and and repeating functional dependency which make our problem easy now. There is a way how our teacher taught us all about normalization. a live example .

according to him normalization is a war . now i am training u to be a commando of normalization. before going to war u have to choose guns . if there are 2 set of functional dependency which mens 2 guns . u definitely will choose more powerful else if there is only one gun u have to make it lighter so that u can fight easily. here canonical cover help us. if u have 2 set of functional dependecy chose that is more powerful mens whic is driving more attributes, else just remove all the redudant terms other wise u have to deal with them aterwards. now after choosing gun u have to choose bullets . so find candidate keys . they are the bulets now u are ready to fiht the battle of normalization . now u can easily understand that these steps are required before normalization.