Professional SQL Server 2000 Database Design

( 1 )

Overview

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system.

Professional SQL Server 2000 Database Design provides an outline of the techniques that the designer can employ to make effective use of the full range of facilities that SQL Server 2000 offers. It attempts to move away from traditional texts on relational database design by considering design issues from a "real world" point of view. To that end, ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (15) from $1.99   
  • New (2) from $31.84   
  • Used (13) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$31.84
Seller since Tue Jan 01 01:01:01 EST 2008

Feedback rating:

(171)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
1861004761 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$70.00
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system.

Professional SQL Server 2000 Database Design provides an outline of the techniques that the designer can employ to make effective use of the full range of facilities that SQL Server 2000 offers. It attempts to move away from traditional texts on relational database design by considering design issues from a "real world" point of view. To that end, it provides a full case study illustrating the scope of the designer's role - right from initial discussions regarding a client's needs, through development of a logical model, to full implementation of the system.

This book is aimed at developers who have an interest in learning more about general relational database design issues. While it will aid the reader to have a familiarity with SQL Server and the Transact-SQL language, this book has a wider appeal for any experienced database programmers wishing to learn more about relational database theory and design.

Read More Show Less

Product Details

  • ISBN-13: 9781861004765
  • Publisher: Wrox Press, Inc.
  • Publication date: 3/1/2001
  • Series: Professional Ser.
  • Pages: 627
  • Product dimensions: 7.25 (w) x 9.19 (h) x 1.31 (d)

Meet the Author

Louis Davidson is an avowed database nut. Currently he is toiling as the database architect for Education Networks of America in Nashville, Tennessee, not to mention writing this book and hopefully one more.

He has been designing and implementing Microsoft SQL Server databases for around nine years, since his brilliant failure as a LAN Administrator for the Church of God International Headquarters in Cleveland, Tennessee (yes, there is a Cleveland in Tennessee). As SQL Server came packaged with Visual Basic 1.0 back then, he has also been developing with that product for around nine years, although his VB skills have been progressively getting worse since version 4.0, as he has been focusing primarily on SQL Server.

Louis has spoken at several conferences, such as CA-World in 1999 and 2000, concerning implementing solutions with ERwin; and at PASS 2000 Europe, he gave two presentations, one on normalization and the other on query optimization.

Read More Show Less

Table of Contents

Introduction 1
Part I Logical Design 7
Chapter 1 Introduction to Database Methodologies 11
Chapter 2 Gathering Information for a Database Project 25
Chapter 4 Entities, Attributes, Relationships, and Business Rules 69
Chapter 5 Data Modeling 103
Chapter 6 Normalization Techniques 145
Chapter 7 Advanced Normalization Topics 175
Chapter 8 Ending the Logical Design Phase 197
Part II Physical Design and Implementation 221
Chapter 9 Planning the Physical Architecture 225
Chapter 10 Planning and Implementing the Basic Physical Architecture 249
Chapter 11 Ensuring Data Integrity 335
Chapter 12 Advanced Data Access and Modification Techniques 405
Chapter 13 Determining Hardware Requirements 503
Chapter 14 Completing the Project 547
Appendix A Codd's 12 Rules for an RDBMS 577
A Guide to the Index 585
Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted Fri Aug 03 00:00:00 EDT 2001

    REQUIRED READING!!!!!!

    This book is the missing link between academic theory and technical how-to manuals! It is very well written.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)