07/11/2025
SIMPLIFY DATA ANALYTICS CONCEPTS 1.2
RELATIONAL DATABASE
What is Relational database?
A relational database is the kind of database that organizes data into rows and columns to form a table with data points that link the information. It organizes data points with defined relationships for ease of access. Relational means there is connection between/among data points.
Let's consider a customer's table with columns headings such as Customer name, Customer ID, Address. Each row represents a unique customer. You could have 2 customers with same name, but definitely cannot have the same Customer ID. The customer ID is the primary key here.
In relational database, there is often the possibility of having more than one table. You could have 2, 3, 4 etc. In situations like this, a foreign key links up the tables such that each unique identifier in one table connects the same person's data in the other table(s).
Let's take a look at relational database with 3 tables - Customer table, Sales table, and Product table.
Customer table - Customer ID (primary key), Name, Address.
Sales table - Sales ID (primary key), sales amount, sales qty, customer ID, Product ID
Product table - Product ID (primary key), category, sub category.
In the above illustration, each table has its own primary key, but Customer ID and Product ID are the foreign keys that links Sales table to Customer table and Product table respectively.
Relational database maintains the separate tables of data, but makes it easy to find details of a particular identifier across the tables. Therefore, you can extract the tables and use for relevant analysis.
Source: Residual and across web
Share, comment and follow page
