Database Processing Fundamentals, Design, and Implementation (12...

内容简介 《数据库处理:基础、设计与实现(第11版)(英文版)》从基础、设计和实现三个层面介绍数据库处理技术，内容全面翔实，既包括数据库设计、数据库实现、多用户数据处理、数据访问标准等经典理论，也包括商务智能、XML和NET等最新技术。《数据库处理:基础、设计与实现(第11版)(英文版)》在内容编排和写作风格上新颖，强调学习过程中的乐趣，围绕两个贯穿全书的项目练习，让读者从一开始就能把所学的知识用于解决具体的应用实例。 《数据库处理:基础、设计与实现(第11版)(英文版)》每章都有丰富的习题，可作为高校本科生或研究生的数据库课程的双语教材，同时也是一本很好的专业参考书。 编辑推荐 《数据库处理:基础、设计与实现(第11版)(英文版)》：提前介绍了SQL查询 使用“螺旋方法”进行数据库设计 为数据建模和数据库设计使用了一种通用的信息工程“鸦脚”E-R模型 详细探讨了实际规范技术中的特定范式 使用了最新的DBMS技术：Microsoft Access 2007，Microsoft SQL．Setver 2008，Oracle Database 11g，MySQI 5．1 基于广泛使用的Web开发技术，创建了Web数据库应用 简介了商务智能系统 探讨了数据仓库和联机分析处理数据库设计中使用的维数据库概念 作者简介 作者：（美国）克罗恩克（David M.Kroenke） （美国）奥尔（David Auer） 目录 Preface xvii PART 1 GETTING STARTED Chapter 1:Introduction Chapter Objectives The Characteristics of Databases A Note on Naming Conventions A Database Has Data and Relationships Databases Create Information Database Examples Single-User Database Applications Multiuser Database Applications E-Commerce Database Applications Reporting and Data Mining Database Applications The Components of a Database System Database Applications and SQL The DBMS The Database Personal Versus Enterprise-Class Database Systems What Is Microsoft Access? What Is an Enterprise-Class Database System? Database Design Database Design from Existing Data Database Design for New Systems Development Database Redesign What You Need to Learn A Brief History of Database Processing The Early Years The Emergence and Dominance of the Relational Model Post-Relational Developments Summary Key Terms Review Questions Project Questions Chapter 2:Introduction to Structured Query Language Chapter Objectives Cape Codd Outdoor Sports The Retail Sales Data Extraction RETAIL_ORDER Data ORDER ITEM Data SKU_DATA Table Data Extracts Are Common SQL Background The SQL SELECT/FROM/WHERE Framework Reading Specified Columns from a Single Table Reading Specified Rows from a Single Table Reading Specified Columns and Rows from a Single Table Submitting SQL Statements to the DBMS Using SQL in Microsoft Access 2007 Using SQL in Microsoft SQL Server 2008 Using SQL in Oracle Database 11g Using SQL in Sun Microsystems MySQL 5.1 SQL Enhancements for Querying a Single Table Sorting the Results SQL WHERE Clause Options Combing the SQL WHERE Clause and the SQL ORDER BY Clause Performing Calculations in SQL Queries Using SQL Built-in Functions SQL Expressions in SQL SELECT Statements Grouping in SQL SELECT Statements Looking for Patterns in NASDAQ Trading Investigating the Characteristics of the Data Searching for Patterns in Trading by Day of Week Querying Two or More Tables with SQL Querying Multiple Tables with Subqueries Querying Multiple Tables with Joins Comparing Subqueries and Joins Summary Key Terms Review Questions Project Questions Marcia's Dry Cleaning Morgan Importing PART 2 DATABASE DESIGN Chapter 3:The Eelational Model and Normalization Chapter Objectives Relational Model Terminology Relations Characteristics of Relations Alternative Terminology Functional Dependencies Finding Functional Dependencies Keys Normal Forms Modification Anomalies A Short History of Normal Forms Normalization Categories From First Normal Form to Boyce-Codd Normal Form Eliminating Anomalies from Functional Dependencies Eliminating Anomalies from Multivalued Dependencies Fifth Normal Form Domain/Key Normal Form Summary Key Terms Review Questions Project Questions Marcia's Dry Cleaning Morgan Importing Chapter 4:Database Design Using Normalization Chapter Objectives Assess Table Structure Designing Updatable Databases Advantages and Disadvantages of Normalization Functional Dependencies Normalizing with Choosing Not to Use BCNF Multivalued Dependencies Designing Read-Only Databases Denormalization Customized Duplicated Tables Common Design Problems The Multivalue, Multicolumn Problem Inconsistent Values Missing Values The General-Purpose Remarks Column Summary Key Terms Review Questions Project Questions Marcia's Dry Cleaning Morgan Importing Chapter 5:Data Modeling with the Entity-Relationship Model Chapter Objectives The Purpose of a Data Model The Entity-Relationship Model Entities Attributes Identifiers Relationships Maximum Cardinality Minimum Cardinality Entity-Relationship Diagrams and Their Versions Variations of the E-R Model E-R Diagrams Using the IE Crow's Foot Model Strong Entities and Weak Entities ID-Dependent Entities Non-ID-Dependent Weak Entities Subtype Entities Patterns in Forms, Reports, and E-R Models Strong Entity Patterns ID-Dependent Relationships Mixed Identifying and Nonidentifying Patterns The For-Use-By Pattern Recursive Patterns The Data Modeling Process The College Report The Department Report The Department/Major Report The Student Acceptance Letter Summary Key Terms Review Questions Project Questions Marcia's Dry Cleaning Morgan Importing Chapter 6:Transforming Data Models into Database Designs Chapter Objectives Create a Table for Each Entity Selecting the Primary Key Specifying Candidate (Alternate) Keys Specify Column Properties Verify Normalization Create Relationships Relationships Between Strong Entities Relationships Using ID-Dependent Entities Relationships with a Weak Non-ID-Dependent Entiy Relationships in Mixed Entity Designs Relationships Between Supertype and Subtype Entities Recursive Relationships Representing Ternary and Higher-Order Relationships Relational Representation of the Highline University Data Model Design for Minimum Cardinality Actions When the Parent Is Required Actions When the Child Is Required Implementing Actions for M-O Relationships Implementing Actions for O-M Relationships Implementing Actions for M-M Relationships Designing Special Case M-M Relationships Documenting the Minimum Cardinality Design An Additional Complication Summary of Minimum Cardinality Design The View Ridge Gallery Database Summary of Requirements The View Ridge Data Model Database Design with Data Keys Minimum Cardinality Enforcement for Required Parents Minimum Cardinality Enforcement for the Required Child Column Properties for the View Ridge Database Design Tables Summary Key Terms Review Questions Project Questions Marcia's Dry Cleaning Morgan Importing PART 3 DATABASE IMPLEMENTATION Chapter 7:SQL for Database Construction and Application Processing Chapter Objectives The View Ridge Gallery Database SQL DDL, DML, and a New Type of Join …… PART 4 MULTIUSER DATABASE PROCESSING PART 5 DATABASE ACCESS STANDARDS APPENDICES Bibliography Glossary Index 序言 The 11th edition of Database Processing refines the organization and content of this classic textbook to reflect a new teaching and professional workplace environment. The organization and topic selection of the llth edition is designed to： ·Present an early introduction to SQL queries. ·Use a‘'spiral approach'’to database design. ·Use a consistent，generic Information Engineering（IE）Crow's Foot E-R diagram notation for data modehng and database design. Provide a detailed discussion of specific normal forms within a discussion of normal-ization that focuses on pragmatic normalization techniques. ·Use current DBMS technology：Microsoft Access 2007。Microsoft SQL Server 2008，Oracle Database llg。and MySQL 5.1. ·Create Web database applications based on widely used Web development technology. ·Provide an introduction to business in teHigence（BI）systems. ·Discuss the dimensional database concepts used in database designs for data ware-houses and 0nLine Analytical Processing（OLAP）.