Appropriate for all introductory courses on database development and management, as well as database courses designed around specific database products such as Microsoft Access, SQL Server, or MySQL.
In this book, one of the world’s leading database experts introduces the essential concepts that students need to create and use working databases. Simply and accurately, David Kroenke introduces essential database concepts through three running projects that students can follow for themselves using virtually any contemporary database software. Kroenke begins by explaining why databases are used, how they improve on alternatives such as spreadsheets, what their components are, and how they are developed. Next, he introduces the relational model and defines basic relational terminology. This edition contains a thoroughly revamped discussion of normalization, including a new four-step process that makes it far easier to understand and perform. Kroenke then introduces the basics of SQL, introducing statements for data definition and modification, as well as SQL SELECT statements. Next, he turns to database design and management, including the entity-relationship (E-R) model and basic data modeling. The book contains a full chapter on administration, including concurrency control, security, and backup/recovery. Students will also find practical introductions to several key database trends, including Web and XML databases, distributed databases, OLAP, data mining, and object-relational DBMSes. Every chapter concludes with review questions and exercises. Finally, the book's Appendix introduces Microsoft Access and shows how it can be used to create simple databases.
David M. Kroenke is one of the pioneers of database technology In 1971, while working at the Pentagon, he programmed one of the world's first database management system (DBMS) products. In 1974 Grace Hopper appointed him to the CODAYSL EUF committee, and in 1977 he worked as ,a consultant for Fred Brooks at IBM. Kroenke helped to start the Microrim Corporation, where he led the development of the R:base family of DBMS products. In a 1991 article, Wayne Ratliff credited one of Kroenke's textbooks for giving him the idea for the development of d:base. In 1989 Kroenke consulted Microsoft on the project that led to the development of Microsoft Access. He is also the father of the semantic object model, a data model that many believe is superior to the entity-relationship model.
Kroenke is the author of five computer textbooks; his text Database Processing was first published in 1977 and is currently in its eighth edition. In 1990 and 1991 he was the Hanson Professor of Management Science at the University of Washington. In that same year the International Association for Computer Information Systems named him Computer Educator of the Year. He holds a B.S. in economics from the U.S. Air Force Academy, an M.S. in management science from the University of Southern California, and a Ph.D. from Colorado State University where he studied linear models under Franklin Graybill.
