1St Normal Form | 2Nd Normal Form |
3Rd Normal Form | Normalization |
Primary Key | Atomic Values |
Dependency | Data Redundancy |
A database normalization process that ensures that non-key attributes are fully dependent on the primary key. | A database normalization process that eliminates duplicate data and ensures data is stored in a tabular format with atomic values. |
The process of organizing data in a database to reduce redundancy and improve data integrity. | A database normalization process ensures all attributes are dependent only on the primary key and not on other non-key attributes. |
Indivisible data elements that cannot be further decomposed, ensuring data integrity and reliability. | A unique identifier for each record in a database table that helps ensure data integrity and facilitates data retrieval. |
When the same data is stored in multiple locations, leading to inconsistency and inefficiency in database management. | The relationship between attributes where one attribute's value is based on another attribute's value. |