Allen G. Taylor 
Database Development For Dummies 

Powerful, low-cost database development tools make it possible for virtually anybody to create their own database–and this hands-on guide makes it fun and easy

Databases permeate every nook and cranny of our highly connected, information-intensive world, from ATMs to personal finance, online shopping, and networked information management. Databases have become so integral to the business environment that, nowadays, it’s next to impossible to stay competitive without the assistance of some sort of database technology–no matter what type or size of business you run. But developing your own database can be tricky. Whether you want to keep records for a small business or run a large e-commerce website, developing the right database system can be a major challenge. Which is where Database Development For Dummiescomes in.

From data modeling methods and development tools to Internet accessibility and security, this comprehensive guide shows you, step-by-step and with illustrations, everything you need to know about building a custom system from the ground up. You’ll learn to:

* Model data accurately

* Design a reliable functional database

* Deliver robust relational databases on time and on budget

* Build a user-friendly database application

* Put your database on the Web

The book acquaints you with the most popular data modeling methods and shows you how to systematically design and develop a system incorporating a database and one or more applications that operate on it. Here’s more of what you’ll discover in the book:

* Database architecture and how it has evolved

* How database technology affects everyday life

* A structured approach to database development

* How to create an appropriate data model

* How to develop a reliable relational design

* The complexities that you’re likely to encounter in designing a database and how to simplify them

* Implementing your design using Microsoft Access 2000, SQL Server, and other powerful database development tools

* Database security

* Ten rules to know when creating a database

* Another ten rules to know when creating a database application

If you need a database tailored to you and your company’s current and future data storage and management needs, this is the book for you. Get Database Development For Dummiesand discover what it takes to design, develop, and implement a sophisticated database system.

Table of Content

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

About the author

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.