Loading...

Concepts of Database Management,
10th Edition

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

ISBN-13: 9780357422083 | ISBN-10: 0357422082

Copyright 2021

| Published 2020

| 432 pages

List Price USD $149.95

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.

Read More

Meet the Authors

Show More Show Less

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.

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.

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.

  • 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 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.

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.

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.

Instructor's Companion Website for Friedrichsen/Ruffolo/Monk/Starks/Pratt/Last's Concepts of Database Management

ISBN13:9780357422182
ISBN10:035742218X
Everything you need for your course in one place! This collection of product-specific lecture and class tools is available online via the instructor resource center at www.cengage.com/login. You'll be able to access and download materials such as PowerPoint presentations, images, instructor's manual, videos and more.

Cengage Testing, powered by Cognero® for Friedrichsen/Ruffolo/Monk/Starks/Pratt/Last's Concepts of Database Management, Instant Access

ISBN13:9780357422175
ISBN10:0357422171
Cengage Learning Testing, powered by Cognero® is a flexible, online system that allows you to import, edit and manipulate content from the texts test bank or elsewhere, including your own favorite test questions; create multiple test versions in an instant; and deliver tests from your LMS, your classroom or wherever you want.

Cengage Testing, powered by Cognero® for Friedrichsen/Ruffolo/Monk/Starks/Pratt/Last's Concepts of Database Management

ISBN13:9780357422168
ISBN10:0357422163

Compare Buying Options

Show More Show Less

Pricing Options

Concepts of Database Management

  • ISBN-10: 0357422082
  • ISBN-13: 9780357422083

Price USD$ 149.95

eBook: Concepts of Database Management 12Months

  • ISBN-10: 8000030357
  • ISBN-13: 9788000030357

Price USD$ 54.49

Buy

*Purchase not available for this country