数据原理复习概要.

Presentation on theme: "数据原理复习概要."— Presentation transcript:

1 数据原理复习概要

2 题型及分值 1.选择题，15题，30分 2.判断题，10题，10分 3.简答题，2题，10分 4.应用题，10题，30分
Basic concepts 2.判断题，10题，10分 3.简答题，2题，10分 Important concepts 4.应用题，10题，30分 Relational algebra SQL 5.设计题，2题，20分 Design theory High level design

3 考试章节及要点 Chapter 1 Chapter 2 The evolution of database systems
Overview of a database management systems Chapter 2 Data models Basics of the relational model Defining a relation schema in SQL Basic relational algebra Constraints on relations

4 考试章节及要点 Chapter 3 Chapter 4 Functional dependencies
Rules about functional dependencies Design of relational database schemas Chapter 4 The E/R model Design principals Constraints in the E/R model From E/R diagrams to relational designs

5 考试章节及要点 Chapter 6 Chapter 7 Simple queries in SQL
Queries involving more than one relation Subqueries Full-relation operations Database moodifications Chapter 7 Keys and foreign keys Constraints on attributes and tuples Modification of constraints Assertions triggers

6 考试章节及要点 Chapter 8 Chapter 9 Chapter 10 Virtual views Modifying views
Indexes in SQL Chapter 9 The three-tier architecture Stored Procedures Chapter 10 Security of user authorization in SQL

7 考试章节及要点 complements Basics of transaction Recovery system
Concurrent control

8 May you succeed in the final exam.