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.
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 phasesconceptual, logical, and physical database design.
Introduction to Databases; Database Environment; Database Architectures and the Web. The Relational Model and Languages:
The Relational model; Relational Algebra and Relational Calculus; SQL: Data Manipulation; SQL: Data Definition; Query-By-Example (QBE). Database Analysis and Design:
Database System Lifecycle; Database Analysis and the DreamHome
Case Study; EntityRelationship Modeling; Enhanced EntityRelationship Modeling; Normalization; Advanced Normalization. Methodology:
MethodologyConceptual Database Design; MethodologyLogical Database Design for Relational Model; MethodologyPhysical Database Design for Relational Databases; MethodologyMonitoring and Tuning the Operational System. Selected Database Issues:
Security and Administration; Professional, Legal, and Ethical Issues; Transaction Management; Query Processing. Distributed DBMSs and Replication:
Distributed DBMSsConcepts and Design; Distributed DBMSsAdvanced Concepts; Replication and Mobile Databases. Object DBMSs:
Object-Oriented DBMSsConcepts and Design; Object-Oriented DBMSsStandards and Languages; Object-Relational DBMSs. Web and DBMSs:
Web Technology and DBMSs; Semistructured Data and XML. Business Intelligence Technologies:
Data Warehousing Concepts; Data Warehousing Design; OLAP; Data Mining. Appendices:
Users' Requirements Specification for DreamHome
Case Study; Other Case Studies; Alternative Data Modeling Notations; Summa...