Every question IB students actually ask.

Answered in under a minute.

Computer Science (First Exam 2027)

What's the Difference Between a Primary Key, Foreign Key, and Composite Key?

Learn how primary, foreign, and composite keys identify records, connect database tables, and maintain data integrity for IB Computer Science exams.

A3.1 Database fundamentals

What Are the Benefits of Using a Database (Data Integrity, Concurrency Control, and Reduced Redundancy)?

Learn how databases improve data integrity, control concurrent access, and reduce redundancy, using precise IB Computer Science terminology and examples.

73 96 207

Every question IB students actually ask.

Computer Science (First Exam 2027)

What's the Difference Between a Primary Key, Foreign Key, and Composite Key?

What Are the Benefits of Using a Database (Data Integrity, Concurrency Control, and Reduced Redundancy)?

MYP Subjects

Computer Science (First Exam 2027)

What's the Difference Between a Primary Key, Foreign Key, and Composite Key?

What Are the Benefits of Using a Database (Data Integrity, Concurrency Control, and Reduced Redundancy)?

What Are the Limitations of Relational Databases with “Big Data” or Unstructured Data?

What’s the Difference Between Conceptual, Logical, and Physical Database Schemas?

How Do You Construct an Entity Relationship Diagram (ERD)?

What Do Cardinality and Modality Mean in an ERD?

What Data Types Are Used in Relational Databases and Why Does Choosing the Wrong One Matter?

How Do You Design Tables Using Primary Keys, Foreign Keys, and Composite Keys?

What's the Difference Between 1NF, 2NF, and 3NF (Normal Forms)?

What Is a Functional Dependency / Partial-Key Dependency / Transitive Dependency?

How Do You Normalize a Database to 3NF?

What Is Denormalization and When Does It Improve Performance?

What's the Difference Between DDL and DML in SQL?

How Do You Write a SQL JOIN Query Between Two Tables?

What Do SELECT; WHERE; GROUP BY; HAVING; and ORDER BY Do in SQL?

How Does the LIKE Operator With % Wildcard Work in SQL?

How Do You Insert, Update, and Delete Records in SQL?

What Are SQL Aggregate Functions (AVERAGE; COUNT; MAX; MIN; SUM)? (HL)

What's the Difference Between a Virtual View and a Materialized View in a Database? (HL)

What Is ACID (Atomicity; Consistency; Isolation; Durability)? (HL)

What's the Difference Between a NoSQL Database and a Relational Database?

What Do BEGIN TRANSACTION; COMMIT; and ROLLBACK Do? (HL)

What Are a Spatial Database and an In-Memory Database?

What Is a Data Warehouse and How Is It Different From a Regular Database?