CAF-3 · Chapter 6 · Question 1 of 15
An organization’s customer database frequently suffers from update anomalies because the same customer’s address is stored in multiple different tables. To minimize this data redundancy and ensure data integrity, the database administrator should apply which process?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: B) Database Normalization
Explanation
Database normalization is a systematic process used to organize data in relational databases to minimize redundancy, avoid anomalies, and ensure data integrity
More Data Warehouse Schemas & Data Marts MCQs
- Q3A retail company’s 'Order Details' table uses a composite primary key consisting of both OrderID and ProductID. However, the attribute…
- Q4In an employee database, the EmployeeID is the primary key. The table includes a DepartmentID column and a DepartmentLocation column. The…
- Q5When designing a database, an IT team debates whether to fully normalize the data or leave it partially denormalized. What is the primary…
- Q6A nationwide supermarket chain processes tens of thousands of customer checkout transactions every hour. The system must quickly insert…
- Q7The executive board wants to analyze historical sales trends over the past ten years to make strategic business decisions. They query a…