第1周

1.2 Purpose of Database Systems;

1.3 View of Data;

1.4 Database Languages;

1.5 Relation Database

1,6 Database Design

1.9 Database Architecture

1.12 Database Users and Administrators

1.8，1.9，1.10，1.13，1.14

第2周

2.1 Structure of Relational Database;

2.2 Database Schema;

2.3 Keys;

2.5 Relational query languages

2.6 Relational Operations

6.1 The Relational Algebra

2.11,2.12,2.14

第3周

6.1 The Relational Algebra

6.2 The Tuple Relational Calculus

3.1 Overview of the SQL

3.2 SQL data definition

　6.10,6.14

第4周

3.3 Basic Structure of SQL Queries

3.4 Additional Basic Operations

3.5 Set Operations

3.6 Null Values

3.7 Aggregate Functions

3.8 Nested Subqueries

3.9 Modification of Database

　3.11,3.12,3.21

第5周

周一:实验楼

周二:实验楼

　SQL 语言的运用第一次实验

第6周

4.1 Join Expressions

4.2 Views

4.3 Transactions

4.12,4.13,

SQL 语言的运用第二次实验

第7周

4.4 Integrity Constraints

4.5 SQL Data Types and Schems

4.6 Authorizations

4.16,4.18

SQL 语言的运用第三次实验

第8周

5.1 Accessing SQL From a Programming Language

5.2 Functions and Procedures

5.3 Triggers

5.21,5.22

SQL 语言的运用第四次实验

第9周

7.1 Overview of the Design Process

7.2 The Entity-Relationship Model

7.3 Constraints

7.4 Removing Redundant Attributes in Entity Sets

7.5 Entity-Relationship Diagrams

7.6 Reduction to Relational Schemas

7.7 Entity-Relationship Design Issues

7.8 Extended E-R Features

7.9 Alternative Notations for Modeling Data

7.10 Other Aspects of Database Design

　7.14,7.16,7.20

第10周

8.1Features of Good Relational Designs

8.2 Atomic Domains and First Normal Form

8.3 Decomposition Using Functional Dependencies

　8.19,8.20,8.21,

第11周

8.4 Functional-Dependency Theory

8.5 Algorithms for Decomposition

　8.29

第12周

8.6 Decomposition Using Multivalued Dependencies

8.7 More Normal Forms

8.8 Database-Design Process

8.9 Modeling Temporal Data　

作业答疑

　,8.30,8.31

第13周

数据库设计实验　

第14周

数据库设计实验

第15周

10.3 Organization of Files and Records

10.4 Data-Dictionary Stroage

10.5 Database Buffer

12.1 Transaction Concept

12.2 Transaction Atomicity and Durability

12.3 Transaction Isolation

10.9

12.16,12.17

第16周

12.4 Serializability

12.5 Recoverability

12.6 Concurrency Control

12.7 Recovery System

　12.18,12.22,12.30,12.31