Basic Database knowledge Review

Source: Internet
Author: User
Tags table definition

The data models used at the logic layer are classified into two types: one is mainly used for database design, which can be understood by general users and is similar to the way people think. Such models include (ERM). The other is to model data from the perspective of computer systems, making data more suitable for Computer Representation. The model is mainly used for DBMS implementation, for example. A designer's approach to building a database model is usually to first use a E-R model to model data at a high level, and then convert it into a relational model. The data model used at the physical layer is called the physical data model.

It consists of three parts.

(DDL), used to define the database mode; 2) (DML), used to query and update databases; 3) (DCL), used to manage data permissions.

It consists of three parts. In a relational model, the real-world entities and the relationships between entities are expressed.

The logic-based definition is called. Due to the use of different variables, relational calculus is divided into tuples relational calculus and domain relational calculus.

. Entity integrity and referential integrity are integrity constraints that must be met by the relational model ..


. Therefore, the data definition function of SQL includes schema definition, table definition, view definition, and index definition. SQL generally does not support modifying schema definitions, modifying view definitions, and modifying index definitions. If you want to modify these objects, you can only delete them and then recreate them.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.