Synopses & Reviews
An Accessible, Up-to-Date Introduction to Database Systems
Database Systems, Second Edition provides a strong foundation in good design practice. Using an accessible, step-by-step approach, students will master a database methodology. Then, the authors apply this methodology to worked examples so students learn to design and build applications using a leading commercial database system. Also, a central, realistic case study is integrated throughout the text to provide an understanding of the issues involved. This new edition will build on the clear, accessible presentation of the successful first edition.
New to the Second Edition
Includes additional and simplified examples.
Features new material on distributed databases including interactions with web-based data.
Contains new material on object-oriented databases that covers the latest ODBM standards.
Illustrates concepts with screen shots from Accessª.
Offers new coverage of query processing and optimization, data mining, data warehouses, multimedia databases, and the Internet.
Table of Contents
PART 1 BACKGROUND
1 Introduction to Databases
2 Database Environment
3 Relational Data Model
4 Database Planning, Design, and Administration
PART 2 METHODOLOGY
5 Entity-Relationship Modelling
7 Methodology - Conceptual Database Design
8 Methodology - Logical Database Design
9 Methodology - Physical Database Design and Implementation for Relational Databases
10 Conceptual Database Design Methodology - Worked Example
11 Logical Database Design Methodology - Worked Example
12 Physical Database Design Methodology - Worked Example
PART 3 DATABASE LANGUAGES
14 Advanced SQL
15 Query-By-Example (QBE)
PART 4 SELECTED DATABASE ISSUES
16 Integrity and Security
17 Transaction Management
18 Query Processing
PART 5 CURRENT TRENDS
19 Distributed DBMSs - Concepts and Design
20 Distributed DBMSs - Advanced Concepts
21 Introduction to Object DBMSs
22 Object-Oriented DBMSs
23 Object-Relational DBMSs
24 Web Technology and DBMSs
25 Data Warehousing
26 OLAP and Data Mining
Appendix A WellMeadows Case Study
Appendix B File Organization and Storage Structures
Appendix C Network Data Model
Appendix D Hierarchical Data Model
Appendix E A Comparison of Network, Hierarchical and Relational Database Systems
Appendix F A Summary of the Database Design Methodology for Relational Databases
Appendix G Example Web Scripts