Database Systems: A Practical Approach to Design, Implementation, and Management, Global Edition
6th Edition
Published on 18. May 2023
Other
Undefined
978-1-292-43636-4 (ISBN)
Description
For one- or two-term course in database management or database design With its comprehensive coverage, this book can also be used as a reference for IT professionals. This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases - conceptual, logical, and physical database design.
More details
Edition
6th edition
Language
English
Place of publication
Harlow
United Kingdom
Target group
College/higher education
ISBN-13
978-1-292-43636-4 (9781292436364)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Thomas M. Connolly is the Head of the Computing and Information Systems division at the University of Paisley.
Carolyn E. Begg is a lecturer at the University of Paisley, with research interests in Information Systems, Database Management Systems, and Decision Support Systems within medicine
Carolyn E. Begg is a lecturer at the University of Paisley, with research interests in Information Systems, Database Management Systems, and Decision Support Systems within medicine
Content
Part 1 Background
Chapter 1 Introduction to Databases
Database Environment
Database Architectures and the Web
Part 2 The Relational Model and Languages
Chapter 4 The Rational Model
Chapter 5 Relational Algebra and Relational Calculus
Chapter 6 SQL: Data Manipulation
Chapter 7 SQL: Data Definition
Chapter 8 Advanced SQL
Chapter 9 Object-Relational DBMSs
Part 3 Database Analysis and Design
Chapter 10 Database System Development Lifecycle
Chapter 11 Database Analysis and the DreamHome Case Study
Chapter 12 Entity-Relationship Modeling
Chapter 13 Enhanced Entity-Relationship Modeling
Chapter 14 Normalization
Chapter 15 Advanced Normalization
Part 4 Methodology
Chapter 16 Methodology - Conceptual Database Design
Chapter 17 Methodology - Logical Database Design for the Relational Model
Chapter 18 Methodology - Physical Database Design for Relational Databases
Chapter 19 Methodology - Monitoring and Tuning the Operational System
Part 5 Selected Database Issues
Chapter 20 Security and Administration
Chapter 21 Professional, Legal, and Ethical Issues in Data Management
Chapter 22 Transaction Management
Chapter 23 Query Processing
Part 6 Distributed DBMSs and Replication
Chapter 24 Distributed DBMSs - Concepts and Design
Chapter 25 Distributed DBMSs - Advanced Concepts
Chapter 26 Replication and Mobile Databases
Part 7 Object DBMSs
Chapter 27 Object-Oriented DBMSs - Concepts and Design
Chapter 28 Object-Oriented DBMSs - Standard Systems
Part 8 The Web and DBMSs
Chapter 29 Web Technology and DBMSs
Chapter 30 Semistructured Data and XML
Part 9 Business Intelligence
Chapter 31 Data Warehousing Concepts
Chapter 32 Data Warehousing Design
Chapter 33 OLAP
Chapter 34 Data Mining
Appendices References Further Reading Index
Chapter 1 Introduction to Databases
Database Environment
Database Architectures and the Web
Part 2 The Relational Model and Languages
Chapter 4 The Rational Model
Chapter 5 Relational Algebra and Relational Calculus
Chapter 6 SQL: Data Manipulation
Chapter 7 SQL: Data Definition
Chapter 8 Advanced SQL
Chapter 9 Object-Relational DBMSs
Part 3 Database Analysis and Design
Chapter 10 Database System Development Lifecycle
Chapter 11 Database Analysis and the DreamHome Case Study
Chapter 12 Entity-Relationship Modeling
Chapter 13 Enhanced Entity-Relationship Modeling
Chapter 14 Normalization
Chapter 15 Advanced Normalization
Part 4 Methodology
Chapter 16 Methodology - Conceptual Database Design
Chapter 17 Methodology - Logical Database Design for the Relational Model
Chapter 18 Methodology - Physical Database Design for Relational Databases
Chapter 19 Methodology - Monitoring and Tuning the Operational System
Part 5 Selected Database Issues
Chapter 20 Security and Administration
Chapter 21 Professional, Legal, and Ethical Issues in Data Management
Chapter 22 Transaction Management
Chapter 23 Query Processing
Part 6 Distributed DBMSs and Replication
Chapter 24 Distributed DBMSs - Concepts and Design
Chapter 25 Distributed DBMSs - Advanced Concepts
Chapter 26 Replication and Mobile Databases
Part 7 Object DBMSs
Chapter 27 Object-Oriented DBMSs - Concepts and Design
Chapter 28 Object-Oriented DBMSs - Standard Systems
Part 8 The Web and DBMSs
Chapter 29 Web Technology and DBMSs
Chapter 30 Semistructured Data and XML
Part 9 Business Intelligence
Chapter 31 Data Warehousing Concepts
Chapter 32 Data Warehousing Design
Chapter 33 OLAP
Chapter 34 Data Mining
Appendices References Further Reading Index