Computer Science · A3.2 Database Design

A3.2.1 — Database Schemas: Conceptual, Logical and Physical

Preview

IB DP Computer Science — A3 Databases — Database design | SL | A3.2.1

📋 What You Will Learn

  • Define what a database schema is and how it differs from the data itself
  • Describe the three schema levels: conceptual, logical and physical
  • State what is decided at each level, and what each level deliberately ignores
  • Explain how the levels are abstract definitions of the same data at different levels of detail
  • Apply the three levels to a real scenario (a school enrolment database)

🏗️ Why This Matters An architect draws the same building three times: a concept sketch for the client, a floor plan for the engineers, and construction drawings for the builders. Each drawing

Continue reading the full note