Request for consultation

Thanks for your request. You’ll soon be chatting with a consultant to get the answers you need.
Your form is submitting...
{{formPostErrorMessage.message}} [{{formPostErrorMessage.code}}]
Email Address is required. 'Email Address' must contain at least 0 characters 'Email Address' cannot exceed 0 characters Please enter a valid Email Address
First Name is required. 'First Name' must contain at least 0 characters 'First Name' cannot exceed 0 characters Please enter a valid First Name
Last Name is required. 'Last Name' must contain at least 0 characters 'Last Name' cannot exceed 0 characters Please enter a valid Last Name
Institution is required.
Discipline is required.
Cengage, at your service! How can we best meet your needs? is required.
Why are you contacting us today? is required. 'Why are you contacting us today?' must contain at least 0 characters 'Why are you contacting us today?' cannot exceed 0 characters Please enter a valid Why are you contacting us today?

Concepts of Database Management, 10th Edition

Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt, Mary Z. Last

  • Copyright 2021
  • {{checkPublicationMessage('Published', '2020-03-04T00:00:00+0000')}}
Starting At $77.95 See pricing and ISBN options
Instructor Next Steps
Students: Buy now
Concepts of Database Management 10th Edition by Lisa Friedrichsen/Lisa Ruffolo/Ellen Monk/Joy L. Starks/Philip J. Pratt/Mary Z. Last
Quick Navigation

Overview

Thoroughly introduce today's critical database issues with the applied approach in Friedrichsen/Ruffolo/Monk/Starks/Pratt's CONCEPTS OF DATABASE MANAGEMENT, 10th Edition. This hands-on presentation integrates real cases, practical examples and helpful screenshots to clarify concepts such as database design, data integrity, normalization, concurrent updates, data security and big data. Completely updated to reflect Microsoft® Access 2019, Office 365 standards and SQL Server 2019, this edition explores SQL in a database-neutral environment. Detailed coverage presents the relational model (including QBE and SQL), normalization and views, database administration and management. Students also examine advanced topics, such as distributed databases, data warehouses, stored procedures, triggers, data macros and Web Apps, within a presentation ideal for a variety of disciplines. The completely redesigned MindTap resources also leverage Access 2019 Training and Projects in SAM for extensive practice in Access with auto-grading and instant feedback.

{{readMore['overview'] ? 'Read More' : 'Read Less'}}

Meet the Authors

{{collapseContainerClosed['meet-the-author'] ? 'Show More' : 'Show Less'}}

Lisa Friedrichsen

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

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 Monk

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 L. Starks

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

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

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.

What's New

{{collapseContainerClosed['whats-new'] ? 'Show More' : 'Show Less'}}
  • BRAND-NEW JC CONSULTING AND PITT FITNESS CASES INTRODUCE READERS TO NUMEROUS DATABASE-RELATED ACTIVITIES. Students work with databases for a contemporary technology consulting firm and fitness company. In addition, this edition's Sports Physical Therapy case now offers updated exercise questions and fresh activities. These three databases and ongoing case exercises provide learners with practice that equips them for success in actual careers.
  • UPDATED END-OF-CHAPTER QUESTIONS SCAFFOLD LEARNING WITH A VARIETY OF QUESTIONS TYPES. Multiple-choice review questions within module quizzes enable learners to check their understanding immediately. These module quizzes are auto-graded within MindTap. Open-response critical-thinking questions also encourage learners to integrate concepts across the module. In addition, multiple-choice case questions test the students' understanding of defined database manipulation activities, while critical-thinking case questions prompt learners to perform complex activities using Microsoft® Access.
  • COMPLETELY REDESIGNED MINDTAP DIGITAL RESOURCES GIVE YOU AND YOUR STUDENTS TIMELY FEEDBACK ON PROGRESS THROUGHOUT THE COURSE. Interactive Microsoft® Access training and projects, a new module quiz, and multiple-choice case questions provide insight into student performance. Step-by-step practice and remediation opportunities ensure a deep understanding of the material.
  • NEW SAM TRAINING AND PROJECTS IN MICROSOFT® ACCESS 2019 BUILD STUDENTS’ DATABASE MANAGEMENT SKILLS. These hands-on activities increase students' proficiency while providing remediation and feedback to help them continually improve.
  • NEW CAREER VIDEOS INTRODUCE VARIOUS DATABASE MANAGEMENT-RELATED CAREER PATHS. These engaging new videos guide learners as they consider database career paths. The videos highlight required skills and direct viewers in how to best prepare for today's and tomorrow's job markets.

Features

{{collapseContainerClosed['features'] ? 'Show More' : 'Show Less'}}
  • REVISED, HANDS-ON APPROACH WITH A CLEAR PRESENTATION INTRODUCES KEY DATABASE MANAGEMENT CONCEPTS FOR ANY LEARNER. This practical, hands-on guide is revised to reflect the latest developments and key concepts driving databases management today. The authors use a clear, concise narrative style with interactive features that encourage learners to apply new concepts. Screenshots and clear headings throughout this edition help learners easily reference relevant material while tackling case studies in Microsoft® Access.
  • COMPLETELY UPDATED CONTENT INCORPORATES THE LATEST MICROSOFT® ACCESS 2019, OFFICE 365 STANDARDS AND SQL SERVER 2019. Students work with your choice of the latest database management tools and applications. The full-color presentation offers helpful Microsoft® Office screenshots to further guide learning.
  • NUMEROUS, PROVEN LEARNING FEATURES CLARIFY CONTENT AND ENCOURAGE HANDS-ON MASTERY OF CONCEPTS. This edition's Q+A feature boxes address common database questions. In addition, Your Turn features encourage learners to manipulate the JC Consulting (ongoing case study) database, which reinforces content as the students advance through the material. Features are designed to provide an interactive reading experience that leads to mastery.
  • UNIQUE, REDESIGNED MINDTAP OFFERS AN OUTCOME-DRIVEN APPLICATION WITH STEP-BY-STEP PRACTICE THAT PROPELS STUDENTS FROM MEMORIZATION TO MASTERY. MindTap is the only platform that gives you complete ownership of your course. With it you can challenge students, build their confidence and empower them to be unstoppable.
  • HELPFUL APPENDICES PROVIDE ADDITIONAL INSIGHTS AND DETAILS. Appendices describe the purpose and syntax of the major SQL commands that this edition uses. The appendices also include Access Web Apps, Introduction to MySQL and a Systems Analysis Approach to Information-Level Requirements.
  • INSTRUCTOR'S MANUAL DETAILS HOW TO EFFECTIVELY INTEGRATE THIS BOOK WITH OTHER TITLES. Helpful insights and useful tips demonstrate how to seamlessly integrate this Ninth Edition with other books from Cengage that cover Microsoft® Access 2016 and SQL, if desired.

Table of Contents

{{collapseContainerClosed['table-of-contents'] ? 'Show More' : 'Show Less'}}
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.

Compare Buying Options

{{collapseContainerClosed['compare-buying-options'] ? 'Show More' : 'Show Less'}}

MindTap Options

{{collapseContainerClosed['detail_1'] ? 'Show More' : 'Show Less'}}
MindTap
Each MindTap product offers the full, mobile-ready textbook combined with superior and proven learning tools at one affordable price. Students who purchase digital access can add a print option at any time when a print option is available for their course.

This Cengage solution can be seamlessly integrated into most Learning Management Systems (Blackboard, Brightspace by D2L, Canvas, Moodle, and more) but does require a different ISBN for access codes. Please work with your Cengage Learning Consultant to ensure the proper course set up and ordering information. For additional information, please visit the LMS Integration site.

Standalone Digital Access — Ultimate Value

Recommended and most popular

  • ISBN-10: 0357422139
  • ISBN-13: 9780357422137
  • RETAIL $129.95

  • ISBN-10: 0357422112
  • ISBN-13: 9780357422113
  • RETAIL $129.95
Instructor Next Steps
Students: Buy now

Textbook Only Options

Traditional eBook and Print Options

{{collapseContainerClosed['detail_0'] ? 'Show More' : 'Show Less'}}

  • ISBN-10: 035770617X
  • ISBN-13: 9780357706176
  • RETAIL $77.95

  • ISBN-10: 0357422082
  • ISBN-13: 9780357422083
  • RETAIL $239.95

  • ISBN-10: 0357399080
  • ISBN-13: 9780357399088
  • RETAIL $269.95
Instructor Next Steps
Students: Buy now

Supplements

{{collapseContainerClosed['supplements'] ? 'Show More' : 'Show Less'}}

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

FOR STUDENTS

MindTap for Friedrichsen/Ruffolo/Monk/Starks/Pratt/Last's Concepts of Database Management, 2 terms Instant Access

ISBN: 9780357422137
MindTap for Concepts of Database Management, 10th Edition is the digital learning solution that powers students from memorization to mastery. It gives you complete control of your course--to provide engaging content, to challenge every individual, and to build their confidence. Empower students to accelerate their progress with MindTap. MindTap: Powered by You. MindTap gives you complete ownership of your content and learning experience. Customize the interactive syllabi, emphasize the most important topics, and add your own material or notes in the ebook. The new Concepts of Database Management, 10th Edition MindTap is redesigned to give you and your students timely feedback on their progress in the course. Interactive Microsoft® Access training and projects, a new module quiz, and multiple-choice case questions provide insight into student performance and remediation to contribute to a deep understanding of the material.

MindTap for Friedrichsen/Ruffolo/Monk/Starks/Pratt/Last's Concepts of Database Management, 1 term Instant Access

ISBN: 9780357422113
MindTap for Concepts of Database Management, 10th Edition is the digital learning solution that powers students from memorization to mastery. It gives you complete control of your course--to provide engaging content, to challenge every individual, and to build their confidence. Empower students to accelerate their progress with MindTap. MindTap: Powered by You. MindTap gives you complete ownership of your content and learning experience. Customize the interactive syllabi, emphasize the most important topics, and add your own material or notes in the ebook. The new Concepts of Database Management, 10th Edition MindTap is redesigned to give you and your students timely feedback on their progress in the course. Interactive Microsoft® Access training and projects, a new module quiz, and multiple-choice case questions provide insight into student performance and remediation to contribute to a deep understanding of the material.