Testing Your Database Design

Once you've come up with a proposed design for your database, you should create the tables and insert some data. (The next chapter gives detailed information on these procedures.) Then you should test your design by running queries and updating the data. Your tests may reveal oversights in the design.

Database designs are seldom satisfactory when based entirely on theory. It's essential to play with your design interactively before undertaking serious production efforts—especially if you plan to use it in an application that will involve thousands of lines of programming code and tens of thousands of rows of data. Don't ...

Get Practical SQL Handbook, The: Using SQL Variants, Fourth 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.