Database Tutorial Home
- Introduction To Database
- Data Models
- Three-Schema Architecture of Database Systems
- Database System Architectures
- Codd\'s Rules for Relational Databases.
- Keys in DBMS
- Concept of Normalization
- First Normal Form
- Second Normal Form
- Third Normal Form
- Boyce-Codd Normal Form(BCNF)
- Fourth Normal Form
- Fifth Normal Form (Projection-Join Normal Form)
- Introduction TO SQL
- Transactions in DBMS
- Steps to Design Database for a System
- Members (1542)
- Member Articles ( 0 )
- Discussion (4)
- Q & A ( 15 )
- - Ask Question
- - Questions
- - Unanswered Questions
- Identifying relationships among attributes.
- Combining attributes to form relations.
- Combining relations to form a database.
It follows a set of rules worked out by E FCodd in 1970. A normalized relational database provides several benefits:
- Elimination of redundant data storage.
- Close modeling of real world entities, processes, and their relationships.
- Structuring of data so that the model is flexible.
Because the principles of normalization were first written using the same terminology as was used to define the relational data model this led some people to think that normalization is difficult. Nothing could be more untrue. The principles of normalization are simple, common sense ideas that are easy to apply.