In order to convert a table to BCNF, we must : Find and remove the overlapping candidate keys. Place the part of the candidate key and the attribute it is functionally dependent on, in a different table. Group the remaining items into a table. Hence,from the PROJECT table( refer to the Boycee-Codd Normal Form [...]
Normalization
Boycee-Codd Normal Form (BCNF)
The original definition of 1NF was inadequate in some situations. It was not satisfactory for the tables: That had multiple candidate keys. Where the multiple candidate keys were composite Where the multiple candidate keys overlapped (had atleast one attribute to common) Therefore, a new normal form, the BCNF was introduced. You must understand that [...]
Guidelines for converting a table to 3NF
Inorder to convert a table into 3NF we must : Find and remove non-key attributes that are functionally dependent on attributes that are not the primary key. Place them in a different table. Group the remaining attributes. As for example, to convert the table Employee ( refer to the Third Normal Form (3NF) link : http://churmura.com/third-normal-form-3nf/) into [...]
Third Normal Form (3NF)
A table is said to be in 3NF when it is in 2NF and every non-key attributes is functionally dependent only on the primary key. Consider the table EMPLOYEE The problems with dependencies of this kind are: Insertion : The department head of a new department that does not have any employees at present cannot [...]
Guidelines for converting a table to 2NF
Inorder to convert a table into 2NF, we must : Find and remove attributes that are functionally dependent on only a part of the key and not on the whole key. Place them in a different table. Group the remaining attributes. To convert the table PROJECT( refer the Second Normal form (2NF) Link : http://churmura.com/second-normal-form-2nf/) into [...]
Normalization in RDBMS
Normalization is scientific method of breaking down complex table structures into simple table structures by using certain rules. Using this method, you can, reduce redundancy in a table and eliminate the problems of inconsistency and disk space usage. You can also ensure that there is no lose of information. Normalization has several benefits. It enables [...]
