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

Chapter 11 Database Management Key points: useful terms and definitions of Database Management Difficult points: Classification of the logical structuring techniques of DBMS

Reasoning with MVDs Higher normal forms Join dependencies and PJNF DKNF

Basic Concepts Tree-Structure Diagrams Data-Retrieval Facility Update Facility Virtual Records Mapping of Hierarchies to Files The IMS Database System

 Map persistent design classes to the data model  Distribute class behavior to the database

Centralized and Client-Server Systems Server System Architectures Parallel Systems Distributed Systems Network Types

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

3.1 Introduction 3.2 Setting Up the Database 3.3 Queries 3.4 View 3.5 Data manipulation 3.6 Security

▪ Reasoning with MVDs ▪ Higher normal forms • Join dependencies and PJNF • DKNF

《数据库系统概念 Database System Concepts》原书教学资源（第七版，PPT课件讲稿，英文版）Chapter 06 Database Design Using the E-R Model