Database Concepts

Front Cover
Pearson/Prentice Hall, 2004 - Business & Economics - 237 pages
1 Review
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 worlds 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.

What people are saying - Write a review

Review: Database Concepts

User Review  - Sarah - Goodreads

Very clear and easy to read. I think the authors struck the right balance between hand-holding through the examples and letting you explore on your own. Read full review

About the author (2004)

David Kroenke has been a sailor since 1971 and currently owns a Mason 44. He has cruised the West Coast extensively, roamed the Inside Passage and the coast of British Columbia, and sailed to Mexico and back. His next Big Trip is a voyage to the Marquesas. Although he holds a Ph.D. in engineering, he claims his chief qualification for writing "Know Your Boat" is the self-education process he undertook after spending piles of money in boatyards.

Bibliographic information