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:
- Explain the relational data model.
- Understand tables, rows, and columns in relational databases.
- Identify relations, attributes, tuples, and domains.
- Calculate the degree and cardinality of a relation.
- Explain the different relational integrity constraints.
- Differentiate between primary keys and foreign keys.
- Understand entity integrity and referential integrity.
- Convert ER diagrams into relational schemas.
- 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.
| Application | Example Tables |
|---|---|
| College Management | Student, Teacher, Course, Department |
| Banking System | Customer, Account, Transaction |
| Hospital Management | Patient, Doctor, Appointment |
| Library Management | Book, Member, Borrow |
| E-commerce | Customer, Product, Order, Payment |
| Inventory System | Product, 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
- Introduction to Relational Model
- Relations, Attributes, Tuples and Domains
- Relational Constraints
- 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.