|
Business Database Systems
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.
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
|
