Modern database management / Jeffrey A. Hoffer, Mary B. Prescott, Fred R. McFadden.

Enhanced descriptions from Syndetics:

Reacting to the business environment, this work addresses issues such as Internet, data warehousing and object-orientation. The text instructs from a business perspective, allowing students to understand database management within a business.

Table of contents provided by Syndetics

• Preface (p. xxiii)
• Part I The Context of Database Management
• Part I Overview (p. 2)
• 1 The Database Environment (p. 3)
• Learning Objectives (p. 3)
• Data Matters! (p. 3)
• Introduction (p. 4)
• Basic Concepts and Definitions (p. 6)
• Traditional File Processing Systems (p. 10)
• File Processing Systems at Pine Valley Furniture Company (p. 11)
• The Database Approach (p. 13)
• Advantages of The Database Approach (p. 14)
• Cautions About Database Benefits (p. 16)
• Costs and Risks of The Database Approach (p. 16)
• Components of the Database Environment (p. 17)
• The Range of Database Applications (p. 18)
• Evolution of Database Systems (p. 25)
• Summary (p. 28)
• Chapter Review (p. 29)
• Case: Mountain View Community Hospital (p. 33)
• 2 The Database Development Process (p. 36)
• Learning Objectives (p. 36)
• Introduction (p. 36)
• Database Development Within Information Systems Development (p. 37)
• Database Development Process (p. 42)
• Managing the People Involved in Database Development (p. 50)
• Three-Schema Architecture for Database Development (p. 52)
• Three-Tiered Database Location Architecture (p. 56)
• Developing a Database Application for Pine Valley Furniture Company (p. 57)
• Summary (p. 70)
• Chapter Review (p. 71)
• Case: Mountain View Community Hospital (p. 76)
• Part II Database Analysis
• Part II Overview (p. 84)
• 3 Modeling Data in the Organization (p. 85)
• Learning Objectives (p. 85)
• Introduction (p. 85)
• Modeling the Rules of the Organization (p. 87)
• The E-R Model: An Overview (p. 93)
• Modeling Entities and Attributes (p. 96)
• Modeling Relationships (p. 106)
• E-R Modeling Example: Pine Valley Furniture Company (p. 123)
• Database Processing at Pine Valley Furniture (p. 125)
• Summary (p. 128)
• Chapter Review (p. 129)
• Case: Mountain View Community Hospital (p. 137)
• 4 The Enhanced E-R Model and Business Rules (p. 139)
• Learning Objectives (p. 139)
• Introduction (p. 139)
• Representing Supertypes and Subtypes (p. 140)
• Specifying Constraints in Supertype/Subtype Relationships (p. 147)
• EER Modeling Example: Pine Valley Furniture (p. 153)
• Entity Clustering (p. 157)
• Packaged Data Models (p. 160)
• Business Rules Revisited (p. 166)
• Summary (p. 174)
• Chapter Review (p. 175)
• Case: Mountain View Community Hospital (p. 181)
• Part III Database Design
• Part III Overview (p. 186)
• 5 Logical Database Design and the Relational Model (p. 187)
• Learning Objectives (p. 187)
• Introduction (p. 187)
• The Relational Data Model (p. 188)
• Integrity Constraints (p. 193)
• Transforming EER Diagrams into Relations (p. 197)
• Introduction to Normalization (p. 211)
• Normalization Example: Pine Valley Furniture Company (p. 214)
• Merging Relations (p. 220)
• A Final Step for Defining Relational Keys (p. 223)
• Summary (p. 225)
• Chapter Review (p. 226)
• Case: Mountain View Community Hospital (p. 235)
• 6 Physical Database Design and Performance (p. 240)
• Learning Objectives (p. 240)
• Introduction (p. 240)
• Physical Database Design Process (p. 241)
• Designing Fields (p. 244)
• Designing Physical Records and Denormalization (p. 248)
• Designing Physical Files (p. 254)
• Using and Selecting Indexes (p. 265)
• RAID: Improving File Access Performance by Parallel Processing (p. 267)
• Designing Databases (p. 270)
• Optimizing for Query Performance (p. 273)
• Summary (p. 278)
• Chapter Review (p. 279)
• Case: Mountain View Community Hospital (p. 284)
• Part IV Implementation
• Part IV Overview (p. 288)
• 7 Introduction to SQL (p. 289)
• Learning Objectives (p. 289)
• Introduction (p. 289)
• History of the SQL Standard (p. 291)
• The Role of SQL in a Database Architecture (p. 292)
• The SQL Environment (p. 293)
• Defining a Database in SQL (p. 298)
• Inserting, Updating, and Deleting Data (p. 304)
• Internal Schema Definition in RDBMSs (p. 307)
• Processing Single Tables (p. 308)
• Summary (p. 326)
• Chapter Review (p. 327)
• Case: Mountain View Community Hospital (p. 332)
• 8 Advanced SQL (p. 333)
• Learning Objectives (p. 333)
• Introduction (p. 333)
• Processing Multiple Tables (p. 334)
• Ensuring Transaction Integrity (p. 349)
• Data Dictionary Facilities (p. 350)
• SQL:2003 Enhancements and Extensions to SQL (p. 352)
• Triggers and Routines (p. 356)
• Embedded SQL and Dynamic SQL (p. 360)
• Summary (p. 362)
• Chapter Review (p. 363)
• Case: Mountain View Community Hospital (p. 367)
• 9 The Client/Server Database Environment (p. 368)
• Learning Objectives (p. 368)
• Location, Location, Location! (p. 368)
• Introduction (p. 369)
• Client/Server Architectures (p. 370)
• Three-Tier Architectures (p. 374)
• Partitioning an Application (p. 376)
• Role of the Mainframe (p. 378)
• Using Middleware (p. 379)
• Client/Server Issues (p. 382)
• Using ODBC to Link External Tables Stored on a Database Server (p. 383)
• Using JDBC to Link External Tables Stored on a Database Server (p. 385)
• Looking Forward with Client/Server in Mind (p. 386)
• Summary (p. 386)
• Chapter Review (p. 387)
• Case: Mountain View Community Hospital (p. 390)
• 10 The Internet Database Environment (p. 392)
• Learning Objectives (p. 392)
• Introduction (p. 392)
• The Internet and Database Connection (p. 393)
• The Internet Environment (p. 394)
• Common Internet Architecture Components (p. 396)
• Web-to-Database Tools (p. 403)
• Summary (p. 414)
• Chapter Review (p. 415)
• Case: Mountain View Community Hospital (p. 418)
• 11 Data Warehousing (p. 420)
• Learning Objectives (p. 420)
• Introduction (p. 420)
• Basic Concepts of Data Warehousing (p. 422)
• Data Warehouse Architectures (p. 428)
• Some Characteristics of Data Warehouse Data (p. 437)
• The Reconciled Data Layer (p. 441)
• Data Transformation (p. 447)
• The Derived Data Layer (p. 452)
• The User Interface (p. 465)
• Summary (p. 470)
• Chapter Review (p. 471)
• Case: Mountain View Community Hospital (p. 478)
• Part V Advanced Database Topics
• Part V Overview (p. 482)
• 12 Data and Database Administration (p. 483)
• Learning Objectives (p. 483)
• Introduction (p. 483)
• The Roles of Data and Database Administrators (p. 485)
• The Open-Source Movement (p. 492)
• Modeling Enterprise Data (p. 494)
• Managing Data Security (p. 495)
• Database Backup and Recovery (p. 510)
• Controlling Concurrent Access (p. 517)
• Managing Data Quality (p. 523)
• Data Dictionaries and Repositories (p. 527)
• Overview of Tuning the Database for Performance (p. 529)
• Data Availability (p. 533)
• Summary (p. 535)
• Chapter Review (p. 535)
• Case: Mountain View Community Hospital (p. 542)
• 13 Overview: Distributed Databases (p. 544)
• Learning Objectives (p. 544)
• Overview (p. 544)
• Chapter Review (p. 547)
• 14 Overview: Object-Oriented Data Modeling (p. 548)
• Learning Objectives (p. 548)
• Overview (p. 548)
• Chapter Review (p. 555)
• 15 Overview: Object-Oriented Database Development (p. 556)
• Learning Objectives (p. 556)
• Overview (p. 556)
• Chapter Review (p. 561)
• Appendix A Data Modeling Tools and Notation (p. 562)
• Comparing E-R Modeling Conventions (p. 562)
• Visio Professional 2003 Notation (p. 562)
• AllFusion ERwin Data Modeler 4.1 SPI Notation (p. 565)
• Sybase Power Designer 11.1 Notation (p. 568)
• Oracle Designer Notation (p. 569)
• Comparison of Tool Interfaces and E-R Diagrams (p. 571)
• Appendix B Advanced Normal Forms (p. 572)
• Boyce-Codd Normal Form (p. 572)
• Anomalies in STUDENT_ADVISOR (p. 573)
• Definition of Boyce-Codd Normal Form (BCNF) (p. 573)
• Converting a Relation to BCNF (p. 573)
• Fourth Normal Form (p. 574)
• Multivalued Dependencies (p. 576)
• Higher Normal Forms (p. 576)
• Appendix Review (p. 577)
• Key Terms (p. 577)
• References (p. 577)
• Web Resources (p. 577)
• Appendix C Data Structures (p. 578)
• Pointers (p. 578)
• Data Structure Building Blocks (p. 579)
• Linear Data Structures (p. 581)
• Stacks (p. 582)
• Queues (p. 583)
• Sorted Lists (p. 583)
• Multilists (p. 585)
• Hazards of Chain Structures (p. 586)
• Trees (p. 587)
• Balanced Trees (p. 587)
• References (p. 590)
• Appendix D Object-Relational Databases (p. 591)
• Basic Concepts and Definitions (p. 591)
• Features of an ORDBMS (p. 592)
• Complex Data Types (p. 592)
• Enhanced SQL (p. 593)
• A Simple Example (p. 594)
• Content Addressing (p. 594)
• Advantages of the Object-Relational Approach (p. 595)
• ORDBMS Vendors and Products (p. 595)
• Appendix Review (p. 596)
• Key Terms (p. 596)
• References (p. 596)
• Web Resources (p. 596)
• Glossary of Acronyms (p. 597)
• Glossary of Terms (p. 600)
• Index (p. 609)

Author notes provided by Syndetics

Jeffrey A. Hoffer ( hoffer@udayton.edu ) is the Sherman Standard Register Professor of Data Management in the MIS, Operations Management, and Decision Sciences Department at the University of Dayton. He received a PhD from Cornell University in 1973 and was on the faculties of Case Western Reserve University and Indiana University before joining UD. He is a founder of the INFORMS College on Information Systems, the International Conference on Information Systems (and its conference chair in 1985), and the Association for Information Systems. He is author of many scholarly publications in the areas of database management, data warehousing, systems analysis, strategic systems planning, and human-computer interaction. He is co-author of several leading textbooks: Modern Database Management , Modern Systems Analysis and Design , Essentials of Systems Analysis and Design , Object-Oriented Systems Analysis and Design , and Managing Information Technology: What Managers Need to Know , all published by Prentice-Hall. Dr. Hoffer is also an Associate Director of the Teradata University Network, the leading web portal for faculty and students in the data management, data warehousing, decision support, and business intelligence areas.