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.
Database design is a critical part of the software development process. To ensure that the design fulfills business and ...