Concepts of Database Management,
9th Edition

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.

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

• THIS EDITION OFFERS THE MOST COMPLETE AND CURRENT COVERAGE AVAILABLE IN A CONCISE PRESENTATION. The new edition is easy for students to read and understand. Revisions in every chapter highlight the latest technologies, practices, and developments from the field.

• NEW "YOUR TURN" EXERCISES ENCOURAGE STUDENTS TO APPLY THE SKILLS THEY'VE LEARNED. These new, practical exercises in each chapter engage the student in thinking critically and analytically about specific, common problems.

• COMPLETELY UPDATED CONTENT INCORPORATES SQL SERVER 2016, MICROSOFT® ACCESS 2016, AND OFFICE 365 STANDARDS. This edition's new full color presentation offers helpful Microsoft® Office screenshots to further guide learning.

• AUTHORS SKILLFULLY PRESENT COMPREHENSIVE AND CURRENT COVERAGE OF DATABASE DESIGN AND DATABASE MANAGEMENT SYSTEMS. Your students gain the tools and skill sets they need for real-world success.

• INTERESTING, CONTEMPORARY CASES APPEAL TO COLLEGE-AGE STUDENTS. A new continuing case problem appears in each chapter throughout the book. In addition, the authors have added a new case to each chapter's end-of-chapter set of exercises and cases.

• CRITICAL-THINKING QUESTIONS AND EXERCISES NOW ACCOMPANY EACH CASE. These new questions and exercises that appear in every case challenge students to apply and strengthen their problem-solving and analytical skills. In addition, the authors have updated all exercises to reflect the latest developments in the field.

• THOROUGH, YET SUCCINCT, PRESENTATION CLEARLY DISCUSSES DATABASE DESIGN. Students study key topics, including normalization, an easy, applied database design method, E-R diagrams, numerous database design examples, requirements gathering and analysis and trade-off discussions.

• EXTENSIVE COVERAGE OF SQL OFFERS NUMEROUS EXAMPLES TO ILLUSTRATE CONCEPTS EFFECTIVELY. Students also explore advanced topics, such as concurrency issues, distributed databases, data warehouses, stored procedures, triggers, XML, big data and database processing over the Web.

• ALL-NEW COMMON CASE PROBLEMS IN EACH CHAPTER REINFORCE KEY CONCEPTS. Problems challenge students to apply what they've learned with real-world practice. The authors have designed contemporary cases to specifically appeal to today's college students. Two additional case problems appear in the exercises at the end of each chapter. This edition's critical-thinking questions and exercises challenge students to use problem-solving and analytical skills.

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

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.

Cengage Testing, powered by Cognero® for Pratt/Adamski's Concepts of Database Management
9781337900027

Cengage Testing, powered by Cognero® for Pratt/Adamski's Concepts of Database Management, Instant Access
9781337900034

Instructor's Companion Website for Pratt/Adamski's Concepts of Database Management
9781337093446

VitalSource eBook: Concepts of Database Management 12 Months
9788000012568

MindTap: Concepts of Database Management 12 Months
9781337674805