Fundamentals of Database Systems, 7th edition
- Ramez Elmasri
- , Shamkant B. Navathe
Learn more, spend less
- Listen on the go
Learn how you like with full eTextbook audio
- Find it fast
Quickly navigate your eTextbook with search
- Stay organized
Access all your eTextbooks in one place
- Easily continue access
Keep learning with auto-renew
Fundamentals of Database Systems introduces the fundamental concepts necessary for designing, using and implementing database systems and database applications. Emphasis is placed on the fundamentals of database modeling and design, the languages and models provided by the database management systems, and database system implementation techniques. The book is meant to be used as a textbook for a one- or two-semester course in database systems at the junior, senior, or graduate level, and as a reference book. The goal is to provide an in-depth and up-to-date presentation of the most important aspects of database systems and applications, and related technologies. It is assumed that readers are familiar with elementary programming and data-structuring concepts and that you have had some exposure to the basics of computer organization.
The 7th Edition has been updated to reflect recent concepts and technology, including 2 new chapters and more real-world problems.
Published by Pearson (July 14th 2021) - Copyright © 2016
ISBN-13: 9780137502523
Subject: Database
Category: Database Systems
Brief Contents
Part 1: Introduction to Databases
- Chapter 1: Databases and Database Users
- Chapter 2: Database Systems Concepts and Architecture
Part 2: Conceptual Data Modeling and Database Design
- Chapter 3: Data Modeling Using the Entity Relationship (ER) Model
- Chapter 4: The Enhanced Entity Relationship (EER) Model
Part 3: The Relational Data Model and SQL
- Chapter 5: The Relational Data Model and Relational Database Constraints
- Chapter 6: Basic SQL
- Chapter 7: More SQL: Complex Queries, Triggers, Views, and Schema Modification
- Chapter 8: The Relational Algebra and Relational Calculus
- Chapter 9: Relational Database Design by ER- and EER-to-Relational Mapping
Part 4: Database Programming Techniques
- Chapter 10: Introduction to SQL Programming Techniques
- Chapter 11: Web Database Programming Using PHP
Part 5: Object, Object-Relational, and XML: Concepts, Models, Languages, and Standards
- Chapter 12: Object and Object-Relational Databases
- Chapter 13: XLM: Extensible Markup Language
Part 6: Database Design Theory and Normalization
- Chapter 14: Basics of Functional Dependencies and Normalization for Relational Databases
- Chapter 15: Relational Database Design Algorithms and Further Dependencies
Part 7: File Structures, Hashing, Indexing, and Physical Database Design
- Chapter 16: Disc Storage, Basic File Structures, Hashing, and Modern Storage Architectures
- Chapter 17: Indexing Structures for Files and Physical Database Design
Part 8: Query Processing and Optimization
- Chapter 18: Strategies for Query Processing
- Chapter 19: Query Optimization
Part 9: Transaction Processing, Concurrency Control, and Recovering
- Chapter 20: Introduction to Transaction Processing Concepts and Theory
- Chapter 21: Concurrency Control Techniques
- Chapter 22: Database Recovery Techniques
Part 10: Distributed Databases, NOSQL Systems, Cloud Computing, and Big Data
- Chapter 23: Distributed Database Concepts
- Chapter 24: NOSQL Databases and Big Data Storage Systems
- Chapter 25: Big Data Technologies Based on MapReduce and Hadoop
Part 11: Advanced Database Models, Systems, and Applications
- Chapter 26: Enhanced Data Models: Introduction to Active, Temporal, Spatial, Multimedia, and Deductive Databases
- Chapter 27: Introduction to Information Retrieval and Web Search
- Chapter 28: Data Mining Concepts
- Chapter 29: Overview of Data Warehousing and OLAP
Part 12: Additional Database Topics: Security
- Chapter 30: Database Security
Appendix A: Alternative Diagrammatic Notations for ER Models
Appendix B: Parameters of Disks
Appendix C: Overview of the QBE Language
Appendix D: Overview of the Hierarchical Data Model
Appendix E: Overview of the Network Data Model
Your questions answered
Pearson+ is a one-stop shop for eTextbooks and Study & Exam Prep (also referred to as Channels), both designed to help students get better grades in college. eTextbooks and Study & Exam Prep can be purchased separately or together. eTextbooks have built-in tools that simplify studying, like flashcards, audiobook and search. Study & Exam Prep includes video lessons, practice problems, study guides, Q&A with experts and more, to help you understand tricky topics and get you prepared for test time — all in one place.
A Pearson eTextbook is an easy-to-use digital version of your assigned textbook. eTextbooks, available in Pearson+, give you access to upgraded study tools, including enhanced search, highlights and notes, customizable flashcards, and audio options for hand-free studying. Plus, you can learn on the go with the Pearson+ app.
Pearson+ offers an eTextbook rental, billed as a 6-month subscription. A subscription includes instant access to your eTextbook, including study tools such as the ability to create custom flash cards, take notes, and the option to search and highlight important info in your eTextbook. You can also bundle your eTextbook with Study & Exam Prep. When you check out, you can make a one-time, up-front payment for your eTextbook, or you can choose to pay monthly. If you opt for monthly payments, we will charge your payment method each month until your 6-month subscription ends. If something happens and you need your eTextbook for longer than 6 months, select Extend subscription on the Manage subscription page in My account at any time to continue your subscription before it ends.
A Study & Exam Prep subscription includes video lessons, practice problems and other study tools. With a subscription, you'll get unlimited access to the full range of subjects:
When you purchase an eTextbook subscription, it will last 6 months. You can renew your subscription by selecting Extend subscription on the Manage subscription page in My account before your initial term ends. If you extend your subscription, we'll automatically charge you every month. If you made a one-time payment for your initial 6-month term, you'll now pay monthly. To make sure your learning is uninterrupted, please check your card details. To avoid the next payment charge, select Cancel subscription on the Manage subscription page in My account before the renewal date. You can subscribe again in the future by purchasing another eTextbook subscription.
Channels, also referred to as Study & Exam Prep, is a video platform with thousands of explanations, solutions, and practice problems in 19 subjects to help you do homework and prep for exams. Videos are personalized to your course, and tutors walk you through solutions. Plus, interactive AI-powered summaries and a social community help you understand lessons from your class.
Channels doesn't replace traditional textbooks or eTextbooks. It's an additional tool to help you with your studies, and it can be used with Pearson textbooks or non-Pearson textbooks.
When you choose a Channels subscription, you're signing up for a 1-month, 3-month or 12-month term and you make an upfront payment for your subscription. By default, these subscriptions auto-renew at the frequency you select during checkout. You'll have access to the full video library across all 19 subjects once you've subscribed. You can bundle Channels (also referred to as Study & Exam Prep) with your eTextbook at the time of purchase. Bundle subscription terms vary. You can choose your subscription term and payment frequency at checkout.
When you purchase a Channels subscription, it will last 1 month, 3 months or 12 months, depending on the plan you chose. Your subscription will automatically renew at the end of your term unless you cancel it. We use your credit card to renew your subscription automatically. To make sure your learning is uninterrupted, please check your card details. If your payment method fails, we'll send you an email with instructions for how to update it.