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

Summary

In this chapter, you learned the important steps required to plan a database. You began by looking at business requirements analysis. Business process mapping can be used to determine the requirements of a database because it results in step-by-step procedures required to fulfill a business-related action.

Entity relationship diagramming (ERD) was explained to help you understand logical and physical database models. Logical database models are not system specific, and physical models are specific to a selected database solution, such as SQL Server or MySQL.

Next, you explored using ERD tools. The first tool used was Microsoft's commercial diagramming tool, Visio. With Visio you can create graphically compelling ER diagrams and help is ...