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.
More ebooks from the same author(s) / Editor
2,298 Ebooks in this category
