Database management systems

New to This Edition

• All New Material on building a web front-end in Chapter 12.
• Expanded coverage of Oracle and SQL Server, especially as related to building Forms and Reports in Chapter 6.
• Expanded coverage in Data Queries and Advanced Queries of OLAP, data warehouses, and data mining (Chapters 4 and 5)
• FREE Student CD-ROM contains the Rolling Thunder and Pet Store sample databases.

• Two fully functional business databases, Sally's Pet Store and Rolling Thunder Bicycles, have been updated to Access 2000 and are tied to examples and exercises in the text. These are available on a free student CD or on the OLC.
• Simplifies the teaching and understanding of database design (chapter 2) by describing and using UML (Unified Modeling Language) notation for data modeling and systems diagrams, instead of using traditional ERDs (entity-relationship diagrams) which have many different notations and techniques. UML is a newer notation standard that major software developers, like Microsoft and Oracle, have adopted.
• Appendix of several cases that can be used as end-of-term projects for building database applications.
• Visual Basic used to build web front end for application development illustrations.

Chapter 1 Introduction

PART I: Systems Design

Chapter 2 Database Design

Chapter 3 Data Normalization

PART II: Queries

Chapter 4 Data Queries

Chapter 5 Advanced Queries

Appendix: SQL Syntax

PART III: Applications

Chapter 6 Forms and Reports

Chapter 7 Calculations and Data Manipulation

Appendix: Introduction to Programming

Chapter 8 Application Development

Appendix: Database Applications in Visual Basic

PART IV: Database Administration

Chapter 9 Physical Design

Chapter 10 Database Administration

PART V: Distribution and Integration of Data

Chapter 11 Distributed Databases and The Internet

Appendix: Introduction to Oracle PL/SQL

Chapter 12 Object-Oriented Databases and Integrated Applications

Appendix Database Projects

Glossary

Index