Database Concepts

• Main Author: Kroenke, David M. (Author)
• Format: Book
• Language: English
• Published: Upper Saddle River, NJ Pearson Education 2005; ©2003
• Edition: Second Edition
• Subjects: Database management; Relational databases
• Online Access: Click Here to View Status and Holdings.
• Physical Description: xv, 237 pages color illustrations 28 cm
• Bibliography: Includes bibliographical references and index
• ISBN: 0131451413

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