MCSE Training Kit (Exam 70-229): Microsoft® SQL Server™ 2000 Database Design and Implementation

Author Microsoft Corporation Pages 688 Disk 1 Companion CD(s) Level All Levels Published 04/25/2001 ISBN 9780735612488 ISBN-10 0-7356-1248-X Price(USD) $59.99 To see this book's discounted price, select a reseller below.	More Information About the Book Table of Contents Sample Chapter Index Related Series Related Books About the Author Support: Book & CD Rate this book

Chapter 3: Designing a SQL Server Database

• Lesson 1:  Introduction to Database Design
• Components of a SQL Server Database
• Normalizing a Database Design
• Entity Relationships
• Lesson Summary
• Lesson 2:  Planning a SQL Server Database
• Files and Filegroups
• Transaction Logs
• Environment
• SQL Server Installation
• Security
• Lesson Summary
• Lesson 3:  Identifying System Requirements
• The Process of Identifying System Requirements
• Identifying System Goals
• Identifying the Amount and Types of Data
• Identifying How the Data Will Be Used
• Identifying Business Rules of the System
• Lesson Summary
• Lesson 4:  Developing a Logical Data Model
• Identifying Entities and Their Attributes
• Identifying Relationships Between Entities
• Identifying Constraints on Data
• Lesson Summary
• Review

Chapter 3 Designing a SQL Server Database

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.

Before You Begin

To complete the lessons in this chapter, you must have

• SQL Server 2000 Enterprise Edition installed on a Windows 2000 Server computer.
• The ability to log on to the Windows 2000 Server computer and to SQL Server as the Windows 2000 administrator.
• Paper and a pen or pencil to complete part of the exercises.

Top of Page

Last Updated: Saturday, July 7, 2001