Designing Relational Database Systems (Dv-Mps Designing)

Chapter 6

In Part 1 of this book, we looked at the principles of relational database design. But the structure of the data is only one component of a database system—a critical component, obviously, but still only a single component. Beginning with this section, we'll look at some of the remaining aspects of designing database systems.

In this part, we'll discuss most of the activities involved in the analysis and design of database systems, including the definition of system parameters and work processes, the conceptual database model, and the database schema. The design of the user interface, because it is such a complex topic, will be discussed in Part 3.

I'll be examining only the analysis and design of database systems here; implementation lies outside the scope of this book. But analysis and design can't exist in isolation from the rest of the process, so we'll begin with a brief discussion of project life cycles.