Chapter 6 MCQs: Database Normalization & Data Warehousing
Chapter 6 covers database normalisation (1NF, 2NF, 3NF) and data warehousing, including OLTP versus analytical systems, the ETL process and data marts.
What Chapter 6 covers
- Why normalisation is needed and update anomalies
- First, second and third normal form
- Data warehousing concepts
- Online Transaction Processing (OLTP)
- Extract, Transform and Load (ETL)
- Data marts
All free. Start straight away with 100 MCQs from any chapters; all 60 Chapter 6 questions unlock with a quick, free access request.
Need to revise first? Chapter 6 is explained in plain language, with exam tips and worked scenarios, in the free CAF-3 DSR study guide (PDF). More chapters, mock exams and AI marking: CAF-3 DSR Exam Prep.
Free study resource. Not affiliated with, endorsed by or produced by ICAP.


