Chapter 2

Building a Database Model


Bullet Finding and listening to interested parties

Bullet Building consensus

Bullet Building a relational model

Bullet Knowing the dangers of anomalies

Bullet Avoiding anomalies with normalization

Bullet Denormalizing with care

Asuccessful database system must satisfy the needs of a diverse group of people. This group includes the folks who’ll actually enter data and retrieve results, but it also includes a host of others. People at various levels of management, for example, may rely on reports generated by the system. People in other functional areas, such as sales or manufacturing, may use the products of the system, such as reports or bar code labels. The information technology (IT) people who set overall data processing standards for the organization may also weigh in on how the system is constructed and the form of the outputs it will produce. When designing a successful ...

Get SQL All-In-One For Dummies, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.