

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 Questions & Answers
- Object-relational Data Model
- Relational Database Model
- Converting E-R model into relational 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
- Object-oriented Data Model
- How to extract XML data for relational use?
- Difference between Relational Algebra and Relational Calculus
- Relational Databases
- Django model data to JSON data in 2 lines
- Java Relational Operators
- The Data Link Layer of OSI Model