Data Types & Constraints

Schema Design & Table Relationships

Normalization & Database Design Principles

Sketch a simple customers-orders schema with primary and foreign keys.

Identify duplicated business data in a denormalized table and propose a relational redesign.

List the ACID risks in a two-step money transfer if no transaction is used.

What is a relational database and how does it differ from other database types?

Explain ACID properties and why they matter.

Why is normalization important in schema design?

When would you choose a non-relational database instead?

Normalization and data integrity

Primary keys and foreign keys

ACID transaction guarantees

SQL joins and relational modeling