1 | 7 | |||||||||||||||||||||||
2 | ||||||||||||||||||||||||
3 | ||||||||||||||||||||||||
4 | ||||||||||||||||||||||||
5 | ||||||||||||||||||||||||
6 | ||||||||||||||||||||||||
1. When the same data is stored in multiple locations, leading to inconsistency and inefficiency in database management.
2. A unique identifier for each record in a database table that helps ensure data integrity and facilitates data retrieval.
3. A database normalization process that eliminates duplicate data and ensures data is stored in a tabular format with atomic values.
4. A database normalization process that ensures that non-key attributes are fully dependent on the primary key.
5. Indivisible data elements that cannot be further decomposed, ensuring data integrity and reliability.
6. A database normalization process ensures all attributes are dependent only on the primary key and not on other non-key attributes.
7. The process of organizing data in a database to reduce redundancy and improve data integrity.