FIFTEENTH EDITION DATABASE PROCESSING
40th Anniversary Edition
FIFTEENTH EDITION
D ATA B A S E P R O C E S S I N G
FUNDAMENTALS, DESIGN, AND IMPLEMENTATION
David M. Kroenke
David J. Auer
Western Washington University
Scott L. Vandenberg
Siena College
Robert C. Yoder
Siena College
A01_KROE2749_15_SE_FM.indd 1
14/12/17 4:03 PM
Vice President, IT & Careers: Andrew Gilfillan
Senior Portfolio Manager: Samantha Lewis
Managing Producer: Laura Burgess
Associate Content Producer: Stephany Harrington
Portfolio Management Assistant: Madeline Houpt
Director of Product Marketing: Brad Parkins
Product Marketing Manager: Heather Taylor
Product Marketing Assistant: Jesika Bethea
Field Marketing Manager: Molly Schmidt
Field Marketing Assistant: Kelli Fisher
Cover Image: Cover art ¡°waterfall¡± by Donna Auer
Vice President, Product Model Management: Jason Fournier
Senior Product Model Manager: Eric Hakanson
Lead, Production and Digital Studio: Heather Darby
Digital Studio Course Producer: Jaimie Noy
Program Monitor: SPi Global
Full-Service Project Management
and Composition: Cenveo? Publisher Services
Printer/Binder: LSC Communications
Cover Printer: Phoenix
Text Font: 10/12 Mentor Pro
Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on the appropriate page within text.
Microsoft and/or its respective suppliers make no representations about the suitability of the information contained in the documents and -related
graphics published as part of the services for any purpose. All such documents and related graphics are provided ¡°as is¡± without warranty of any kind.
Microsoft and/or its respective suppliers hereby disclaim all warranties and conditions with regard to this information, including all -warranties and
conditions of merchantability, whether express, implied or statutory, fitness for a particular purpose, title and non-infringement. In no event shall
Microsoft and/or its respective suppliers be liable for any special, indirect or consequential damages or any damages whatsoever -resulting from loss of
use, data or profits, whether in an action of contract, negligence or other tortious action, arising out of or in connection with the use or performance of
information available from the services.
The documents and related graphics contained herein could include technical inaccuracies or typographical errors. Changes are periodically added
to the information herein. Microsoft and/or its respective suppliers may make improvements and/or changes in the product(s) and/or the program(s)
described herein at any time. Partial screen shots may be viewed in full within the software version specified.
?
?
?
Microsoft Windows , and Microsoft Office are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. This book is not
sponsored or endorsed by or affiliated with the Microsoft Corporation.
?
?
?
?
MySQL , the MySQL Command Line Client , the MySQL Workbench , and the MySQL Connector/ODBC are registered trademarks of Sun
Microsystems, Inc./Oracle Corporation. Screenshots and icons reprinted with permission of Oracle Corporation. This book is not sponsored or endorsed
by or affiliated with Oracle Corporation.
Oracle Database 12c Release 2 and Oracle Database Express Edition 11g Release 2 2017 by Oracle Corporation. Reprinted with permission. Oracle and
Java are registered -trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Mozilla 35.104 and Mozilla are registered trademarks of the Mozilla Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
PHP is copyright The PHP Group 1999¨C2012, and is used under the terms of the PHP Public License v3.01 available at .
This book is not sponsored or endorsed by or affiliated with The PHP Group.
ArangoDB is a copyright of ArangoDB GmbH.
Copyright ? 2018, 2016, 2014, 2012 by Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030. All rights reserved. Manufactured in
the United States of America. This publication is protected by Copyright, and permission should be obtained from the publisher prior to any prohibited
reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise.
To obtain permission(s) to use material from this work, please submit a written request to Pearson Education, Inc., Permissions Department, 221 River
Street, Hoboken, New Jersey 07030.
Many of the designations by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this
book, and the publisher was aware of a trademark claim, the designations have been printed in initial caps or all caps.
Library of Congress Cataloging-in-Publication Data
Names: Kroenke, David M., 1948- author. | Auer, David J., author. |
Vandenberg, Scott L., author. | Yoder, Robert C., author.
Title: Database processing : fundamentals, design, and implementation /David
M. Kroenke, David J. Auer, Western Washington University, Scott L.
Vandenberg, Siena College, Robert C. Yoder, Siena College.
Description: 15th edition, 40th anniversary edition. | Boston : Pearson,
[2018] | Includes bibliographical references and index.
Identifiers: LCCN 2017041164| ISBN 9780134802749 | ISBN 0134802748
Subjects: LCSH: Database management.
Classification: LCC QA76.9.D3 K7365 2018 | DDC 005.74¡ªdc23 LC record available
at
ISBN 10:?? 0-13-480274-8
ISBN 13: 978-0-13-480274-9
A01_KROE2749_15_SE_FM.indd 2
18/12/17 4:33 PM
Brief Contents
PART 1
¡ö
Getting Started
Chapter 1
Chapter 2
PART 2
¡ö
¡ö
¡ö
145
The Relational Model and Normalization 146
Database Design Using Normalization 191
Data Modeling with the Entity-Relationship Model 212
Transforming Data Models into Database Designs 267
Database Implementation
Chapter 7
Chapter 8
PART 4
Introduction 2
Introduction to Structured Query Language 38
Database Design
Chapter 3
Chapter 4
Chapter 5
Chapter 6
PART 3
1
323
SQL for Database Construction and Application Processing 324
Database Redesign 424
Multiuser Database Processing
Chapter 9
Chapter 10
453
Managing Multiuser Databases 454
Managing Databases with Microsoft SQL Server 2017, Oracle Database,
and MySQL 5.7 490
Online Chapter: See page 495 for Instructions
Chapter 10A
Managing Databases with Microsoft SQL Server 2017
Online Chapter: See page 495 for Instructions
Chapter 10B
Managing Databases with Oracle Database
Online Chapter: See page 495 for Instructions
Chapter 10C
PART 5
¡ö
Managing Databases with MySQL 5.7
Database Access Standards
Chapter 11
Chapter 12
497
The Web Server Environment 498
Data Warehouses, Business Intelligence Systems, and Big Data 569
Online Appendices: See page 620 for Instructions
Appendix A
Appendix B
Appendix C
Appendix D
Appendix E
Appendix F
Appendix G
Appendix H
Appendix I
Appendix J
Appendix K
Appendix L
A01_KROE2749_15_SE_FM.indd 3
Getting Started with Microsoft Access 2016
Getting Started with Systems Analysis and Design
E-R Diagrams and the IDEF1X and UML Standards
Getting Started with Microsoft Visio 2016
Getting Started with the MySQL Workbench Data Modeling Tools
The Semantic Object Model
Physical Database Design and Data Structures for Database Processing
Getting Started with Web Servers, PHP, and the NetBeans IDE
XML
Business Intelligence Systems
Big Data
JSON and Document Databases
iii
14/12/17 4:03 PM
A01_KROE2749_15_SE_FM.indd 4
14/12/17 4:03 PM
Contents
Foreword to the 40th Anniversary Edition
Preface xxv
PART 1
¡ö
xvii
Getting Started
Chapter 1: Introduction
1
2
Chapter Objectives 2
The Importance of Databases in the Internet and Smartphone World 3
The Characteristics of Databases 5
A Note on Naming Conventions 7 ? A Database Has Data and Relationships 7
? Databases Create Information 9
Database Examples 10
Single-User Database Applications 10 ? Multiuser Database Applications 10 ? E-Commerce
Database Applications 11 ? Reporting and Data Mining Database Applications 11
The Components of a Database System 11
Database Applications and SQL 12 ? The DBMS 15 ? The Database 16
Personal Versus Enterprise-Class Database Systems 18
What Is Microsoft Access? 18 ? What Is an Enterprise-Class Database System? 19
Database Design 21
Database Design from Existing Data 21 ? Database Design for New Systems Development 23
? Database Redesign 23
What You Need to Learn 24
A Brief History of Database Processing 25
The Early Years 25 ? The Emergence and Dominance of the Relational Model 27
? Postrelational Developments 28
Summary 30 ? Key Terms 31 ? Review Questions 32 ? Exercises 34
Chapter 2: Introduction to Structured Query Language
38
Chapter Objectives 38
Cape Codd Outdoor Sports 39
Business Intelligence Systems and Data Warehouses 40
The Cape Codd Outdoor Sports Extracted Retail Sales Data Database 41 ? The RETAIL_
ORDER Table 44 ? The ORDER_ITEM Table 44 ? The SKU_DATA Table 45
? The BUYER Table 45 ? The CATALOG_SKU_20## Tables 46 ? The Complete Cape
Codd Data Extract Schema 46 ? Data Extracts Are Common 47
SQL Background 47
The SQL SELECT/FROM/WHERE Framework 49
Reading Specified Columns from a Single Table 49 ? Specifying Column Order in SQL Queries
from a Single Table 51
Submitting SQL Statements to the DBMS 52
Using SQL in Microsoft Access 2016 52 ? Using SQL in Microsoft SQL Server 2017 58
? Using SQL in Oracle Database 61 ? Using SQL in Oracle MySQL 5.7 63
v
A01_KROE2749_15_SE_FM.indd 5
14/12/17 4:03 PM
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- database concepts 6th edition pdf
- database concepts 8th edition pdf
- database concepts 7th edition pdf
- database concepts eighth edition pdf
- oracle database 10g express edition download
- the fifteenth amendment and its results
- history of the fifteenth amendment
- what did the fifteenth amendment provide apex
- oracle database 12c express edition download
- oracle database express edition 12c
- oracle database express edition 11g
- oracle database express edition download