Professional SQL Server 2000 Database Design

✍ Scribed by Louis Davidson, Wrox Author Team

• Publisher: Wrox Press
• Year: 2001
• Tongue: English
• Leaves: 637
• Edition: illustrated edition
• Category: Library

✦ Synopsis

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system.Professional SQL Server 2000 Database Design provides an outline of the techniques that the designer can employ to make effective use of the full range of facilities that SQL Server 2000 offers. It attempts to move away from traditional texts on relational database design by considering design issues from a 'real world' point of view. To that end, it provides a full case study illustrating the scope of the designer's role - right from initial discussions regarding a client's needs, through development of a logical model, to full implementation of the system.

✦ Table of Contents

Cover......Page 1
Table of Contents......Page 9
Introduction......Page 23
Part I Logical Design......Page 29
Ch01 Introduction to Database
Methodologies......Page 33
Ch02 Gathering Information for a Database
Project......Page 47
Ch03 Fundamental Database Concepts......Page 64
Ch04 Entities, Attributes, Relationships, and
Business Rules......Page 92
Ch05 Data Modeling......Page 132
Ch06 Normalization Techniques......Page 174
Ch07 Advanced Normalization Topics......Page 204
Ch08 Ending the Logical Design Phase......Page 226
Part II Physical Design and
Implementation......Page 250
Ch09 Planning the Physical Architecture......Page 254
Ch10 Planning and Implementing the Basic
Physical Architecture......Page 278
Ch11 Ensuring Data Integrity......Page 364
Ch12 Advanced Data Access and
Modification Techniques......Page 434
Ch13 Determining Hardware Requirements......Page 532
Ch14 Completing the Project......Page 576
Appendix A Codd’s 12 Rules for an RDBMS......Page 606
A Guide to the Index......Page 614