Introduction to relational databases

Nhập dữ liệu vào Python: Giới thiệu

Hugo Bowne-Anderson

Data Scientist at DataCamp

What is a relational database?

Based on relational model of data
First described by Edgar “Ted” Codd

Example: Northwind database

ch_3_1.006.png

Example: Northwind database

ch_3_1.007.png

Example: Northwind database

ch_3_1.008.png

Example: Northwind database

ch_3_1.009.png

The Orders table

ch_3_1.011.png

The Orders table

ch_3_1.012.png

The Orders table

ch_3_1.013.png

The Orders table

ch_3_1.014.png

Tables are linked

ch_3_1.016.png

Tables are linked

ch_3_1.017.png

Tables are linked

ch_3_1.018.png

Relational model

Widely adopted
Codd’s 12 Rules/Commandments
- Consists of 13 rules (zero-indexed!)
- Describes what a Relational Database Management System should adhere to to be considered relational

Relational Database Management Systems

ch_3_1.025.png

Relational Database Management Systems

ch_3_1.026.png

Relational Database Management Systems

ch_3_1.027.png

Relational Database Management Systems

ch_3_1.028.png

Let's practice!

Nhập dữ liệu vào Python: Giới thiệu

Preparing Video For Download...