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.
Anonymous
Posted Sat Jun 12 00:00:00 EDT 2004
How much do you already know about designing and implementing a SQL database? That is really two questions. The first refers to applying a well trodden theory of SQL design to your application. What tables should you conceptually extract? How should these be interrelated by judicious choice of primary and foreign keys? What are the germane attributes in each table? All these issues are explained by Davidson in the first part of the book. He goes well into discussing how to normalise data, and the numerous normal forms. He does this at a level independent of SQL Server. So even if your database is dB2 or Oracle or whatever, you should be able to profitably gain something from his teachings. But having designed your database, now comes having to implement it. The second part of the book. Here is the SQL Server specific material. The details specific to its implementation do matter. But you know what? A fair amount of the examples use mostly standard SQL commands. In your application, you should probably strive to do likewise, to the maximum extent possible. It minimises the amount of inevitable lockin to SQL Server. There are also sections in the second part that apply to any relational database. Like his description of best practices, in chapter 13. Davidson presents a useful balance between design and implementation. A favourable contrast to texts that predominently deal with only one aspect.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
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,...