Normalization in Data Quality
well.. the first time I study in Informatics of ITB we studied about "Data quality" the goal of this lesson is to make the data more quality as semantic word is free error, good analysis. This Lesson also content of Database like on how we make data be normalized. in this occasion I will share about Normalization. Exactly we have to know about 1NF up to Boys Code Normal Form (BCNF). The table can be said get into 1NF or first normal form if the table is atomic, it means that the data can not be decomposition any more. How about 2NF the table is stated in 2nd Normal Form if all non prime attribute depends absolutely to primary key, it means there is no partial non prime attribute that depends on another key let say candidate key. 3NF or 3rd Normal form means that the table must have been in 2NF and then the second one there is no prime attribute that force another prime attribute, so if the table is 3NF of course the table is 2NF and 1NF, the last how about BNCF, well BCNF is ...