For undergraduate database management courses.
Getting straight to the point of database processing
Database Processing: Fundamentals, Design, and Implementation, 15th Edition, is a thorough and modern look at database processing fundamentals that’s designed to get readers straight to the point. This 40th anniversary edition has been refined and updated to reflect contemporary teaching and professional workplace environments and methods, address the latest software, and expand upon new and emerging developments in the database processing field – such as cloud computing and Big Data.
David M. Kroenke has more than 35 years’ experience in the computer industry. He began as a computer programmer for the U.S. Air Force, working both in Los Angeles and at the Pentagon, where he developed one of the world’s first DBMS products while part of a team that created a computer simulation of World War III. That simulation served a key role for strategic weapons studies during a 10-year period of the Cold War. Working independently, he also developed a new data modeling language called the semantic object model.
Kroenke has extensive experience in the business sector, and has held positions at Boeing Computer Services, Fred Brooks, Microsoft Corporation, and Logicon Corporation. From 1973 to 1978, he taught in the College of Business at Colorado State University, and published the 1st edition of Database Processing in 1977. He has worked as an editor and author developing texts, videos, and other educational products and seminars, and in 1982, was one of the founding directors of the Microrim Corporation.
Kroenke has continued consulting and writing. His current interests concern the practical applications of data mining techniques on large organizational databases. Kroenke is married, lives in Seattle, and has two grown children and three grandchildren.
David J. Auer has more than 30 years’ experience teaching college-level business and information systems courses, and for the past 20 years has worked professionally in the field of information technology. Auer is the coauthor of numerous textbooks, including five editions of Database Processing. From 1994-2017, he served as the Director of Information System and Technology Services at Western Washington University’s College of Business and Economics, and remains at the University as a Senior Instructor Emeritus as he continues his writing projects.
Auer is married, lives in Bellingham, Washington, and has two grown children and four grandchildren. He is active in his community, where he has been president of his neighborhood association and served on the City of Bellingham Planning and Development Commission. He enjoys music, playing acoustic and electric guitar, five-string banjo, and a
bit of mandolin.
Scott L. Vandenberg has over 25 years’ experience teaching computer science to college students in computer science and business programs. Before completing his PhD, he worked for brief periods at Standard Oil Research, Procter & Gamble headquarters, and IBM Research. He taught for two years at the University of Massachusetts-Amherst, before joining the faculty at Siena College in 1993. He has also published several papers relating to introductory computer science curricula and is currently a co-principal investigator on a multiyear NSF grant to develop methods to broaden participation and increase retention in computer science.
Vandenberg is married, lives in Averill Park, New York, and has two children. When not playing with databases, he enjoys playing ice hockey and studying medieval history.
Robert C. Yoder began his professional career at the University at Albany as a systems programmer managing Unisys and IBM mainframes, along with Unix servers. He became the Assistant Director of Systems Programming, gaining over 25 years’ experience as a programmer and technical manager. Bob took a two-year break from systems programming to work as a senior systems analyst at Phoenix Data Systems in Albany, New York, where he worked with a team to develop an innovative 3-D solid modeling system using a data structure called octree encoding that can represent the interior properties of objects. This work became the inspiration for his PhD dissertation on 3-D geographic information systems.
Bob and his wife live in Niskayuna, New York, with their two children. He enjoys traveling, hiking, and walking his dog. Bob would like to dedicate his portion of the textbook to the memory of loved ones who passed away recently: Dorothy Yoder, Laurie Gorski, and canine companion Robbie.
I. Getting Started
2. Introduction to Structured Query Language
II. Database Design
3. The Relational Model and Normalization
4. Database Design Using Normalization
5. Data Modeling with the Entity-Relationship Model
6. Transforming Data Models into Database Designs
III. Database Implementation
7. SQL for Database Construction and Application Processing
8. Database Redesign
IV. Multiuser Database Processing
9. Managing Multiuser Databases
10. Managing Databases with Microsoft SQL Server 2017, Oracle Database, and MySQL 5.7
Online 10A. Managing Databases with Microsoft SQL Server 2017
Online 10B. Managing Databases with Oracle Database
Online 10C. Managing Databases with MySQL 5.7
V. Database Access Standards
11. The Web Server Environment
12. Data Warehouses, Business Intelligence Systems, and Big Data
Appendix A. Getting Started with Microsoft Access 2016
Appendix B. Getting Started with Systems Analysis and Design
Appendix C. E-R Diagrams and the IDEF1X and UML Standards
Appendix D. Getting Started with Microsoft Visio 2016
Appendix E. Getting Started with the MySQL Workbench Data Modeling Tools
Appendix F. The Semantic Object Model
Appendix G. Physical Database Design and Data Structures for Database Processing
Appendix H. Getting Started with Web Servers, PHP, and the NetBeans IDE
Appendix I. XML
Appendix J. Business Intelligence Systems
Appendix K. Big Data
Appendix L. JSON and Document Databases