数据库系统概念 第6版 Database system concepts 6th 习题 答案 完整版
2021-12-08 14:17:04
12.44MB
1
Database System Concepts——数据库系统概念第六版（英文版）
作者：
Abraham Silberschatz (Yale University)
Henry F. Korth (Lehigh University)
S. Sudarshan (Indian Institute of Technology, Bombay)
本书目录：
Chapter 1 Introduction
1.1 Database-System Applications 1
1.2 Purpose of Database Systems 3
1.3 View of Data 6
1.4 Database Languages 9
1.5 Relational Databases 12
1.6 Database Design 15
1.7 Data Storage and Querying 20
1.8 Transaction Management 22
1.9 Database Architecture 23
1.10 Data Mining and Information Retrieval 25
1.11 Specialty Databases 26
1.12 Database Users and Administrators 27
1.13 History of Database Systems 29
1.14 Summary 31
Exercises 33
Bibliographical Notes 35
Chapter 2 Introduction to the RelationalModel
2.1 Structure of Relational Databases 39
2.2 Database Schema 42
2.3 Keys 45
2.4 Schema Diagrams 46
2.5 Relational Query Languages 47
2.6 Relational Operations 48
2.7 Summary 52
Exercises 53
Bibliographical Notes 55
Chapter 3 Introduction to SQL
3.1 Overview of the SQL Query Language 57
3.2 SQL Data Definition 58
3.3 Basic Structure of SQL Queries 63
3.4 Additional Basic Operations 74
3.5 Set Operations 79
3.6 Null Values 83
3.7 Aggregate Functions 84
3.8 Nested Subqueries 90
3.9 Modification of the Database 98
3.10 Summary 104
Exercises 105
Bibliographical Notes 112
Chapter 4 Intermediate SQL
4.1 Join Expressions 113
4.2 Views 120
4.3 Transactions 127
4.4 Integrity Constraints 128
4.5 SQL Data Types and Schemas 136
4.6 Authorization 143
4.7 Summary 150
Exercises 152
Bibliographical Notes 156
Chapter 5 Advanced SQL
5.1 Accessing SQL From a Programming Language 157
5.2 Functions and Procedures 173
5.3 Triggers 180
5.4 Recursive Queries 187
5.5 Advanced Aggregation Features 192
5.6 OLAP 197
5.7 Summary 209
Exercises 211
Bibliographical Notes 216
Chapter 6 Formal Relational Query Languages
6.1 The Relational Algebra 217
6.2 The Tuple Relational Calculus 239
6.3 The Domain Relational Calculus 245
6.4 Summary 248
Exercises 249
Bibliographical Notes 254
Chapter 7 Datab
2021-11-15 21:05:36
16.5MB
1