数据原理复习概要
题型及分值 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
考试章节及要点 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
考试章节及要点 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
考试章节及要点 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
考试章节及要点 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
考试章节及要点 complements Basics of transaction Recovery system Concurrent control
May you succeed in the final exam.