ABSTRACT

This chapter examines the detail of the normalization process, in which normalization is the sequence of steps by which a relational database model is both created and improved upon. It aims to describe the accepted method of relational database design in the form of normalization using normal forms. Approaching data modeling from an intuitive perspective is for the most part easy and largely common sense, because it applies simple business knowledge to create a database model. Building dynamic-static relationships is similar in function to that of creating a master-detail relationship, except that this time a table is created, where repeating groups of values rather than repeating groups of columns are moved to a table. A transitive dependency occurs where one column depends on another, which in turn depends on a third column, the third column typically being the primary key.