
- DBMS Tutorial
- DBMS - Home
- DBMS - Overview
- DBMS - Architecture
- DBMS - Data Models
- DBMS - Data Schemas
- DBMS - Data Independence
- Entity Relationship Model
- DBMS - ER Model Basic Concepts
- DBMS - ER Diagram Representation
- DBMS - Generalization, Aggregation
- Relational Model
- DBMS - Codd's Rules
- DBMS - Relational Data Model
- DBMS - Relational Algebra
- DBMS - ER to Relational Model
- DBMS- SQL Overview
- Relational Database Design
- DBMS - Database Normalization
- DBMS - Database Joins
- Storage and File Structure
- DBMS - Storage System
- DBMS - File Structure
- Indexing and Hashing
- DBMS - Indexing
- DBMS - Hashing
- Transaction And Concurrency
- DBMS - Transaction
- DBMS - Concurrency Control
- DBMS - Deadlock
- Backup and Recovery
- DBMS - Data Backup
- DBMS - Data Recovery
- DBMS Useful Resources
- DBMS - Quick Guide
- DBMS - Useful Resources
- DBMS - Discussion
Explain the Relational Model in DBMS?
In relational models, the data is maintained in the form of a two-dimensional table.
Information is stored in the form of rows and columns. The basic structure of this model is tables. Generally, tables are called relations in the relational model.
Example
Let’s consider a student table
Std-Id | Std-Name | Age | Branch |
---|---|---|---|
101 | Hari | 20 | CSE |
102 | Pinky | 22 | EEE |
103 | Bob | 20 | CSE |
104 | Lucky | 21 | ECE |
Features
The features of Relational Model are as follows −
Tuples − Each row in the table is called a tuple. A row contains all the information about any instance of the object. In the above example, each row contains all the information regarding each student.
Attribute or field − Attributes are property which defines the table or relation. The values of the attribute should be from the same domain. In the above example, we have different attributes of the student like Id, name, age, branch, etc.
Advantages
The advantages of the relational model are as follows −
Changes in a table’s structure do not affect data access.
Tabular view improves conceptual simplicity which promotes easier database design, implementation, and management.
It has a referential integrity control that ensures data consistency.
This model is simpler as compared to other networks.
This model is easily scalable because we can add as many rows and columns, we want.
Disadvantages
The disadvantages of the relational model are as follows −
Hardware overheads.
Bad design.
- Related Articles
- Explain the relational algebra in DBMS?
- Difference Between E-R Model and Relational Model in DBMS
- Explain the select operation in relational algebra (DBMS)?
- Explain the binary operations in relational algebra (DBMS)?
- Explain project operation in relational algebra (DBMS)?
- Explain rename operation in relational algebra (DBMS)?
- Explain union operation in relational algebra (DBMS)?
- Explain intersection operation in relational algebra (DBMS)?
- Explain cartesian product in relational algebra (DBMS)?
- Explain division operation in relational algebra (DBMS)?
- Explain the Network Model in DBMS?
- Explain the evaluation of relational algebra expression(DBMS)
- Explain the object oriented data model in DBMS?
- Relational Set Operators in DBMS
- Explain Extended or Enhanced ER model in DBMS?
