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.



Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
ISBN: N/A
EAN: N/A
Year: 2006
Pages: 130

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net