Pro SQL Server 2000 database design : buidling quality OLTP databases/ /
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...
| Main Author: | |
|---|---|
| Corporate Author: | |
| Format: | eBook |
| Language: | English |
| Published: |
Berkeley, Calif. : New York :
Apress ; Springer,
[2004]
|
| Subjects: | |
| Online Access: | Connect to the full text of this electronic book |
| Summary: | 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 databasefrom 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. |
|---|---|
| Item Description: | Includes index. |
| Physical Description: | 1 online resource (xxiv, 568 pages) |
| ISBN: | 9781430207085 (electronic bk.) 1430207086 (electronic bk.) |