Concepts of Database Management

by Philip J. Pratt, Mary Z. Last

Overview

Delivering concise, cutting-edge coverage, CONCEPTS OF DATABASE MANAGEMENT, 8e uses real-world cases, examples, and illustrations to give readers a thorough understanding of such critical issues as database design, data integrity, concurrent updates, data security, and more. Completely updated to Microsoft Access 2013 standards, the text presents SQL in a database-neutral environment and covers all major topics, including E-R diagrams, normalization, and database design. It provides detailed coverage of the relational model (including QBE and SQL), normalization and views, database administration and management, and more. Advanced topics include distributed databases, data warehouses, stored procedures, triggers, data macros, and Web databases.

Product Details

ISBN-13:	9781285427102
Publisher:	Cengage Learning
Publication date:	09/08/2014
Edition description:	Older Edition
Pages:	432
Product dimensions:	8.40(w) x 10.80(h) x 0.80(d)

About the Author

Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis and discrete mathematics. He has authored more than 75 textbooks and has co-authored three levels of Microsoft Office Access books for the popular Shelly Cashman Series, in addition to the popular A GUIDE TO SQL.

Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an associate professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992. She also authors many instructor resources for leading database texts.

Table of Contents

1. Introduction to Database Management. 2. The Relational Model 1: Introduction, QBE, and Relational Algebra. 3. The Relational Model 2: SQL. 4. The Relational Model 3: Advanced Topics. 5. Database Design 1: Normalization. 6. Database Design 2: Design Method. 7. DBMS Functions. 8. Database Administration. 9. Database Management Approaches. Appendix A: Comprehensive Design Example: Marvel College. Appendix B: SQL Reference. Appendix C: "How Do I" Reference. Appendix D: Answers to Odd-Numbered Review Questions. Appendix E: Access Web Apps. Appendix F: Systems Analysis Approach to Information-Level Requirements.