Purpose of Database Systems View of Data Database Languages Relational Databases Database Design Object-based and semistructured databases Data Storage and Querying Transaction Management Database Architecture Database Users and Administrators Overall Structure History of Database Systems

About SQL SQL is a standard database language, adopted by many commercial systems. ANSI SQL, SQL-92 or SQL2, SQL99 or SQL3 extends SQL2 with object￾relational features. SQL2003 is the collection of extensions to SQL3. How to query the database How to make modifications on database Transactions in SQL

Chapter 1: Introduction Applications of Database Systems Database Systems versus File Systems View of Data Data Models Database Language Database Users and Administrator Transaction Management Database System Structure Application Architectures

Design Process Modeling Constraints E-R Diagram Design Issues Weak Entity Sets Extended E-R Features Design of the Bank Database Reduction to Relation Schemas Database Design UML

The Need for Databases Data Models Relational Databases Database Design Storage Manager Query Processing Transaction Manager [美] 西尔伯沙茨（Abrahm Silberschatz），[美] 科思（Henry F.Korth），[美] 苏达尔（S.Sudarshan） Database System Concepts Sixth Edition Avi Silberschatz Henry F. Korth S. Sudarshan McGraw-Hill ISBN 0-07-352332-1 Face The Real World of Database Systems Fully Equipped

Design Process Modeling Constraints E-R Diagram Design Issues Weak Entity Sets Extended E-R Features Design of the Bank Database Reduction to Relation Schemas Database Design UML

Features of Good Relational Design Atomic Domains and First Normal Form Decomposition Using Functional Dependencies Functional Dependency Theory Algorithms for Functional Dependencies Decomposition Using Multivalued Dependencies More Normal Form Database-Design Process Modeling Temporal Data

▪ Centralized Database Systems ▪ Server System Architectures ▪ Parallel Systems ▪ Distributed Systems ▪ Network Types

• Databse introduction • Database creation and maintenance • Database query

Chapter 7: Relational Database Design First Normal Form Pitfalls in Relational Database Design Functional Dependencies Decomposition Boyce-Codd Normal Form Third Normal Form Multivalued Dependencies and Fourth Normal Form