Database design

Introduction: As the storage component of most applications, the database plays a crucial role in determining whether the programs developed by programmers can run stably and efficiently. This course starts with the basic theories of database design and combines simple examples to clearly tell you how to design a database structure that is concise, clear, efficient and stable at the same time.

Chapter 1 Requirements Analysis

This chapter mainly explains how to conduct requirements analysis during the database design process and what the main contents we need to understand in requirements analysis are.

1-1 Introduction to Database Design

1-2 Steps of database Design

Introduction to the Importance of Requirements Analysis 1-3

Examples of Requirements Analysis 1-4

Chapter 2 Logical Design

This chapter mainly explains the basic methods of logic design and the relevant norms to be followed, and through some simple examples, makes it easier for everyone to understand the relevant content of logic design norms.

2-1 ER diagram

2-2 Overview of Design Paradigms

2-3 First Normal Form

2-4 Second Normal Form

2-5 The Third Normal Form

2-6 BC normal form

Chapter 3 Physical Design

This chapter mainly explains some issues we need to pay attention to in physical design, and takes MySQL as an example to illustrate some precautions when using MySQL for data storage.

What should be done in database physical design? 3-1

3-2 Which database to choose

3-3 Common Storage Engines of MYSQL

3-4 Naming Rules for Database Tables and Fields

3-5 Principles for Selecting Database Field Types

3-6 How to specifically select field types in a database

3-7 Other Considerations for Database Design

3-8 Design of Anti-Normalized Tables

Chapter 4 Maintenance and Optimization

This chapter mainly introduces the maintenance and optimization methods of database structures, and also explains what horizontal and vertical split tables are.

4-1 What should be done for database maintenance and optimization

4-2 How does a database maintain a data dictionary

4-3 How does a database maintain indexes

4-4 Suitable Operations in the database

4-5 Vertical and Horizontal splitting of database tables