Database Development For Dummies

This "prequel" to "SQL For Dummies" tells why and how database systems came into being, and then using actual examples, describes the many obstacles to success that frequently arise in database development projects and how to handle them.

Introduction 1

Part I: Basic Concepts 7
Chapter 1: Database Processing 9
Chapter 2: Database Development 21

Part II: Data Modeling: What Should the Database Represent? 39
Chapter 3: The Users' Model 41
Chapter 4: The Entity-Relationship Model 49
Chapter 5: The Semantic Object Model 67
Chapter 6: Determining What You Are Going to Do 89

Part III: Database Design 103
Chapter 7: The Relational Model 105
Chapter 8: Using an Entity-Relationship Model to Design a Database 129
Chapter 9: Using a Semantic Object Model to Design a Database 141

Part IV: Implementing a Database 159
Chapter 10: Using DBMS Tools to Implement a Database 161
Chapter 11: Addressing Bigger Problems with SQL Server 2000 199
Chapter 12: Using SQL to Implement a Database 217

Part V: Implementing a Database Application 229
Chapter 13: Using DBMS Tools to Implement a Database Application 231
Chapter 14: SQL and Database Applications 251

Part VI: Using Internet Technology with Database 257
Chapter 15: Database on Networks 259
Chapter 16: Database Security and Reliability 271

Part VII: The Part of Tens 281
Chapter 17: Ten Rules to Remember When Creating a Database 283
Chapter 18: Ten Rules to Remember When Creating a Database Application 289

Glossary 293

Index 305