Concepts of Database Management

by Joy L. Starks, Philip J. Pratt, Mary Z. Last

Overview

Gain a thorough, applied understanding of critical database issues with Starks/Pratt/Last's CONCEPTS OF DATABASE MANAGEMENT, 9E. Real cases, examples and screenshots in this concise presentation help clarify database design, data integrity, normalization, concurrent updates, data security, and big data. Completely updated to SQL Server 2016, Microsoft Access 2016, and Office 365 standards, this edition explores SQL in a database-neutral environment while addressing E-R diagrams, normalization, and database design. Detailed coverage presents the relational model (including QBE and SQL), normalization and views, database administration and management. You also examine advanced topics such as distributed databases, data warehouses, stored procedures, triggers, data macros and Web Apps. This introduction to database is ideal for mastering today's database techniques.

Product Details

ISBN-13:	9781337093422
Publisher:	Cengage Learning
Publication date:	01/18/2018
Edition description:	Older Edition
Pages:	432
Product dimensions:	8.40(w) x 10.80(h) x 0.80(d)

About the Author

Joy Starks has taught at Indiana University Purdue University Indianapolis for 20 years. She has written chapters in several of the best-selling Shelly Cashman Series Office books and has authored the Photoshop, Java Programming, and Microsoft Publisher series of books. She speaks and presents at various conferences, seminars and forums across the U.S.

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: MySQL. Appendix D: "How Do I" Reference. Appendix E: Using Access to Create a Web App. Appendix F: A Systems Analysis Approach to Information-Level Requirements.