
- 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
Relational Data Model
The relational data model is the most famous data model and is used by the majority around the world.This is a simple but efficient data model and has the capability to handle data in the best possible manner.
Tables are used to handle the data in the relational data model. An example of a table containing data about the Employees in a company is as follows −
<Employee>
Emp_Number | Emp_Name | Emp_Designation | Emp_Age | Emp_Salary |
---|---|---|---|---|
1 | Jack | Manager | 35 | 50000 |
2 | Tom | Technician | 25 | 25000 |
3 | Henry | Secretary | 50 | 30000 |
The table Employee has the following characteristics −
Tuple- A row of the table is called a tuple. It stores the data details according to the table schema.
Column- A column of the database represents the same form of data. Example - In the above database, Name represents names of all the employees.
Relational Schema - A relational schema defines the table name and its attributes. The schema for the above table would be Employee(Emp number, Name, Designation, Age, Salary)
Key- The key for a table is the attribute that can uniquely identify all the tuples. In the Employee table, the key is Emp Number as it is unique for every single employee,.
Constraints
Every relation has some constraints that must hold for it to be called a relational model. These are as followed −
- Key constraints - There must be at least one set of attributes that can identify a tuple in a unique manner. This set is known as a key.
- Domain constraints - There are some domain specific constraints that must be followed in a database. Example - The salary of an employee cannot be negative so the salary field has only positive values.
- Referential Integrity constraints - These constraints are used to describe the behaviour of foreign keys. A foreign key is a key of a relation that can be referred in another relation.
- Related Articles
- Object-relational Data Model
- Relational Database Model
- Converting E-R model into relational model
- Constraints in Relational Database Model
- Explain the Relational Model in DBMS?
- Difference Between E-R Model and Relational Model in DBMS
- What is Multi-relational Data Mining?
- Hierarchical Data Model
- Network Data Model
- How to extract XML data for relational use?
- Object-oriented Data Model
- Columnar Data Model of NoSQL
- Model Planning for Data Analytics
- Difference between Relational Algebra and Relational Calculus
- Django model data to JSON data in 2 lines
