Pro SQL Server 2000 Database Design : Building Quality OLTP Databases

database Design Is One Of The Most Contentious Issues In Computer Science. There Is Always A Delicate Balance To Be Struck Between The Strict Academic Rules That Govern The Design Of Relational Databases And The Real-world Techniques That Programmers Apply To Get The Job Done In A Certain Time Frame. This Book's Goal Is To Coverfrom A Real-world Point Of Viewall Of The Essential Elements In Designing, Modeling, And Building Efficient Relational Databases, While Avoiding A Dry, Theoretical Approach. author Louis Davidson Explains The Process Of Implementing A Databasefrom Generating Tables And Allowing Access To These Tables Using Microsoft Sql Server 2000. This Includes Tackling Data Modeling (focusing On The Idef1x Notation), Requirements Gathering, Normalization (beyond The Third Normal Form), And Implementing Tables, Constraints, Triggers, Procedures, User-defined Functions, And So On. Davidson Provides A Full And Realistic Case Study That Clearly Illustrates The Entire Process, From The Initial Discussions Of A Client's Needs, Through Development Of A Logical Model, To A Complete Implementation Of The System. Front Matter....Pages i-xxiv Introduction to Database Concepts....Pages 1-11 Gathering Information for a Database Project....Pages 13-26 Fundamental Database Concepts....Pages 27-53 Entities, Attributes, Relationships, and Business Rules....Pages 55-89 Data Modeling....Pages 91-128 Normalization Techniques....Pages 129-163 Advanced Normalization Topics....Pages 165-190 Ending the Logical Design Phase....Pages 191-217 Planning the Physical Architecture....Pages 219-243 Building the Basic Table Structures....Pages 245-313 Declarative Data Protection....Pages 315-339 Programmatic Data Protection....Pages 341-365 Advanced Data Access and Modification....Pages 367-457 Determining Hardware Requirements....Pages 459-509 Completing the Project....Pages 511-542 Back Matter....Pages 543-568 An in-depth overview of the process of designing and building efficient, real-world relational databases covers both the logical design of databases and the physical design and implementation of SQL Server 2000, with sections on data protection, data access, data modification, moedling, and more. Original. (Intermediate) * Obtain a deep understanding of database design and modeling concepts. * Implement a complete case study, from initial requirements gathering, right up to the point where it is up and running on SQL Server 2000. * Design and build relational databases that will be more efficient and productive for your organization.