Chapter 3

Why Good Design Matters

Abstract

This chapter reinforces the idea that there are significant practical reasons to care about database design. It discusses the problems that occur frequently with poorly designed databases, as a prelude to the following chapters that teach the principles of good database design.

Keywords

database design
poor database design
insertion anomalies
deletion anomalies
entity identifiers
Many of today’s businesses rely on their database systems for accurate, up-to-date information. Without those repositories of mission-critical data, most businesses are unable to perform their normal daily transactions, much less create summary reports that help management make corporate decisions. To be useful, the data in a database ...

Get Relational Database Design and Implementation, 4th 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.