Table of Contents

Part I Background 1. Introduction 2.The Relational Model 3. SQL and QBE 4. The database system development lifecycle Part II Database Analysis and Design Techniques 5. Fact Finding 6. Entity-Relationship Modeling 7. Enhanced ER Modeling 8. Normalization Part III Database Design Methodology 9. Conceptual Database Design, Step 1 10. Logical Database Design, Step 2 11. Physical Database Design Part IV Current and Emerging Trends 12. Database administration and security 13. Professional, legal, and ethical issues in data management 14. Transaction Management 15. eCommerce and Database Systems 16. Distributed and Mobile DBMSs 17. Object DBMSs 18. Business Intelligence Appendices A The buyer user view for StayHome Online Rentals B Second case study Perfect Pets C Alternative data modeling notations D summary of the database design methodology E Advanced SQL F Guidelines for choosing indexes G Guidelines for denormalization H Object-oriented concepts I Common data models

About the Author

The authors Prof. 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.