Ugenz Academy/Tutorial

Relational Data Model

Learn the relational database model, relations, attributes, tuples, domains, integrity constraints, and mapping ER diagrams to relational schemas.

3 min read565 words

Reading progress

Keep learning

Relational Data Model

1. Introduction

The Relational Data Model is one of the most widely used database models. It organizes data into tables consisting of rows and columns.

Each table represents an entity or relationship, rows represent individual records, and columns represent attributes.

The relational model was proposed by Dr. Edgar F. Codd in 1970. It became the foundation of relational database management systems such as MySQL, PostgreSQL, Oracle Database, and Microsoft SQL Server.

2. What You Will Learn

This unit covers the following topics:

1. Introduction to Relational Model

  • What is the relational model?
  • Features and components of the relational model.
  • Basic terminology.
  • Advantages and limitations.

2. Relations, Attributes, Tuples and Domains

  • Relation and relation schema.
  • Attributes and tuples.
  • Domains and degree.
  • Cardinality of a relation.
  • Properties of relations.

3. Relational Constraints

  • Domain constraints.
  • Key constraints.
  • Entity integrity.
  • Referential integrity.
  • Primary and foreign keys.

4. Mapping ER Model to Relational Schema

  • Mapping strong entities.
  • Mapping weak entities.
  • Mapping 1:1 relationships.
  • Mapping 1:N relationships.
  • Mapping M:N relationships.
  • Mapping multivalued attributes.

3. Learning Objectives

After completing this unit, learners will be able to:

  1. Explain the relational data model.
  2. Understand tables, rows, and columns in relational databases.
  3. Identify relations, attributes, tuples, and domains.
  4. Calculate the degree and cardinality of a relation.
  5. Explain the different relational integrity constraints.
  6. Differentiate between primary keys and foreign keys.
  7. Understand entity integrity and referential integrity.
  8. Convert ER diagrams into relational schemas.
  9. Design basic relational database structures.

4. Importance of the Relational Model

The relational model provides a structured way to store and manage data.

Its major benefits include:

  • Simple table-based representation.
  • Easy data retrieval using SQL.
  • Reduced data duplication through proper database design.
  • Relationships between tables using keys.
  • Data integrity through constraints.
  • Flexible data manipulation.
  • Support for transaction processing.

5. Practical Examples

The relational model is used in many real-world applications.

ApplicationExample Tables
College ManagementStudent, Teacher, Course, Department
Banking SystemCustomer, Account, Transaction
Hospital ManagementPatient, Doctor, Appointment
Library ManagementBook, Member, Borrow
E-commerceCustomer, Product, Order, Payment
Inventory SystemProduct, Supplier, Stock

6. Prerequisites

Before starting this unit, learners should understand:

  • Basic database concepts.
  • DBMS fundamentals.
  • Entity-Relationship modeling.
  • Entities, attributes, and keys.
  • Relationships and cardinality constraints.

7. Unit Tutorials

  1. Introduction to Relational Model
  2. Relations, Attributes, Tuples and Domains
  3. Relational Constraints
  4. Mapping ER Model to Relational Schema

8. Expected Learning Outcomes

After completing all tutorials, learners should be able to:

  • Describe the structure of relational databases.
  • Interpret relational schemas and tables.
  • Identify primary keys, candidate keys, and foreign keys.
  • Apply integrity constraints.
  • Understand relationships between relational tables.
  • Convert conceptual ER designs into relational schemas.

9. Summary

The Relational Data Model organizes data into tables and establishes relationships between them using keys.

It provides a foundation for relational database systems and SQL operations.

This unit explains the structure of relations, their components, integrity constraints, and the process of converting ER models into relational schemas.

Keep learning. Keep building. Keep growing.

© 2026 Ugenz Academy