Professional SQL Server 2000 Database Design : Texte imprimé

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. 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