Beginning Database Design.pdf

(11699 KB) Pobierz
Beginning Database Design
12493217.007.png
Beginning Database Design
Gavin Powell
12493217.008.png 12493217.009.png
Contents
Introduction
xvii
Part I: Approaching Relational Database Modeling
1
Chapter 1: Database Modeling Past and Present
3
Grasping the Concept of a Database
4
Understanding a Database Model
5
What Is an Application?
5
The Evolution of Database Modeling
6
File Systems
7
Hierarchical Database Model
8
Network Database Model
8
Relational Database Model
9
Relational Database Management System
11
The History of the Relational Database Model
11
Object Database Model
12
Object-Relational Database Model
14
Examining the Types of Databases
14
Transactional Databases
15
Decision Support Databases
15
Hybrid Databases
16
Understanding Database Model Design
16
Defining the Objectives
17
Looking at Methods of Database Design
20
Summary
21
Chapter 2: Database Modeling in the Workplace
23
Understanding Business Rules and Objectives
24
What Are Business Rules?
25
The Importance of Business Rules
26
Incorporating the Human Factor
27
People as a Resource
27
Talking to the Right People
29
Getting the Right Information
30
12493217.010.png
Contents
Dealing with Unfavorable Scenarios
32
Computerizing a Pile of Papers
32
Converting Legacy Databases
33
Homogenous Integration of Heterogeneous Databases
33
Converting from Spreadsheets
33
Sorting Out a Messed-up Database
34
Summary
34
Chapter 3: Database Modeling Building Blocks
35
Information, Data and Data Integrity
37
Understanding the Basics of Tables
37
Records, Rows, and Tuples
39
Fields, Columns and Attributes
40
Datatypes
42
Simple Datatypes
42
Complex Datatypes
46
Specialized Datatypes
47
Constraints and Validation
47
Understanding Relations for Normalization
48
Benefits of Normalization
49
Potential Normalization Hazards
49
Representing Relationships in an ERD
49
Crows Foot
50
One-to-One
51
One-to-Many
52
Many-to-Many
53
Zero, One, or Many
55
Identifying and Non-Identifying Relationships
57
Understanding Keys
58
Primary Keys
59
Unique Keys
59
Foreign Keys
60
Understanding Referential Integrity
63
Understanding Indexes
64
What Is an Index?
65
Alternate Indexing
65
Foreign Key Indexing
65
Types of Indexes
66
Different Ways to Build Indexes
68
Introducing Views and Other Specialized Objects
69
Summary
70
Exercises
70
x
12493217.001.png 12493217.002.png
 
12493217.003.png
Contents
Part II: Designing Relational Database Models
71
Chapter 4: Understanding Normalization
73
What Is Normalization?
74
The Concept of Anomalies
74
Dependency, Determinants, and Other Jargon
76
Defining Normal Forms
80
Defining Normal Forms the Academic Way
80
Defining Normal Forms the Easy Way
81
1st Normal Form (1NF)
82
1NF the Academic Way
82
1NF the Easy Way
83
2nd Normal Form (2NF)
89
2NF the Academic Way
89
2NF the Easy Way
89
3rd Normal Form (3NF)
96
3NF the Academic Way
96
3NF the Easy Way
97
Beyond 3rd Normal Form (3NF)
103
Why Go Beyond 3NF?
104
Beyond 3NF the Easy Way
104
One-to-One NULL Tables
104
Beyond 3NF the Academic Way
107
Boyce-Codd Normal Form (BCNF)
108
4th Normal Form (4NF)
111
5th Normal Form (5NF)
116
Domain Key Normal Form (DKNF)
121
Summary
122
Exercises
122
Chapter 5: Reading and Writing Data with SQL
123
Defining SQL
124
The Origins of SQL
125
SQL for Different Databases
125
The Basics of SQL
126
Querying a Database Using SELECT
127
Basic Queries
127
Filtering with the WHERE Clause
130
Precedence
132
Sorting with the ORDER BY Clause
134
xi
12493217.004.png 12493217.005.png 12493217.006.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin