Preview
IB DP Computer Science — A3 Databases — Database design | SL | A3.2.6
📋 What You Will Learn
- Apply a repeatable five-step method that takes any flat data sheet to third normal form
- Construct full 3NF designs for real scenarios: library management and hospital management, worked end-to-end
- Recognise the standard entity patterns behind e-commerce, school, employee, inventory and police-reporting systems
- Leave correct foreign keys behind at every split so no relationship is lost
- Verify a finished design against a 3NF checklist
🏗️ Why This Matters Every organisation's data starts life as somebody's spreadsheet. The skill this item examines is turning that sheet into a set of clean, linked tables — the same five moves work whether the scenario is a library, a hospital or a police station, which is why examiners can hand you ANY scenario and expect a 3NF answer.
The Five-Step Method (works on any scenario)
Step 1 — List the raw attributes
- Write every column the