9780130339690

For Database Management and Database Systems courses. Reacting to the current business environment, Modern Database Management, 6/e addresses current issues in the market, such as Internet, data warehousing and object-orientation. While sufficient technical explanations are given, the text instructs from a business perspective, allowing students to understand the role of database management within a business.

Part I The Context of Database Management

The Database Environment

3

(31)

Database Development Process

34

(41)

Part II Database Analysis

Modeling Data in the Organization

75

(52)

The Enhanced E-R Model and Business Rules

127

(38)

Part III Database Design

Logical Database Design and the Relational Model

165

(43)

Physical Database Design and Performance

208

(49)

Part IV Implementation

SQL

257

(38)

Advanced SQL

295

(26)

The Client/Server Database Environment

321

(42)

The Internet Database Environment

363

(30)

Data Warehousing

393

(54)

Part V Advanced Database Topics

Data and Database Administration

447

(46)

Distributed Databases

493

(30)

Object-Oriented Data Modeling

523

(33)

Object-Oriented Database Development

556

(57)

Appendices

A E-R Modeling Tools and Notation

581

(8)

B Advanced Normal Forms

589

(6)

C Data Structures

595

(13)

D Object-Relational Databases

608

(5)

Glossary of Acronyms

613

(2)

Glossary of Terms

615

(11)

Credits

626

(1)

Index

627

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

This text is designed for an introductory course in database management. I Such a course is usually required as part of an information systems curriculum in business schools, computer technology programs, and applied computer science departments. The Association of Information Technology Professionals (AITP), Association for Computing Machinery (ACM), and International Federation of Information Processing Societies (IFIPS) curriculum guidelines (for example, IS '97) all outline this type of database management course. Previous editions of our text have been used successfully for more than 15 years at both the undergraduate and graduate levels, as well as in management and professional development programs. This text represents an extensive revision and updating of the fifth edition ofModern Database Management.These revisions are necessary to accommodate the technical, managerial, and methodological changes occurring at an ever-increasing pace in this field. However, we have endeavored to retain the best features of our previous editions. We have made every effort to justify the titleModern Database Management,which was introduced in the fourth edition. In this sixth edition we have changed the order of authorship because of the reduced involvement of Fred McFadden as he eases into retirement. Fred has reviewed every page of the manuscript and provided sage guidance on the direction of the revisions. Fred McFadden is the "father" of this text, and his words and ideas will always be present on its pages. New to This Edition The sixth edition ofModern Database Managementupdates and expands materials in areas undergoing rapid change due to improved managerial practices, database design tools and methodologies, and database technology. The themes of the sixth edition reflect the major trends in the informations systems field and the skills required of modern information systems graduates: Web-enabled systems design and programming within an overall client/server architecture for systems Large-scale databases and data warehouses Clarifying system requirements through thorough system modeling and design Criticality of database performance in an increasingly on-line environment SQL as a standard for database querying In all the chapters, new screen captures are included to reflect the latest database technologies and a new Web Resources section lists Websites that can provide the student with the information on the latest database trends and expanded background details on important topics covered in the text. The major structural changes to the text are: The two object-oriented database chapters are now adjacent chapters, and have been moved to the end of the text, where they are presented as a continuous coverage of this emerging database technology and where they do not break up the natural flow among the other chapters. The client/server section of the book has been extensively rewritten and now emphasizes the Internet, intranet, and extranet as implementations of a client/server architecture. SQL is now covered in more depth and in two chapters. The data warehousing chapter has been significantly rewritten and moved forward as a chapter in the implementation section of the book, representing the explosive growth of this form of database. The following presents a chapter-by-chapter description of the major changes in this edition. Each chapter description presents a statement of the purpose of that chapter, followed by a description of the changes and revisions that have been made since the fifth edition. Each paragraph concludes with a description of the strengths that have been retained from the fifth edition. Part I: The Context of Database Management Chapter 1: The Database Environment.This chapter discusses the role of database

Amazon no longer offers textbook rentals. We do!

Modern Database Management

Modern Database Management

0130339695

Summary

Table of Contents

Supplemental Materials

Excerpts