Chapter 4. Gathering and Understanding Business Requirements before Creating Database Objects

After completing this chapter, you will be able to:

  • Gather requirements from the database perspective

  • Understand business data and its lifetime

  • Pinpoint operating requirements such as performance, scalability, and security

  • Estimate capacity planning

In previous lessons, you learned the basics of Microsoft SQL Server 2005: how it may help you, how to install it, and what tools it offers. We will now shift the focus from SQL Server 2005 to your application and explore the way you should capture business requirements to build a solid foundation for your design.

Programmers and project managers frequently underestimate how critical the gathering and comprehension ...

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.