Database Systems: A Practical Approach to Design, Implementation and Management, 6/e (IE-Paperback)【內含Access Code,經刮除不受退】

<內容簡介>

Database design methodologyis explicitly divided into three phases based on the widely accepted Entity—Relationship model: conceptual, logical, and physical. Each phase is described in a separate chapter with an integrated case study of the methodology working in practice.
 •To help the reader use the methodology and understand the important issues, the methodology has been described using a realistic worked example, based on an integrated case study, DreamHome. 
 •Three additional case studies are provided in Appendix B to allow readers to try out the methodology for themselves. 
•The methodology in each phase is presented as a series of steps. For the inexperienced designer, it is expected that the steps will be followed in the order described, and guidelines are provided throughout to help with this process. For the experienced designer, the methodology can be less prescriptive, acting more as a framework or checklist. 
•An easy-to-use, step-by-step methodology for physical database design, covers the mapping of the logical design to a physical implementation, the selection of file organizations and indexes appropriate for the applications, and when to introduce controlled redundancy. The integrated case study shows how to use the methodology. 
•Separate chapters show how database design fits into the overall database systems development lifecycle, how fact-finding techniques can be used to identify the system requirements, and how UML fits into the methodology.

<章節目錄>

Part I Background
Chapter 1 Introduction to Databases
Chapter 2 Database Environment
Chapter 3 Database Architectures and the Web
Part 2 The Relational Model and Languages
Chapter 4 The Relational Model
Chapter 5 Relational Algebra and Relational Calculus
Chapter 6 SQL: Data Manipulation
Chapter 7 SQL: Data Definition
Chapter 8 Advanced SQL
Chapter 9 Object-Relational DBMSs
Part 3 Database Analysis and Design
Chapter 10 Database System Development Lifecycle
Chapter 11 Database Analysis and the DreamHome Case Study
Chapter 12 Entity-Relationship Modeling
Chapter 13 Enhanced Entity-Relationship Modeling
Chapter 14 Normalization
Chapter 15 Advanced Normalization
Part 4 Methodology
Chapter 16 Methodology－Conceptual Database Design
Chapter 17 Methodology－Logical Database Design for the Relational Model
Chapter 18 Methodology－Physical Database Design for Relational Databases
Chapter 19 Methodology－Monitoring and Tuning the Operational System
Part 5 Selected Database Issues
Chapter 20 Security and Administration
Chapter 21 Professional, Legal, and Ethical Issues in Data Management
Chapter 22 Transaction Management
Chapter 23 Query Processing
Part 6 Distributed DBMSs and Replication
Chapter 24 Distributed DBMSs－Concepts and Design
Chapter 25 Distributed DBMSs－Advanced Concepts
Chapter 26 Replication and Mobile Databases8
Part 7 Object DBMSs
Chapter 27 Object-Oriented DBMSs－Concepts and Design
Chapter 28 Object-Oriented DBMSs－Standards and Systems
Part 8 The Web and DBMSs
Chapter 29 Web Technology and DBMSs
Chapter 30 Semistructured Data and XML
Part 9 Business Intelligence
Chapter 31 Data Warehousing Concepts
Chapter 32 Data Warehousing Design
Chapter 33 OLAP
Chapter 34 Data Mining
Appendices
A Users' Requirements Specification for DreamHome Case Study
B Other Case Studies
C Alternative ER Modeling Notations
D Summary of the Database Design Methodology for Relational Databases
E Introduction to Pyrrho: A Lightweight RDBMS
F File Organizations and Indexes (Online)
G When Is a DBMS Relational? (Online)
H Commercial DBMSs: Access® and Oracle®(Online)
I Programmatic SQL (Online)
J Estimating Disk Space Requirements (Online)
K Introduction to Object-Oriented Concepts (Online)
L Example Web Scripts (Online)
M Query-By-Example (QBE) (Online)
N Third Generation Manifestos (Online)
0 Postgres－An Early ORDBMS (Online)