Chapter 3: Designing a SQL Server Database

Download CD Content

About This Chapter

A SQL Server database consists of a collection of tables that contain data and other objects-including views, indexes, stored procedures, and triggers-that are defined so as to support activities performed with the data. The data stored in a database is usually related to a particular subject or process, such as a retailer's customer information or a manufacturer's sales information. This chapter introduces you to the process of creating a SQL Server database and describes the basic concepts of database design. This chapter also provides information about planning a database, identifying system requirements, and developing a logical data model.