Modern Database Management

by Hoffer, Jeffrey A.; Prescott, Mary; McFadden, Fred R.

• ISBN13: 9780130339690
• ISBN10: 0130339695
• Edition: 6th
• Format: Hardcover
• Copyright: 2002-01-01
• Publisher: PRENTICE HALL

Summary

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.

Table of Contents

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

Excerpts

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