In Chapter 5, we looked at gathering the requirements of the business. This process is similar to the process you go through whether you are building a house, developing an application, or trying to plan a birthday party. Much of what we look at is theory and can be applied in any of these scenarios. Sure, we looked at a few topics specific to database design, but the overall process is generic.

In this chapter, we get at the heart of database design; we look at how you begin to shape the business requirements into a database model, and eventually a physical database. We also get into the specifics of our make-believe customer, Mountain View Music, by taking a look at its requirements and exploring how to turn ...

Get A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 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.