Description

Business Database Systems arms you with the knowledge to analyse, design and implement effective, robust and successful databases.  This book is ideal for students of Business/Management Information Systems, or Computer Science, who will be expected to take a course in database systems for their degree programme. It is also excellently suited to any practitioner who needs to learn, or refresh their knowledge of, the essentials of database management systems.

Features

Key features

• Three-phase design methodology covering conceptual database design; logical database design; and physical database design.
• Step-by-step approach introduces each stage of the database development life-cycle.
• Extensive coverage of Structured Query Language (SQL), the industry-standard language of databases.
• Advanced chapters on web-database integration; object-oriented database management systems; object-relational database management systems; and business intelligence.
• Highly practical focus with numerous examples and a running ‘real world’ case study.
• Review questions and exercises help you test your understanding.
• Uses the Unified Modelling Language (UML), a universally applied diagramming style, throughout.
• Provides a comprehensive collection of common data models encountered in business.

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

Back Cover

Databases are the underlying framework of any information system. As such, the fortunes of any business or organisation, in no small way, rest upon the efficacy and efficiency of their database systems. Business Database Systems arms you with the knowledge to analyse, design and implement effective, robust and successful databases. Using a tried and tested three-phase methodology, the authors lucidly describe each facet of the database development lifecycle, giving you a complete understanding of the fundamentals in this key topic area and helping you to ensure that your databases are the best that they possibly can be.

This book is ideal for students of Business/Management Information Systems, or Computer Science, who will be expected to take a course in database systems for their degree programme. It is also excellently suited to any practitioner who needs to learn, or refresh their knowledge of, the essentials of database management systems.

Key features

• Three-phase design methodology covering conceptual database design; logical database design; and physical database design.
• Step-by-step approach introduces each stage of the database development life-cycle.
• Extensive coverage of Structured Query Language (SQL), the industry-standard language of databases.
• Advanced chapters on web-database integration; object-oriented database management systems; object-relational database management systems; and business intelligence.
• Highly practical focus with numerous examples and a running ‘real world’ case study.
• Review questions and exercises help you test your understanding.
• Uses the Unified Modelling Language (UML), a universally applied diagramming style, throughout.
• Provides a comprehensive collection of common data models encountered in business.

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.

 

 

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.