Learning notes: MySQL database preliminary concept

Database

What is a database, a database is a large amount of information management of efficient solution, according to data structure to organize, store and manage the carrier of the database. And we often say that the database can be divided into relational and non-relational database.

relational database

The relational database mentioned here refers to a database based on a relational model.

The relationship model (corresponding) = two-dimensional table (corresponding) = real-world entity set

and entity sets, such as in a teaching department, there are at least three entity sets, teacher entity set, student entity set

is to create a (teaching department) database, and then create three tables (teacher table, student table)

In an easier-to-understand case, for example,

Student entity set = Correspondence = Student two-dimensional table

A student such as Xiaomi = Correspondence = A record in a table

Millet height = corresponding = A field of this record in the table

Learning notes: MySQL database preliminary concept