SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Database Design Processes

With the nuts and bolts of relational database theory covered in the first few pages of this chapter and in Chapter 1, it's time to move on to the database design process. Several database design processes exist and some methods are more generic than others. For example, many DBAs will use the Systems or Software Development Lifecycle (SDLC) as the foundation for their database design process. Others use a simple two-phase model of requirements analysis and then logical design. This section will review some of the common design processes available to you and then share a successful process used after years of consulting work and practical design challenges related to SQL Server databases.

Of the many design models available, ...