Skip to main content
SpringerLink
Log in
Apress

Pro SQL Server 2000 Database Design

Building Quality OLTP Databases

  • Book
  • © 2004

Overview

Authors:
  1. Louis Davidson
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Updated printing of a proven best-seller

  • Implements a complete case study, from initial requirements gathering, right up to the point where it is up and running on SQL Server 2000

  • Considers design issues from a real-world point of view for professionals who need efficient and productive relational databases within an organization

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (15 chapters)

  1. Front Matter

    Pages i-xxiv
    Download chapter PDF

  2. Introduction to Database Concepts

    • Louis Davidson
    Pages 1-11

  3. Gathering Information for a Database Project

    • Louis Davidson
    Pages 13-26

  4. Fundamental Database Concepts

    • Louis Davidson
    Pages 27-53

  5. Entities, Attributes, Relationships, and Business Rules

    • Louis Davidson
    Pages 55-89

  6. Data Modeling

    • Louis Davidson
    Pages 91-128

  7. Normalization Techniques

    • Louis Davidson
    Pages 129-163

  8. Advanced Normalization Topics

    • Louis Davidson
    Pages 165-190

  9. Ending the Logical Design Phase

    • Louis Davidson
    Pages 191-217

  10. Planning the Physical Architecture

    • Louis Davidson
    Pages 219-243

  11. Building the Basic Table Structures

    • Louis Davidson
    Pages 245-313

  12. Declarative Data Protection

    • Louis Davidson
    Pages 315-339

  13. Programmatic Data Protection

    • Louis Davidson
    Pages 341-365

  14. Advanced Data Access and Modification

    • Louis Davidson
    Pages 367-457

  15. Determining Hardware Requirements

    • Louis Davidson
    Pages 459-509

  16. Completing the Project

    • Louis Davidson
    Pages 511-542

  17. Back Matter

    Pages 543-568
    Download chapter PDF
Back to top

Keywords

About this book

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 database—from 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.

About the author

Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology (Compass.net) in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.

Bibliographic Information

  • Book Title: Pro SQL Server 2000 Database Design

  • Book Subtitle: Building Quality OLTP Databases

  • Authors: Louis Davidson

  • DOI: https://doi.org/10.1007/978-1-4302-0708-5

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Springer Book Archive

  • Copyright Information: Louis Davidson 2004

  • Softcover ISBN: 978-1-59059-302-8Published: 22 January 2004

  • eBook ISBN: 978-1-4302-0708-5Published: 01 January 2008

  • Edition Number: 1

  • Number of Pages: XXIV, 592

  • Topics: Database Management, Software Engineering/Programming and Operating Systems

Publish with us

Policies and ethics

Back to top

Search

Navigation