• Chapter 11: Defining User Needs and Requirements
• Chapter 12: Building a Data Model
• Chapter 13: Extracting Business Rules
• Chapter 14: Normalizing and Refining

The chapters in the next part of the book walk through a fictitious case study for the Pampered Pet, a pet supply store. These chapters work through the steps for building the company a new database, from requirements gathering to implementation.

Chapter 11 begins the development process by gathering user requirements. It walks through the project's initial steps, including meeting the customers, picking the customers' brains, and examining the database's performance, security, and data integrity needs. It finishes by developing use cases and requirements documents.

Chapter 12 uses the requirements gathered in Chapter 11 to build initial data models. It builds semantic object models and entity-relationship models to satisfy the project's requirements and makes some improvements on the initial models.

Chapter 13 examines the models so far and determines which business rules should be implemented inside the database and which should be extracted into middle-tier or user interface code.

Chapter 14 converts the models built in Chapter 13 into a normalized relational model.

As you work through these chapters, you might find it useful to build an example of your own. Pick some other business, fictitious or otherwise, and work through the corresponding phases of database design and development as you read along.