Why Should You Be Concerned with Database Design?

Some of you who work with RDBMS software programs may wonder why you should be concerned with database design. After all, most RDBMS programs come with sample databases that you can copy and modify to suit your own needs, and you can even borrow tables from the sample databases and use them in other databases that you've created. Some programs also provide tools that will guide you through the process of defining and creating tables. However, these tools don't actually help you design a database—they merely help you create the physical tables that you will include in the database.

What you must understand is that it's better for you to use these tools after you've created the logical database ...

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