Concepts of Database Management 8th Edition Solutions Pdf

Concepts of Database Management, 8th Edition

Published: © 2015

Print ISBN: 9781285427102

Pages: 432

Available

Delivering concise, cutting-edge coverage, CONCEPTS OF DATABASE MANAGEMENT, 8e uses real-world cases, examples, and illustrations to give students a thorough understanding of such critical issues as database design, data integrity, concurrent updates, data security, and more. Completely updated to Microsoft Access 2013 standards, the text presents SQL in a database-neutral environment and covers all major topics, including E-R diagrams, normalization,… More

For Instructors

For Students

• Table of Contents

• New to this edition

• Features

• About the author(s)

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: "How Do I" Reference.
Appendix D: Answers to Odd-Numbered Review Questions.
Appendix E: Access Web Apps.
Appendix F: Systems Analysis Approach to Information-Level Requirements.

• Offering the most current coverage available, the new CONCEPTS OF DATABASE MANAGEMENT, 8e is packed with the latest technologies, practices, and developments from the field.
• The Eighth Edition is completely updated to Microsoft Access 2013 standards.
• Comprehensive, current coverage of database design and database management systems provides readers with the tools they need for real-world success.
• A new continuing case problem appears in each chapter throughout the book.

• Thorough yet succinct, CONCEPTS OF DATABASE MANAGEMENT delivers clear, comprehensive discussions of database design that include normalization, an easily applied database design method, E-R diagrams, numerous database design examples, requirements gathering and analysis, trade-off discussions, and more.
• Extensive coverage of SQL offers numerous examples to effectively illustrate concepts and includes such advanced topics as concurrency issues, distributed databases, data warehouses, stored procedures, triggers, XML, and database processing over the Web.
• A common case problem in each chapter reinforces key concepts as it challenges students to put what they learn into real-world practice. Two additional case problems are presented in the exercises at the end of each chapter. Critical thinking questions and exercises challenge students to use problem-solving and analytical skills.
• Providing students with additional insight, appendices describe the purpose and syntax of the major SQL commands used in the book. Appendices include Access Web Apps and a Systems Analysis Approach to Information-Level Requirements.
• The Instructor's Manual offers detailed tips on integrating the Eighth Edition with other books from Course Technology that cover Microsoft Access 2013 and SQL.

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.

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: "How Do I" Reference.
Appendix D: Answers to Odd-Numbered Review Questions.
Appendix E: Access Web Apps.
Appendix F: Systems Analysis Approach to Information-Level Requirements.

New to this edition

• Offering the most current coverage available, the new CONCEPTS OF DATABASE MANAGEMENT, 8e is packed with the latest technologies, practices, and developments from the field.
• The Eighth Edition is completely updated to Microsoft Access 2013 standards.
• Comprehensive, current coverage of database design and database management systems provides readers with the tools they need for real-world success.
• A new continuing case problem appears in each chapter throughout the book.

Features

• Thorough yet succinct, CONCEPTS OF DATABASE MANAGEMENT delivers clear, comprehensive discussions of database design that include normalization, an easily applied database design method, E-R diagrams, numerous database design examples, requirements gathering and analysis, trade-off discussions, and more.
• Extensive coverage of SQL offers numerous examples to effectively illustrate concepts and includes such advanced topics as concurrency issues, distributed databases, data warehouses, stored procedures, triggers, XML, and database processing over the Web.
• A common case problem in each chapter reinforces key concepts as it challenges students to put what they learn into real-world practice. Two additional case problems are presented in the exercises at the end of each chapter. Critical thinking questions and exercises challenge students to use problem-solving and analytical skills.
• Providing students with additional insight, appendices describe the purpose and syntax of the major SQL commands used in the book. Appendices include Access Web Apps and a Systems Analysis Approach to Information-Level Requirements.
• The Instructor's Manual offers detailed tips on integrating the Eighth Edition with other books from Course Technology that cover Microsoft Access 2013 and SQL.

About the author(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.

Related Titles

Concepts of Database Management 8th Edition Solutions Pdf

Source: https://www.cengage.co.uk/books/9781285427102

Share this post