Relational Model in DBMS

⏱ Estimated reading time: 3 min

The Relational Model is the most widely used data model in DBMS. It was introduced by E.F. Codd in 1970. This model represents data in the form of tables called relations, making it simple, flexible, and mathematically sound. It forms the basis of popular database systems such as MySQL, Oracle, SQL Server, and PostgreSQL.

Key Concepts of the Relational Model

1️⃣ Relation (Table)

A relation is a two-dimensional table consisting of rows and columns.

Example:
Student Table

2️⃣ Tuple (Row)

A tuple represents a single record in the table.

Example:
(101, A, BCA)

3️⃣ Attribute (Column)

Attributes are fields that represent properties of an entity.

Example: RollNo, Name, Course.

4️⃣ Domain

Domain is the set of valid values an attribute can take.

Example:
RollNo domain = Positive integers
Course domain = {BCA, MCA, B.Tech}

5️⃣ Key Constraints

Keys help uniquely identify records and maintain relationships.

a) Primary Key

Uniquely identifies each record.

Example: RollNo

b) Foreign Key

Creates a link between two tables.

Example:
In Enroll table, StudentID is a foreign key referencing Student table.

c) Candidate Key

All possible keys that can be primary key.

d) Composite Key

A key formed by combining multiple attributes.

Relational Integrity Constraints

Integrity constraints ensure data validity and consistency.

1. Entity Integrity

Primary key cannot be NULL or duplicate.

2. Referential Integrity

Foreign key must match an existing value in the parent table.

3. Domain Integrity

Values must belong to the defined domain.

These constraints improve reliability and avoid anomalies.

Relational Operations

Relational model uses Relational Algebra for data manipulation.

1. Selection (σ)

Selects rows based on condition.
Example: σ(Course='BCA')(Student)

2. Projection (π)

Selects specific columns.
Example: π(Name, Course)(Student)

3. Union (∪)

Combines rows of two compatible relations.

4. Intersection (∩)

Returns common rows from two tables.

5. Cartesian Product (×)

Combines every row of first table with every row of second.

6. Join

Combines related tuples from two tables using a common attribute.
Types: Inner Join, Outer Join, Natural Join.

Advantages of Relational Model

• Simple and easy to understand (tables are intuitive).

• Strong data integrity through keys and constraints.

• Uses SQL, a powerful and standard query language.

• Supports ACID properties (reliable transactions).

• High data independence — physical storage details hidden from user.

• Flexible — easy to insert, update, delete, and query data.

Disadvantages of Relational Model

• Can become slow for extremely large datasets (Big Data).

• Complex joins reduce performance.

• Not ideal for unstructured or semi-structured data.

• Requires high computing resources for very large relationships.

Conclusion

The Relational Model is the foundation of modern DBMS systems. Its table-based structure, strict integrity rules, and powerful SQL support make it reliable, scalable, and easy to use. Even though modern applications use NoSQL for large-scale systems, the relational model remains the most dominant and widely implemented model in database design and management.