Read more
Informationen zum Autor Allen G. Taylor is a 28-year veteran of the computer industry and the author of 17 computer-related books, including SQL For Dummies. In addition to writing, he is a databaseconsultant and seminar leader in database design and application development. Allen lives withhis family on a small farm outside of Oregon City, Oregon. Klappentext 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. Zusammenfassung The key to successful database development is accurate and appropriate modelling of the real-world system that will be placed on the computer. This guide describes two popular modelling methods! the entity-relationship model and the semantic object model. Inhaltsverzeichnis 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 ...