|
Beginning Database Design & Implementation
* The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently
* Shows how to design and implement robust, scalable databases on any of the major relational database management systems,
including Access, SQL Server, IBM DB2, MySQL, and Oracle
* Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance
* Provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements
Introduction.
Part I: Approaching Relational Database Modeling.
Chapter 1: Database Modeling Past and Present.
Chapter 2: Database Modeling in the Workplace.
Chapter 3: Database Modeling Building Blocks.
Part II: Designing Relational Database Models.
Chapter 4: Understanding Normalization.
Chapter 5: Reading and Writing Data with SQL.
Chapter 6: Advanced Relational Database Modeling.
Chapter 7: Understanding Data Warehouse Database Modeling.
Chapter 8: Building Fast-Performing Database Models.
Part III: A Case Study in Relational Database Modeling.
Chapter 9: Planning and Preparation Through Analysis.
Chapter 10: Creating and Refining Tables During the Design Phase.
Chapter 11: Filling in the Details with a Detailed Design.
Chapter 12: Business Rules and Field Settings.
Part IV: Advanced Topics.
Chapter 13: Advanced Database Structures and Hardware Resources.
Glossary.
Appendix A: Exercise Answers.
Appendix B: Sample Databases.
Index.
|
