What is relational database

Relational database is a type of database in which data is organized in the form of separate tables and these tables are related to each other and can be linked to each other if needed.

Due to the relational database model, it has become very easy to maintain the data and fetch it when needed. We can establish a relationship between the data of different tables and can easily retrieve the data from all those tables by writing a single line query.

For example, if we store customer information in a company or shop in the database, then we create two tables named Customer table and Transaction table for it. Where in the Customer table there will be columns named customer_id, Name, Address and in the Transaction table there will be customer_id, transaction_date, amount etc.