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 −
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,.
Every relation has some constraints that must hold for it to be called a relational model. These are as followed −