Relational Database is most commonly used database. Relational database is a collection of organized set of tables from which data can be accessed easily. It consists of number of tables and each table has its own primary key. A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Relational databases typically come associated with a variety of supporting functions and software including SQL Queries and System Restores. In short, these databases are an excellent way to store information which will later need to be retrieved.
They consist of tables similar to the ones below. These tables mostly would be related to one another.
Salary table
| EmpID | Name | Desgination | Salary |
|---|---|---|---|
| 1 | Adam | Coder | 13000 |
| 2 | Alex | Designer | 15000 |
| 3 | Stuart | Tester | 18000 |
| 4 | Ross | Manager | 19020 |
Employee types
| Desingation | Skill | Min_Salary | Max_Salary |
|---|---|---|---|
| Coder | Problem solving | 10000 | 18000 |
| Designer | Analytical | 10000 | 20000 |
| Tester | Keeness | 10000 | 20000 |
| Manager | Affable | 15000 | 25000 |