Relational Database Concepts

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


Leave a Reply

Your email address will not be published. Required fields are marked *