Glossary of Terms

1st, 2nd & 3rd Normal Form

Keyword Definition
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.