Beginning database design

Author(s)

    • Powell, Gavin

Bibliographic Information

Beginning database design

Gavin Powell

(Programmer to programmer)

Wiley, c2006

Available at  / 1 libraries

Search this Book/Journal

Note

Includes index

Description and Table of Contents

Description

This is 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. It 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. It covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance. It 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

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.

by "Nielsen BookData"

Related Books: 1-1 of 1

Details

  • NCID
    BA8487753X
  • ISBN
    • 9780764574900
  • LCCN
    2005026252
  • Country Code
    us
  • Title Language Code
    eng
  • Text Language Code
    eng
  • Place of Publication
    Indianapolis, Ind.
  • Pages/Volumes
    xxiii, 467 p.
  • Size
    24 cm
  • Classification
  • Subject Headings
  • Parent Bibliography ID
Page Top