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

Chapter 6

ERD and Capacity Planning

TOPICS COVERED IN THIS CHAPTER:

• Planning a Database
• Understanding Entity Relationship Diagramming
• Building an Entity Relationship Diagram (ERD)
• Capacity Planning

In the preceding chapter, you explored the basic components of the database design process. In this chapter, you will learn about the specific steps involved in planning a database. First, you'll learn about the steps that lead up to the logical design. These steps include user surveys, evaluation of business processes, and the development of use cases or activity descriptions.

Next, you'll study an overview of the entity relationship diagramming ...