WEBVTT

00:00.000 --> 00:15.000
In this video, we will understand how relational databases organize data using tables, rows and columns.

00:15.000 --> 00:20.000
Identify the roles of primary keys and foreign keys in linking tables.

00:20.000 --> 00:28.000
Describe relationships and normalization in maintaining accurate and efficient data.

00:28.000 --> 00:31.000
What is a relational database?

00:31.000 --> 00:36.000
Imagine a company managing thousands of customer orders, products and payments.

00:36.000 --> 00:40.000
Keeping track of all this information would be messy without a proper system.

00:40.000 --> 00:47.000
A relational database organizes data into tables, just like rows and columns in a spreadsheet.

00:47.000 --> 00:56.000
Each row represents a record and each column represents a field or attribute, such as name, email or order ID.

00:56.000 --> 01:04.000
This structure makes storing, finding and updating information fast and accurate.

01:04.000 --> 01:08.000
Keys in relational databases.

01:08.000 --> 01:12.000
To keep data organized, databases use keys.

01:12.000 --> 01:16.000
A primary key uniquely identifies each record in a table.

01:16.000 --> 01:21.000
For example, every student might have a unique ID number.

01:21.000 --> 01:26.000
A foreign key links one table to another, helping connect related data.

01:26.000 --> 01:34.000
For instance, an orders table may include a customer underscore ID that refers to a customer in the customer's table.

01:34.000 --> 01:41.000
These keys ensure that data stays consistent and connected across the database.

01:41.000 --> 01:44.000
Relationships between tables.

01:44.000 --> 01:48.000
Tables in a database are connected through relationships.

01:48.000 --> 01:57.000
A one-to-one relationship means one record in a table connects to only one record in another, like a teacher assigned to one office.

01:57.000 --> 02:05.000
A one-to-many relationship means one record connects to many others, like one customer placing several orders.

02:05.000 --> 02:13.000
And a many-to-many relationship allows multiple connections, like students enrolled in several courses and each course having many students.

02:13.000 --> 02:19.000
These links keep large databases efficient and meaningful.

02:19.000 --> 02:23.000
Normalization and why it matters.

02:23.000 --> 02:27.000
Sometimes data repeats or becomes inconsistent.

02:27.000 --> 02:33.000
Normalization fixes this by breaking large tables into smaller related ones to reduce duplication.

02:33.000 --> 02:38.000
For example, instead of storing a student's name repeatedly for every subject,

02:38.000 --> 02:44.000
we create separate tables for students, courses, and enrollments, then connect them using keys.

02:44.000 --> 02:50.000
This keeps data clean, accurate, and easy to manage.

02:50.000 --> 02:54.000
Relational databases form the backbone of modern data systems.

02:54.000 --> 03:07.000
They help store, connect, and protect information, making everyday applications like e-commerce, banking, and education run smoothly and reliably.