Database Normalization
Database normalization is the process of organizing data into distinct and unique sets.
The purposes of normalization are to:
- Reduce or eliminate storage of duplicate data
- Organize data into an efficient and logical structure
The process of normalization involves determining what data should be stored in each database table.
By tradition, the process of normalization involves working through well-defined steps, called normal forms.
In First Normal Form (1NF) you eliminate duplicate columns from the same table, create separate tables for each group of related data, and identify each row with a unique column or set of columns (the primary keys).
In Second Normal Form (2NF) you remove subsets of data that apply to multiple rows of a table, place them in separate tables, and create relationships between these new tables and the original tables through the use of foreign keys.
In Third Normal Form (3NF) you remove columns that are not dependent upon the primary key.
Additional normal forms have been defined, but are less commonly utilized. These advanced normal forms include Fourth Normal Form (4NF), Fifth Normal Form (5NF), Boyce Codd Normal Form (BCNF), and Domain-Key Normal Form (DK/NF).
|
|
Comments (1)
Leave a Reply
- Relational Database
A relational database stores data in separate tables instead of placing all data in one large table. It then allows Data Base Administrators (DBAs) to define relationships between these tables. These relationships enable DBAs to combine data from several tables for querying and reporting. This is accomplished through the use of keys, which are database [...]...
- What is a Database?
One of the technology terms that most people have become accustomed to hearing either at work or while surfing the Internet is the database. The database used to be an extremely technical term, however with the rise of computer systems and information technology throughout our culture, the database has become a household term. A database [...]...
- Database Trigger
A database trigger is a procedural code that automatically changes information in one or more databases in response to a change on another database or table. For example, when an employer creates a slot in a list of employees for a new employee, the database trigger in that list should automatically add the new employee [...]...
- Database Replication
Database replication is the creation and maintenance of multiple copies of the same database. In most implementations of database replication, one database server maintains the master copy of the database and additional database servers maintain slave copies of the database. Database writes are sent to the master database server and are then replicated by the [...]...
- Transactional Database
A transactional database is a DBMS where write operations on the database are able to be rolled back if they are not completed properly. If a transactional database system loses electrical power half-way through a transaction, the partially completed transaction will be rolled back and the database will be restored to the state it was [...]...
1) Describe and illustrate the process of normalization for the following relation to Second (2NF), and Third (3NF).
R(ABCDEF)
A->B
D->E
B->C
E->F