Course contentsShow
← Computer Science
Lesson 1551 of 2,87236. Database FundamentalsFree lesson

What is the Relational Model?

Introduction to the relational model as a way to organize data using tables, rows, and columns with mathematical foundations.

What is the Relational Model?

You'll learn: How the relational model organizes data into structured tables with mathematical precision.

The Core Idea

The relational model is a mathematical framework for organizing data as tables (called relations), where each table consists of rows and columns. Proposed by Edgar F. Codd in 1970, it revolutionized database design by providing a clear, logical structure based on set theory and predicate logic.

Think of a spreadsheet: each sheet is a table, columns represent different attributes (like "Name," "Email," "Age"), and each row is a single record. The relational model formalizes this intuitive structure with rigorous rules.

Key Components

Tables (Relations)

A table represents an entity type (e.g., "Users" or "Orders"). Each table has a unique name.

Rows (Tuples)

Each row contains one complete record. For example, one user's information: {UserID: 1, Name: "Alice", Email: "alice@example.com"}.

Columns (Attributes)

Columns define the properties of the entity. Each column has a name and a data type (integer, string, date, etc.).

Mathematical Foundation

Unlike ad-hoc data storage, the relational model uses formal operations (like joins, unions, and selections) to query and manipulate data. This ensures consistency and predictability.

Why It Matters

The relational model separates how data is stored (physical) from how it's organized logically (conceptual). This abstraction lets developers query data without worrying about disk layout or file structures—exactly what modern databases like PostgreSQL and MySQL implement.

Key Takeaway: The relational model organizes data into tables with rows and columns, providing a mathematically sound foundation for modern databases.