33. Relational Database in SQL

Learn about Relational database in SQL
Welcome to the world of databases! This tutorial breaks down the basics of relational databases, where instead of having one big table, we split things into smaller, more organized tables. We call this process "normalization." In this video, we'll explore different types of relationships between these tables: one-to-one, one-to-many, and many-to-many.

First off, we look at the one-to-one relationship. Imagine you have an employee table and each employee can drive only one company car. That's a one-to-one setup. We use something called primary keys to keep things unique, and when these keys travel to another table, they become foreign keys. It's like each employee having a key to a specific car.

Moving on to the more common one-to-many relationship. Think of tables for employees and cities. The city table has unique city IDs, which are used as foreign keys in the employee table. Multiple employees can belong to one city, making it a one-to-many connection.

for downloading the SQL Lite Studio, click this link below:
https://sqlitestudio.pl/
For downloading the Sample Database click this link below :
https://github.com/Sia4Tech/SQLITE-Files

to watch other videos of this course check this link below:
https://youtube.com/playlist?list=PLX21EEATqSVJacpp9mrJLLyQSebaZafZw

for more videos visit:
https://www.sia4tech.com

#sia4tech
#siafortech


"Music from: www.bensound.com"
"Royalty Free Music from Bensound"