[Self-examination] database system principles (iii) -- Summary after the examination, the principles of the Database System

[Self-examination] database system principles (iii) -- Summary after the examination, the principles of the Database System

I feel that the database book is particularly useful. Some of the knowledge is not very understandable before the exam, so we need to compare it and summarize it. In fact, every book is useful, but this book is more useful for SQL we have just learned. It is both a supplement to knowledge and a review! I did not go back to school or rest at noon when I took the database examination. I am not clear-headed. Now I am clear-headed. Please make a conclusion!

I. Graphic Export

Ii. Explanation

(1) This book describes two developments, one at one end, one database system, and one database technology. The most important thing is database design and database management.

(2) In the database design, the ER model, the relational model, and the conversion between the ER model and the relational model are included. The relational model is converted to the relational model, and the relational mode operation is as follows: relational algebra and relational calculus.

(3) The next step is database management, SQL statement management, and DB management. In chapter 6, database management is based on the features of transactions, which leads to DB recovery, concurrency control, DB integrity, and DB security.

Iii. Summary

Although I have studied science, I still have a bit of attention in the face of relational computation. A lot of knowledge is not very clear, not too understandable. I Need To summarize it again. The use of SQL statements is not skillful. Looking at the answer, you will be dumpfounded and need to perform more operations on your own. SQL statements are often used in our development systems. If you encounter any SQL statements, Let's sum up and accumulate a little bit!

You can give me the answer in chapter 3 of the principle of the database system.

Hello, I have published it online, so I am not talking nonsense! Please log on to the qun.51.com/scsfdximpromptu course package. All chapter answers in Chapter 3 and their details! Sorry, thank you...

Principles of Self-tested Database Systems

The main task is to design a database with reasonable structure, convenient use and high efficiency for a department and organization according to application requirements with the support of DBMS.
Gain an in-depth understanding of the working principles of the database system and master the use of Data Language SQL.