Chapter 17. Database Design Issues

by Orryn Sledge

IN THIS CHAPTER

  • Problems that Can Arise from an Improperly Designed Database

  • Normalization

  • Denormalization

  • FAQ

A properly designed database can increase data integrity and simplify data maintenance. To help you better understand how to design a database, the following concepts are discussed in this chapter:

  • Problems that can arise from an improperly designed database

  • How to correctly design a database

  • How to take a properly designed database a step backwards in order to improve performance

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second 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.