Part I  Background1. Introduction2.The Relational Model3. SQL and QBE4. The database system development lifecyclePart II  Database Analysis and Design Techniques5. Fact Finding6. Entity-Relationship Modeling7. Enhanced ER Modeling8. NormalizationPart III  Database Design Methodology9. Conceptual Database Design, Step 110. Logical Database Design, Step 211. Physical Database DesignPart IV  Current and Emerging Trends12. Database administration and security13. Professional, legal, and ethical issues in data management14. Transaction Management15. eCommerce and Database Systems16. Distributed and Mobile DBMSs17. Object DBMSs18. Business IntelligenceAppendicesA The buyer user view for StayHome Online RentalsB Second case study  Perfect PetsC Alternative data modeling notationsD summary of the database design methodologyE Advanced SQLF Guidelines for choosing indexesG Guidelines for denormalizationH Object-oriented conceptsI Common data models
The authorsProf. Thomas Connolly is Chair of the ITCE in Education Research Group at the University of the West of Scotland, and Director of the Scottish Centre for Enabling Technologies. He is a winner of the British Design Award for his work on database systems.Dr. Carolyn Begg is a lecturer in the School of Computing at the University of the West of Scotland where she teaches Business Database Systems, Advanced Business Systems, and Business Intelligence. Prof. Connolly and Dr. Begg are authors of the best-selling Database Systems which has sold over 1/4 million copies worldwide.Dr. Richard Holowczak is Associate Professor of Computer Information Systems at Zicklin School of Business, City University of New York where he has taught courses on databases, business intelligence, security and financial information technologies since 1997. Dr. Holowczak is also director of the Wasserman Trading Floor / Subotnick Financial Services Centre.