Database Systems: Design, Implementation, & Management

12th Edition

Be the first to write a review

By: Steven Morris, Carlos Coronel

Hardcover

Published: 1st February 2016

In Stock. Ships from Australia today or next business day

RRP $139.95

$124.50

11%
OFF

or 4 easy payments of $31.13 with

Learn more

BUY NOW

Add to Wishlist

New Edition View Product

Hardcover
Published: 1st January 2018

Ships: 5 to 9 business days

5 to 9 business days

RRP $142.95

$127.25

11%
OFF

BUY NOW

Add to Wishlist

Description
Table of Contents
Product Details

Give students a solid foundation in database design and implementation with the practical and easy-to-understand approach in Database Systems: Design, Implementation, & Management, 12E. Filled with diagrams, illustrations, and tables, this market-leading text provides in-depth coverage of database design. Students learn the key to successful database implementation is the proper design of databases to fit within a larger strategic view of the data environment. This book combines a clear, straightforward writing style with an outstanding balance of theory and practice. Students gain the hands-on skills to make them attractive to employers. Updates include the latest coverage of cloud data services and a new chapter on Big Data Analytics and NoSQL, including related Hadoop technologies. In addition, new review questions, problem sets, and cases offer multiple opportunities for students to test their understanding and develop useful design skills.

New to this Edition

NEW MINDTAP® DIGITAL HOMEWORK SOLUTION OFFERS AN ONLINE, PERSONALIZED LEARNING EXPERIENCE. MindTap® combines learning tools -- such as readings, multimedia, activities, and assessments -- into a singular learning path that guides students through the course. You’ll find a full e-book as well as a robust set of auto-gradable homework problems. Multiple-choice homework questions confirm students’ understanding of core concepts and key terms. Higher-level assignments enable students to practice database design concepts in an automated environment and chapter quizzes help prepare for exams.

NEW CHAPTER FOCUSES ON BIG DATA ANALYTICS AND NOSQL. Students remain on the leading edge of database concepts as they become familiar with emerging tools, such as Big Data Analytics, which examines traditional and digital sources inside and outside of the company for ongoing discovery and analysis, and NoSQL databases, designed for fast storage and retrieval of data without strictly using the tabular structure of SQL databases.

ENHANCED COVERAGE ADDRESSES TODAY’S MOST COMMONLY USED DATABASE SYSTEMS. To provide students with a breadth of understanding of database design and programming across a range of DBMS products, this edition now introduces all of today’s most commonly used database systems, including Oracle®, MySQL™, SQL Server, and Microsoft® Access.

About the Authors

Carlos Coronel

Carlos Coronel is currently the Lab Director for the College of Business Computer Labs at Middle Tennessee State University. He has more than 29 years of experience in various fields as a Database Administrator, Network Administrator, Web Manager, and Technology Specialist. He has taught courses in Web development, database design and development, and data communications at the undergraduate and graduate levels.

Steven Morris

Steven Morris completed his Bachelor of Science and Ph.D. from Auburn University. He has taught courses in Database Design and Development, Database Programming with Advanced SQL and PL/SQL, Systems Analysis and Design, and Database Management at the graduate and undergraduate levels at Middle Tennessee State University. He has many years of experience consulting on a database projects across a broad range of industries. Dr. Morris has published numerous professional articles and has served on the review boards of several journals.

Part I: DATABASE CONCEPTS.

1. Database Systems.

2. Data Models.

Part II: DESIGN CONCEPTS.

3. The Relational Database Model.

4. Entity Relationship (ER) Modeling.

5. Advanced Data Modeling.

6. Normalization of Database Tables.

Part III: ADVANCED DESIGN AND IMPLEMENTATION.

7. Introduction to Structured Query Language (SQL).

8. Advanced SQL.

9. Database Design.

Part IV: ADVANCED DATABASE CONCEPTS.

10. Transaction Management and Concurrency Control.

11. Database Performance Tuning and Query Optimization.

12. Distributed Database Management Systems.

13. Business Intelligence and Data Warehouses.

14. Big Data Analytics and NoSQL

Part V: DATABASES AND THE INTERNET.

15. Database Connectivity and Web Technologies.

Part VI: DATABASE ADMINISTRATION.

16. Database Administration and Security.

ONLINE APPENDICES.

Appendix A: Designing Databases with Visio Professional: A Tutorial.

Appendix B: The University Lab: Conceptual Design.

Appendix C: The University Lab: Conceptual Design Verification, Logical Design, and Implementation.

Appendix D: Converting the ER Model into a Database Structure.

Appendix E: Comparison of ER Model Notations.

Appendix F: Client/Server Systems.

Appendix G: Object-Oriented Databases.

Appendix H: Unified Modeling Language (UML).

Appendix I: Databases in Electronic Commerce.

Appendix J: Web Database Development with ColdFusion.

Appendix K: The Hierarchical Database Model.

Appendix L: The Network Database Model.

Appendix M: Microsoft Access Tutorial.

Appendix N: Creating a New Database Using Oracle 12c.

Appendix O: Data Warehouse Implementation Factors

ISBN: 9781305627482
ISBN-10: 1305627482
Audience: Tertiary; University or College
Format: Hardcover
Language: English
Number Of Pages: 784
Published: 1st February 2016
Publisher: Cengage Learning, Inc
Country of Publication: US
Dimensions (cm): 27.31 x 21.59 x 3.81
Weight (kg): 1.86
Edition Number: 12
Edition Type: Revised