O'Reilly logo

Microsoft® SQL Server™ 2005: Database Essentials Step by Step by Solid Quality Learning

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required