Database Normalization

Database normalization is a design technique by which relational database tables are structured in such a way as to make them invulnerable to certain types of logical inconsistencies and anomalies. Tables can be normalized to varying degrees: relational database theory defines “normal forms” of successively higher degrees of stringency, so, for example, a table in third normal form is less open to logical inconsistencies and anomalies than a table that is only in second normal form. Although the normal forms are often defined (informally) in terms of the characteristics of tables, rigorous definitions of the normal forms are concerned with the characteristics of mathematical constructs known as relations. Whenever information is represented relationally – that is, roughly speaking, as values within rows beneath fixed column headings – it makes sense to ask to what extent the representation is normalized.

IMHO 1NF, 2NF masih mudah dicerna. Tapiiiiiiiiiiiiiiiiii 3NF, BCNF, 4NF, 5NF.. parah dah, rasanya bikin hidup lebih ndak normal deh. 🙁 Saya sendiri belom tau database yang kaya gimana sampe perlu ke step 5NF.

6 thoughts on “Database Normalization

  1. Waah… jadi inget masa-masa kuliah dulu, belajar normalisasi database… bener-bener bikin pusying.. 😛

    Padahal belum tentu diimplementasikan in real life, untungnya saya ndak jadi programmer… 🙂 🙂

  2. hayo2… dah tak kirimin tu k imel, buat latihan utk UTS…., biasanya siy rada2 mirip soalnya… ^_^

Leave a Reply

Your email address will not be published. Required fields are marked *