Professional SQL Server 2000 Database Design

by Louis Davidson

• ISBN13: 9781861004765
• ISBN10: 1861004761
• Edition: 1st
• Format: Trade Paper
• Copyright: 2001-04-01
• Publisher: WROX

Summary

SQL has established itself as the world's most popular language for database programming, and SQL Server 2000 is the latest update to Microsoft's data warehousing and relational database management system. On top of core titles such as Professional SQL Server 2000, Wrox provides comprehensive coverage of the latest additions to the database, with Professional Data Warehousing with SQL Server 2000 and Analysis Services. However, Wrox also provides a springboard for developers looking to begin programming databases, with Beginning Databases with PostgreSQL.

Table of Contents

Introduction	p. 1
Logical Design	p. 7
Introduction to Database Methodologies	p. 11
Gathering Information for a Database Project	p. 25
Entities, Attributes, Relationships, and Business Rules	p. 69
Data Modeling	p. 103
Normalization Techniques	p. 145
Advanced Normalization Topics	p. 175
Ending the Logical Design Phase	p. 197
Physical Design and Implementation	p. 221
Planning the Physical Architecture	p. 225
Planning and Implementing the Basic Physical Architecture	p. 249
Ensuring Data Integrity	p. 335
Advanced Data Access and Modification Techniques	p. 405
Determining Hardware Requirements	p. 503
Completing the Project	p. 547
Codd's 12 Rules for an RDBMS	p. 577
A Guide to the Index	p. 585
Table of Contents provided by Syndetics. All Rights Reserved.