Description
Book SynopsisThe 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.
Table of ContentsIntroduction 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
