Database Systems: A Practical Approach to Design, Implementation, and Management, Global Edition

About our authors Thomas M. Connolly was Head of Computing and Information Systems at the University of Paisley (now the University of the West of Scotland) for many years and now runs his own database and software consultancy house, DS Partnership.Carolyn E. Begg worked at the University of the West of Scotland for decades as coordinator and lecturer of core and advanced database topics across all computing programmes and now supports third-sector organisations on their data management practices.

• Introduction to DatabasesDatabase EnvironmentDatabase Architectures and Cloud ComputingThe Relational ModelRelational Algebra and Relational CalculusSQL: Data ManipulationSQL: Data DefinitionAdvanced SQLDatabase System Development LifecycleDatabase Analysis and the DreamHome Case StudyEntity–Relationship ModelingEnhanced Entity–Relationship ModelingNormalizationAdvanced NormalizationMethodology—Conceptual Database DesignMethodology—Logical Database Design for the Relational ModelMethodology—Physical Database Design for Relational DatabasesMethodology—Monitoring and Tuning the Operational SystemSecurity and AdministrationProfessional, Legal, and Ethical Issues in Data ManagementTransaction ManagementQuery ProcessingDistributed DBMSs—Concepts and DesignDistributed DBMSs—Advanced ConceptsReplication and Mobile DBMSsThe Web, Cloud, and MicroservicesModern Frameworks in Database-Driven DevelopmentObject-Relational DBMSsObject-Oriented DBMSsNoSQL, Multimodel, and NewSQL DBMSsData Warehousing ConceptsData Warehousing DesignOLAPData MiningAPPENDICES A. Users’ Requirements Specification for DreamHome Case StudyB. Other Case StudiesC. Alternative ER Modeling NotationsD. Summary of the Database Design Methodology for Relational DatabasesE. File Organizations and IndexesF. When Is a DBMS Relational? (Online)G. Estimating Disk Space Requirements (Online)H. Introduction to Object-Oriented Concepts (Online)