Browse syllabus-aligned notes for A.2 the Relational Database Model. Open each subtopic for focused explanations, examples, and summaries.
A.2.1 DBMS and RDBMS
10 minute read
A.2.2 The Term Schema
3 minute read
A.2.3 Data Dictionary
A.2.4 Data Definition Language (DDL)
7 minute read
A.2.5 Data Modelling in Database Design
2 minute read
A.2.6 Database Terms
A.2.7 Relationships in Databases
A.2.8 Redundant Data
8 minute read
A.2.9 Referential Integrity
5 minute read
A.2.10 Normalization Forms
4 minute read
A.2.11 Evaluating Data Types
A.2.12 Entity-Relationship Diagrams (ERDs)
6 minute read
A.2.13 Designing Relational Databases
A.2.14 Queries and Views
A.2.15 Simple and Complex Queries
A.2.16 Methods to Construct a Query
1. System fundamentals
2. Computer organization
3. Networks
4. Computational thinking, problem-solving and programming
5. Abstract data structures (HL)
6. Resource management (HL)
7. Control (HL)
A. Databases
A.1 Basic concepts
A.2 The relational database model
A.3 Further aspects of database management
A.4 Further database models and database analysis
B. Modelling and simulation
C. Web science
D. Object-oriented programming (OOP)