six generally recognized normal forms of a relation: first normal form, second normal form, third normal form, Boyce/Codd normal form, fourth normal form, and fifth normal form, also called projection/join normal form. Other normal forms (e.g., Domain/Key) exist but will not be discussed here. The normal forms are hierarchical, i.e., each normal form builds upon its predecessor. Although many people consider a relation to be normalized only when it is in third normal form, technically speaking, a
it still using navigational system and complex in implementation. And the change in structure requires a changes in all application program (Morris 55). The major evolution of data model happen in 1970 when “relational model was introduced by E.F. Codd of IMB in his landmark paper “A relational Model RDBMS help to manage the complexities of physical details of data model, when users are working with data, they interact with data by using SQL (structured query language). This is the major advantage
Inconsistently storing organization data creates a lot of issues, a poor database design can cause security, integrity and normalization related issues. Majority of these issues are due to redundancy and weak data integrity and irregular storage, it is an ongoing challenge for every organization and it is important for organization and DBA to build logical, conceptual and efficient design for database. In today’s complex database systems Normalization, Data Integrity and security plays a key role