1 | 6 | 7 | |||||||||||||||||||||
2 | |||||||||||||||||||||||
3 | |||||||||||||||||||||||
4 | |||||||||||||||||||||||
5 | |||||||||||||||||||||||
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. Indivisible data elements that cannot be further decomposed, ensuring data integrity and reliability.
4. A database normalization process ensures all attributes are dependent only on the primary key and not on other non-key attributes.
5. A database normalization process that eliminates duplicate data and ensures data is stored in a tabular format with atomic values.
6. The process of organizing data in a database to reduce redundancy and improve data integrity.
7. A database normalization process that ensures that non-key attributes are fully dependent on the primary key.