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 ¼ 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.