Why Worry about Sound Structures?
If your database structure isn’t sound, you’ll have problems retrieving seemingly simple information from your database, it will be difficult to work with your data, and you’ll cringe every time you need to add or delete fields in your tables. Other aspects of the database, such as data integrity, table relationships, and the ability to retrieve accurate information, are affected when you have poorly designed structures. These issues are just the tip of the iceberg. And it goes on! Make sure you have sound structures to avoid all this grief.
You can avoid many of these problems if you properly design your database from the beginning. Even if you’ve already designed your database, all is not lost. You can still ...
Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 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.
