HAPPY HOLIDAYS: Get a special discount on Apress Access! Subscribe today >>

Pro SQL Server 2000 Database Design

Building Quality OLTP Databases

Authors: Davidson, Louis

Download source code

Buy this book

eBook $39.99
price for USA
  • ISBN 978-1-4302-0708-5
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $49.99
price for USA
  • ISBN 978-1-59059-302-8
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
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 authors

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.

Table of contents (15 chapters)

  • Introduction to Database Concepts

    Davidson, Louis

    Pages 1-11

  • Gathering Information for a Database Project

    Davidson, Louis

    Pages 13-26

  • Fundamental Database Concepts

    Davidson, Louis

    Pages 27-53

  • Entities, Attributes, Relationships, and Business Rules

    Davidson, Louis

    Pages 55-89

  • Data Modeling

    Davidson, Louis

    Pages 91-128

Buy this book

eBook $39.99
price for USA
  • ISBN 978-1-4302-0708-5
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $49.99
price for USA
  • ISBN 978-1-59059-302-8
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Pro SQL Server 2000 Database Design
Book Subtitle
Building Quality OLTP Databases
Authors
Copyright
2004
Publisher
Apress
Copyright Holder
Louis Davidson
eBook ISBN
978-1-4302-0708-5
DOI
10.1007/978-1-4302-0708-5
Softcover ISBN
978-1-59059-302-8
Edition Number
1
Number of Pages
XXIV, 592
Topics