《数据库系统概论》第四版目录的英文翻译
An Introduction to Database System
CONTENTS
CHAPTER1 Introduction
1.1Brief introduction to database system
1.1.1Data,database,databasemanagementsystem,databasesystem
1.1.3Generationand developmentof Database Management Technology
1.1.3Characteristic of database system
1.2Data Model
1.2.1Two type data model
1.2.2Main elements of data model
1.2.3Conceptual model
1.2.4Most frequently-useddata model
1.2.5Hierarchical model
1.2.6Network model
1.2.7Relational model
1.3Database system structure
1.3.1Concept of database systemschema
1.3.2Tertiary pattern structure
1.3.3Secondary image function of database and Data independence
1.4Composition of the database system
CHAPTER2 Relational database
2.1Relational Datastructure
2.1.1Relation
2.1.2Relationschema
2.1.3Relational database
2.2 Relational operation
2.2.1Basic Relational operation
2.2.2 Relational data language
2.3Integrityofrelation
2.3.1Three types integrity constraints of relation
2.3.2Entity Integrity
2.3.3Referential
2.3.4User-defined Integrity
2.4Relational algebra
2.4.1Traditionalset operation
2.4.2Specialrelational calculus
2.5 Relational calculus
2.5.1 ALPHA
2.5.2 Tuple relational calculus
2.5.3 QBE
《数据库系统概论》第四版目录的英文翻译
CHAPTER3 Relational database standard language SQL
3.1Summary
3.1.1 Generationand development of SQL
3.1.2 Characteristics of SQL
3.1.3Basic concept ofSQL
3.2Student-corse database
3.3 Data definition
3.3.1Definition and delete of schema
3.3.2Definition,delete and Modify of Basic table
3.3.3Build and delete of index
3.4 Data query
3.4.1 Single-table queries
3.4.2 Join query
3.4.3 Nested queries
3.4.4 Collection queries
3.4.5Common form of SELECT statement
3.5 Data update
3.5.1 Inserting data
3.5.2 Modify data
3.5.3 Deleting data
3.6View
3.6.1 View definition
3.6.2 Query view
3.6.3 Update the view
3.6.4 View’s function
CHAPTER4Databasesecurity
4.1 Summary of computer security
4.1.1 Three types problems of computer system
4.1.2Introductionof safety standards
4.2 Databasesecuritycontrol
4.2.1Identification&Authentication
4.2.2Access control
4.2.3DAC method
4.2.4Authorization and retrieve
4.2.5 Database role
4.2.6MAC
4.3 View mechanism
4.4Audit
4.5 Data encryption
4.6 Statistical databasessecurity
CHAPTER5 Database integrity
5.1Entity integrity
《数据库系统概论》第四版目录的英文翻译
5.1.1Definition
5.1.2Check and Default process of Entity integrity
5.2Referential integrity
5.2.1Definition
5.2.2Check and Default process of Referential integrity
5.3 User-defined integrity
5.3.1Constraint conditions’definition onattribute
5.3.2Check and Default process of Constraint conditions on attribute
5.3.3 Constraint conditions’definition ontuple 5.3.4Check and Default process of Constraint conditions on tuple
5.4Integrity constraints naming clause
5.5Integrity constraintsin the domain
5.6Trigger
5.6.1Define trigger
5.6.2Activate trigger
5.6.3Delete trigger
CHAPTER6 Relational data theory
6.1Problem’s production
6.2Standardization
6.2.1Functionally dependant
6.2.2 Code
6.2.3 Normal Form
6.2.42NF(The Second Normal Form)
6.2.53NF(The Third Normal Form)
6.2.6 BCNF
6.2.7 Multivalued Dependency
6.2.8 4NF
6.3Axiomaticsof data dependency
6.4Decomposition ofschemes
6.4.1Three Definitions ofschema decomposition
6.4.2Lossless join and Keep function dependence ofdecomposition
6.4.3Arithmetic of schema decomposition
CHAPTER7 Database design
7.1Summary
7.1.1Characteristics of database design
7.1.2Database design method
7.1.3Basic step of database design
7.1.4All levels schema in thedatabase designprocess
7.2RequirementsAnalysis
7.2.1 RequirementsAnalysis’s tasks
7.2.2 RequirementsAnalysis’s methods
7.2.3Data dictionary
《数据库系统概论》第四版目录的英文翻译
7.3Conception structure design
7.3.1 Conceptual structure
7.3.2Conception structure design’s methods and steps
7.3.3Data abstraction and partial view design
7.3.4 Integration views
7.4Logical structure design
7.4.1Converting Entity-Relationship Diagram into Relation Model
7.4.2Data model’s optimization
7.4.3Design user sub-models
7.5 Physical Design of database system
7.5.1 Physical Design of database systems’contents and methods
7.5.2The choicebetween Relation Schema and Access Method