Business Database Systems

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

• 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