Waraxe IT Security Portal

mirikado · Active user

Wrox Professional SQL Server 2000 Database Design

ISBN: 1861004761 | Author: Louis Davidson | Publisher: Wrox Press | PDF

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.

Content
[INDENT]Part I: Logical Design
Chapter 1: Introduction to Database Methodologies
Chapter 2: Gathering Information for a Database Project
Chapter 3: Fundamental Database Concepts
Chapter 4: Entities, Attributes, Relationships, and Business Rules
Chapter 5: Data Modeling
Chapter 6: Normalization Techniques
Chapter 7: Advanced Normalization Topics
Chapter 8: Ending the Logical Design Phase
Part II – Physical Design and Implementation
Chapter 9: Planning the Physical Architecture
Chapter 10: Planning and Implementing the Basic Physical Architecture
Chapter 11: Ensuring Data Integrity
Chapter 12: Advanced Data Access and Modification Techniques
Chapter 13: Determining Hardware Requirements
Chapter 14: Completing the Project
Appendix A: Codd’s 12 Rules for an RDBMS
A Guide to the Index
[/INDENT]