Beginning Database Design

Gavin Powell

  • 出版商: Wrox Press
  • 出版日期: 2005-12-05
  • 售價: $1,460
  • 貴賓價: 9.5$1,387
  • 語言: 英文
  • 頁數: 504
  • 裝訂: Paperback
  • ISBN: 0764574906
  • ISBN-13: 9780764574900
  • 已過版




  • 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

Table of Contents 


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.


Appendix A: Exercise Answers.

Appendix B: Sample Databases.