Database Design Using Entity-Relationship Diagrams
eBook - ePub

Database Design Using Entity-Relationship Diagrams

  1. 358 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Database Design Using Entity-Relationship Diagrams

About this book

Essential to database design, entity-relationship (ER) diagrams are known for their usefulness in data modeling and mapping out clear database designs. They are also well-known for being difficult to master. With Database Design Using Entity-Relationship Diagrams, Third Edition, database designers, developers, and students preparing to enter the field can quickly learn the ins and outs of data modeling through ER diagramming.

Building on the success of the bestselling first and second editions, this accessible text includes a new chapter on the relational model and functional dependencies. It also includes expanded chapters on Enhanced Entity-Relationship (EER) diagrams and reverse mapping. It uses cutting-edge case studies and examples to help readers master database development basics and defines ER and EER diagramming in terms of requirements (end user requests) and specifications (designer feedback to those requests), facilitating agile database development. This book

  • Describes a step-by-step approach for producing an ER diagram and developing a relational database from it



  • Contains exercises, examples, case studies, bibliographies, and summaries in each chapter



  • Details the rules for mapping ER diagrams to relational databases



  • Explains how to reverse engineer a relational database back to an entity-relationship model



  • Includes grammar for the ER diagrams that can be presented back to the user, facilitating agile database development



The updated exercises and chapter summaries provide the real-world understanding needed to develop ER and EER diagrams, map them to relational databases, and test the resulting relational database. Complete with a wealth of additional exercises and examples throughout, this edition should be a basic component of any database course. Its comprehensive nature and easy-to-navigate structure make it a resource that students and professionals will turn to throughout their careers.

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Database Design Using Entity-Relationship Diagrams by Sikha Saha Bagui,Richard Walsh Earp in PDF and/or ePUB format, as well as other popular books in Computer Science & Data Modelling & Design. We have over one million books available in our catalogue for you to explore.

Table of contents

  1. Cover
  2. Half Title
  3. Title
  4. Copyright
  5. Dedication
  6. Contents
  7. Preface
  8. Acknowledgments
  9. Authors
  10. Introduction
  11. Chapter 1 Data, Databases, and the Software Engineering Process
  12. Chapter 2 Data and Data Models
  13. Chapter 3 The Relational Model and Functional Dependencies
  14. Chapter 4 The Basic ER Diagram: A Data Modeling Schema
  15. Chapter 5 Beyond the First Entity Diagram
  16. Chapter 6 Extending Relationships/Structural Constraints
  17. Chapter 7 The Weak Entity
  18. Chapter 8 Further Extensions for ER Diagrams with Binary Relationships
  19. Chapter 9 Ternary and Higher-Order ER Diagrams
  20. Chapter 10 The Enhanced Entity-Relationship (EER) Model
  21. Chapter 11 Relational Mapping and Reverse Engineering ER/EER Diagrams
  22. Chapter 12 A Brief Overview of the Barker/Oracle-Like Model
  23. Glossary
  24. Index