数据库系统基础教程DatabaseSystems-2.pptx

The Relational Model of Data Review Database: what? consist of ? DBMS、DBA、DBSTransaction properties : ACIDAtomicity; Consistency;Isolation; Durability; Relational data model、DDL 、Concurrency control、Logging and recovery、Indexes、Client/ServerMySQL、SqlServer 、OracleContents An Overview of Data Models Basics of the Relational Model Defining a Relation Schema in SQL An Algebraic Query Language Constraints on Relations 2.1 An Overview of Data Models A data model is a notation(符号) for describing data or information.Conceptual model(概念模型)Database data model: the description generally consists of