Relational Databases and SQL

Summary 📝

A relational database stores data in tables made up of rows and columns. Each table stores data about a specific topic, such as students or courses. Instead of storing all data in one large table, the data is split into related tables, which reduces repetition and improves efficiency. 

Each table has a primary key, which is a unique identifier for each record. Tables are linked together using foreign keys, which allow data from different tables to be connected. This structure makes it easier to manage data, avoid duplication, and keep information accurate. 

Relational databases are widely used in businesses, schools, and apps to organise and retrieve data quickly using structured queries. This system is especially useful when handling large amounts of connected data, like managing bookings or customer records. .

Key Learning Points 📌

1. relational database stores data in multiple linked tables.
   
   

2. Each table has a primary key, which is a unique ID for each record.
   
   

3. Tables are connected using foreign keys, allowing related data to be linked.
   
   

4. Splitting data into separate tables reduces duplication and improves organisation.
   
   

5. Queries can be used to search and combine data across different tables.