Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
Normalization involves eliminating relationships between database (DP-900)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Normalization involves eliminating relationships between database tables.
Normalizing a database reduces data redundancy.
Normalization improves data integrity.
Yes
No
Solution
Correct answer: No, Yes, Yes
Normalization involves eliminating relationships between database tables:
This statement is incorrect. Normalization, in the context of databases, actually involves organizing data to minimize redundancy and dependency. It aims to structure tables in a way that reduces data duplication and maintains logical relationships between them by breaking down larger tables into smaller ones and establishing connections through keys.
Normalizing a database reduces data redundancy:
This statement is true. When you normalize a database, you restructure it in a way that removes redundant data. By breaking down tables and organizing them efficiently, you eliminate unnecessary duplication of information. This helps in reducing storage space and ensures consistency in the database.
Normalization improves data integrity:
This statement is true. One of the main objectives of normalization is to enhance data integrity. By organizing data into logically related tables and reducing redundancy, normalization helps in maintaining accuracy and consistency within the database. It reduces the chances of anomalies such as insertion, update, and deletion anomalies, thereby improving data integrity.
Category: Core Data Concepts