14. Bad Design—What Not to Do

Mistakes are always initial.

—CESARE PAVESE

Topics Covered in This Chapter

Flat-File Design

Spreadsheet Design

Database Design Based on the Database Software

A Final Thought

Summary

You may have wondered why this chapter appears at the end of the book instead of at the beginning. The reason is simple: You can appreciate the dangers presented by a poorly designed database now that you’ve learned how to design a database properly. Additionally, you will be able to determine for yourself why a particular design is bad—you’ll look at the design and be able to identify the problems with the structure immediately. You also possess the knowledge required to identify possible solutions to these problems.

In this chapter, ...

Get Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design, Third 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.