Database Processing: Fundamentals, Design, and Implementation

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 students 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.

• I. Getting Started
• 1. Introduction
• 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

David worked for the US Air Force and Boeing Computer Services. He was a principal in the startup of three companies, serving as the vice president of product marketing and development for the Microrim Corporation and as chief of database technologies for Wall Data, Inc. He is the father of the semantic object data model. David's consulting clients have included IBM, Microsoft, and Computer Sciences Corporations, as well as numerous smaller companies. Recently, David has focused on using information systems for teaching collaboration and teamwork.

David J. Auer is a senior instructor emeritus at the College of Business (CBE) of Western Washington University in Bellingham, WA. He served as Director of Information Systems and Technology Services at CBE from 1994 to 2014 and taught in CBE's Department of Decision Sciences from 1981 to 2015. Auer has taught CBE courses in quantitative methods, production and operations management, statistics, finance, and management information systems. Besides managing CBE's computer, network, and other technology resources, he also teaches management information systems courses. He has taught the principles of management information systems and business database development courses, and he was responsible for developing CBE's network infrastructure courses, including Computer Hardware and Operating Systems, Telecommunications, and Network Administration.

He holds a bachelor's degree in English literature from the University of Washington, and three degrees from Western Washington University - a bachelor's degree in mathematics and economics, a master's degree in economics, and a master's degree in counselling psychology. He served as a commissioned officer in the US Air Force, and he has also worked as an organisational development specialist and therapist for an employee assistance program (EAP).

Scott L. Vandenberg has been on the Computer Science faculty at Siena College since 1993, where he regularly teaches three different database courses at several levels to both computer science and business majors. Prior to arriving at Siena, he taught undergraduate and graduate courses in database systems at the University of Massachusetts-Amherst. Since arriving at Siena, he has also taught graduate and undergraduate database courses at the University of Washington-Seattle. He has developed five different database courses over this time. His other teaching experience includes courses in introductory computer science, introductory programming, data structures, and management information systems, as well as three years teaching Siena's required interdisciplinary freshman writing course.

Vandenberg's recent research publications are mainly in the areas of computer science education and data science applications, with earlier work on query optimisation and algebraic query languages. He holds a bachelor's degree in mathematics and computer science from Cornell University and a master's degree and a PhD in computer science from the University of Wisconsin-Madison.

Robert C. Yoder began his professional career at the University at Albany as a systems programmer managing mainframes and Unix servers. He has two years of research experience working on 3-D solid modeling systems. Robert holds BS and MS degrees in computer science and a PhD in information science, all from the University at Albany. Yoder joined the Computer Science department at Siena College in 2001 and teaches business database, management information systems, geographic information systems, data structures, networks, and operating systems courses.