Relational Database

1. What Is a Relational Database

• A database that uses the relational model to organize data
• Relationships
  • One-to-one
  • One-to-many
  • Many-to-many: can be decomposed into two one-to-many relationships through an intermediate table

2. Why Relational Databases Are Needed

3. Characteristics of Relational Databases

3.1. Table-Structured Storage

• Data is stored using a two-dimensional table model, in rows and columns

3.2. Normalized Design

• Database Normal Forms.md

3.3. Query Data Using SQL

• SQL Join Queries.md

3.4. Support Transactions

• Database Transactions.md

4. Database Optimization

• Database Optimization.md

5. Database Principles

5.1. SQL Execution Order

• SQL Execution Order.md

5.2. Locks

• Database Locks.md

5.3. B+Tree

• B Tree.md

6. Common Relational Databases

6.1. MySQL

• MySQL.md

6.2. PostgreSQL

• PostgreSQL.md

7. References

• Relational Database (Database Type) - Baidu Baike
• Which Introductory Database Book Is Most Worth Recommending? - Zhihu
• How Can a College Student Implement a Database? - Zhihu
• The Most Detailed MySQL Interview Questions from Top-Tier Companies - Juejin
• Introduction to Database Management Systems - Part 1 | Lecture 01 | CMPSC 431W - YouTube
• [Pennsylvania State University] Database Management Systems || Database Management Systems (Machine-translated Chinese) - bilibili
• MySQL Database Interview Questions (2020 Latest Edition) - ThinkWon’s Blog - CSDN