Database Reference
In-Depth Information
Database Design
The four chapters in Part 2 discuss database design principles and
techniques. Chapters 3 and 4 describe the design of databases that arise
from existing data sources, such as spreadsheets, text files, and data-
base extracts. We begin in Chapter 3 by defining the relational model and
discussing normalization, a process that transforms relations with modi-
fication problems. Then, in Chapter 4, we use normalization principles to
guide the design of databases from existing data.
Chapters 5 and 6 examine the design of databases that arise from
the development of new information systems. Chapter 5 describes
the entity-relationship data model, a tool used to create plans for con-
structing database designs. As you will learn, such data models are
developed by analysis of forms, reports, and other informa-
tion systems requirements. Chapter 6 concludes this
part by describing techniques for transforming
entity-relationship data models into relational
database designs.
2
 
 
 
 
Search WWH ::




Custom Search