Skip to main content

Database Development For Dummies

Database Development For Dummies

Allen G. Taylor

ISBN: 978-1-118-08525-7

May 2011

360 pages

$25.99

Description

From ATMs to the personal finance, online shopping to networked information management, databases permeate every nook and cranny of our highly-connected, information-intensive world. 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 very tricky. In fact, 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 this friendly guide comes in.

From data modeling methods and development tools to Internet accessibility and security, Database Development For Dummies shows you, step-by-step, everything you need to know about building a custom system from the ground up. You’ll discover how 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

In plain English, author Allen Taylor acquaints you with the most popular data modeling methods, and he shows you how to systematically design and develop a system incorporating a database and one or more applications that operate on it. Important topics he explores include:

  • Understanding database architecture and how it has evolved
  • Recognizing how database technology affects everyday life
  • Using a structured approach to database development
  • Creating an appropriate data model
  • Developing a reliable relational design
  • Understanding the complexities 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
  • Keeping your database secure
  • Putting your database on the Internet

Today’s powerful, low-cost database development tools make it possible for virtually anybody to create their own database. Get Database Development For Dummies and discover what it takes to design, develop and implement a sophisticated database system tailored to you and your company’s current and future data storage and management needs.

Introduction.

About This Book.

Who Should Read This Book?

Foolish Assumptions.

How This Book Is Organized.

Part I: Basic Concepts.

Part II: Data Modeling: What Should the Database Represent?

Part III: Database Design.

Part IV: Implementing a Database.

Part V: Implementing a Database Application.

Part VI: Using Internet Technology with Database.

Part VII: The Part of Tens.

Conventions Used in This Book.

Icons Used in This Book.

Where to Go From Here.

Part I: Basic Concepts.

Chapter 1: Database Processing.

Chapter 2: Database Development.

Part II: Data Modeling: What Should the Database Represent?

Chapter 3: The Users' Model.

Chapter 4: The Entity-Relationship Model.

Chapter 5: The Semantic Object Model.

Chapter 6: Determining What You Are Going to Do.

Part III: Database Design.

Chapter 7: The Relational Model.

Chapter 8: Using an Entity-Relationship Model to Design a Database.

Chapter 9: Using a Semantic Object Model to Design a Database.

Part IV: Implementing a Database.

Chapter 10: Using DBMS Tools to Implement a Database.

Chapter 11: Addressing Bigger Problems with SQL Server 2000.

Chapter 12: Using SQL to Implement a Database.

Part V: Implementing a Database Application.

Chapter 13: Using DBMS Tools to Implement a Database Application.

Chapter 14: SQL and Database Applications.

Part VI: Using Internet Technology with Database.

Chapter 15: Database on Networks.

Chapter 16: Database Security and Reliability.

Chapter 17: Ten Rules to Remember When Creating a Database.

Chapter 18: Ten Rules to Remember When Creating a Database Application.

Glossary.

Index.

Book Registration Information.