Pro SQL Server 2000 Database Design
Building Quality OLTP Databases |
| Author
|
Louis Davidson |
| Publisher |
Apress
[http://www.apress.com] |
| ISBN |
1590593022 |
| Published |
2003-11 |
| Price |
49.99 USD |
| Features |
[650 pages]
[Site: http://www.apress.com/book/bookDisplay.html?bID=266]
|
| Abstract |
Learn about the process of generating an On-Line Transaction Processing Database on Microsoft's SQL Server 2000 platform. This includes data modeling (IDEFIX notation), requirements gathering, normalization (beyond Third Normal Form), implementing tables, constraints, triggers, procedures, user-defined functions, and more.
|
| Rating |
5
|
| Reviewer |
Daniel Levite |
| Categories | db, design |
|
This book is aimed at the experienced developer. It is a great reference for those looking to analyze database structures for performance and efficiency. While it stops short of typical discussions concerning database administration, it goes into significant detail about logical design.
Particularly good is the discussion and examples for normalization forms. The chapters describing First thru Third Normal Form, Boyce-Codd Normal Form, Fourth, and Fifth Normal form are worth the price of the book.
The chapters on hardware architecture seemed a bit dated, but two-thirds of the book dealing with Logical, Physical, and requirements design were well worth reading. I would recommend this book as an important reference for anyone who deals with Microsoft's SQL Server database.
