Concepts of Database Management / Edition 10

by Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Overview

Strengthen your understanding of database management today with the thorough, hands-on presentation found in CONCEPTS OF DATABASE MANAGEMENT, 10th Edition. Real cases, practical examples, helpful screenshots and concise explanations help clarify concepts, such as database design, data integrity, normalization, concurrent updates, data security and big data. Completely updated content reflects Microsoft Access 2019, Office 365 standards and SQL Server 2019, while exploring SQL in a database-neutral environment. Detailed coverage presents the relational model (including QBE and SQL), normalization and views as well as database administration and management. You also examine advanced topics, such as distributed databases, data warehouses, stored procedures, triggers, data macros and Web Apps. Completely redesigned MindTap digital resources provide step-by-step practice using Access 2019 with instant feedback. Trust this contemporary introduction to help you master today's database techniques to advance your career in any field.

Product Details

ISBN-13:	9780357422083
Publisher:	Cengage Learning
Publication date:	03/04/2020
Series:	MindTap Course List
Edition description:	10th ed.
Pages:	432
Product dimensions:	8.50(w) x 10.80(h) x 0.70(d)

About the Author

Lisa Friedrichsen is a professor at Johnson County Community College in Overland Park, Kansas, where she teaches database and web development classes. She also has written several prominent Access, Office and web-related textbooks. Friedrichsen spent a decade at IBM Corp. before becoming a consultant, author and college professor. Combining her extensive industry experience with her passion for teaching, she creates clear, practical presentations. She earned a B.S. in engineering from Iowa State University and an MBA from Drake University.

Lisa Ruffolo has served as a technical writer and editor for more than 30 years. She is pursuing an emphasis in operating systems and digital literacy. She has edited top-selling books in the fields of introduction to computing, Microsoft Office, PC repair and computer programming.

Ellen F. Monk is an Assistant Professor of Management Information Systems in the Lerner College of Business and Economics at the University of Delaware. Her areas of interest encompass enterprise resource planning systems and undergraduate MIS education, including databases, advanced spreadsheets and data analytics. Dr. Monk holds a B.S. in chemical engineering, an M.B.A., and a Ph.D. in MIS.

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.

Table of Contents

1. Introduction to Database Management. 2. The Relational Model: Introduction, QBE, and Relational Algebra. 3. The Relational Model: SQL. 4. The Relational Model: Advanced Topics. 5. Database Design: Normalization. 6. Database Design: Relationships. 7. Database Management Systems Processes and Services. 8. Database Industry Careers. 9. Database Industry Trends. Appendix A: Comprehensive Design Example: Douglas College. Appendix B: SQL Reference. Appendix C: FAQ Reference. Appendix D: Introduction to MySQL. Appendix E: A Systems Analysis Approach to Information-Level Requirements.