Chapter 2. Database Structure

This chapter discusses the first facet of designing relational database models: the structure of the relations themselves. The primary goal of this design phase is simple: to ensure that the model is capable of answering every question that might reasonably be asked of it. The secondary goal is to minimize redundancy and the problems associated with it. We'll examine these two issues in reverse order.