Chapter 5. Designing a Database to Solve Business Needs
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.
Designing a Database Conceptually
Database design is a critical part of the software development process. To ensure that the design fulfills business and ...
Get Microsoft® SQL Server™ 2005: Database Essentials Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
