Chapter 5: Designing a Database to Solve Business Needs

Overview

After completing this chapter, you will be able to:

• Model business needs

• Validate business requirements through entity-relationship models

• Understand Microsoft SQL Server 2005 datatypes

• Enforce data integrity through table constraints

In this chapter, you will learn how to design and create a database to support business and application requirements. You will learn modeling techniques and practices that will assist in the process of transforming a business requirement document into the Transact-SQL (T-SQL) code required to create the database.