Business Database Systems
Published on 28. November 2009
Book
Paperback/Softback
800 pages
978-0-321-52220-7 (ISBN)
Description
Databases are the underlying framework of any information system. As such, the fortunes of any business or organization, in no small way, rest upon the efficacy and efficiency of their database systems.Business Database Systems arms readers 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 a complete understanding of the fundamentals in this key topic area and helping to ensure that databases are the best that they possibly can be.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 232 mm
Width: 187 mm
ISBN-13
978-0-321-52220-7 (9780321522207)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Persons
Professor 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, Baruch College, 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.
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, Baruch College, 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.
Content
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
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