데이터베이스 모델링과 디자인 이라는 책의 lecture note 입니다. (영문입니다)

원본 책에 관한 정보는 http://www.bookpool.com/.x/3a763ea2rn/sm/1558605002 이곳을 참조하시기 바랍니다. 상당히 잘되어 있는 책입니다. :-)

Database Modeling and Design

3rd Edition

Toby J. Teorey

University of Michigan

Lecture Notes

Contents

I. Database Systems and the Life Cycle (Chapter 1)……………………2

Introductory concepts; objectives of database management 2

Relational database life cycle 3

Characteristics of a good database design process 7

II. Requirements Analysis (Chapter 3)………………………………….8

III. Entity-Relationship (ER) Modeling (Chapters 2-4)……………… 11

Basic ER modeling concepts 11

Schema integration methods 22

Entity-relationship 26

Transformations from ER diagrams to SQL Tables 29

IV. Normalization and normal forms (Chapter 5)………………………35

First normal form (1NF) to third normal form (3NF) and BCNF 35

3NF synthesis algorithm (Bernstein) 42

Fourth normal form (4NF) 47

V. Access Methods (Chapter 6)…………………………..………………50

Sequential access methods 50

Random access methods 52

Secondary Indexes 58

Denormalization 62

Join strategies 64

VI. Database Distribution Strategies (Chapter 8)……………………….66

Requirements of a generalized DDBMS: Date’s 12 Rules 68

Distributed database requirements 72

The non-redundant “ best fit” method 74

The redundant “all beneficial sites” method 77

VII. Data Warehousing, OLAP, and Data Mining (Chapter 9)…….....79

Data warehousing 79

On-line analytical processing (OLAP) 86

Data mining 93