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