Essential to database design, entity-relationship (ER) diagrams are known for their usefulness in mapping out clear database designs. They are also well-known for being difficult to master. With Database Design Using Entity-Relationship Diagrams, Second Edition, database designers, developers, and students preparing to enter the field can quickly learn the ins and outs of ER diagramming.
Building on the success of the bestselling first edition, 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).
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 makes it a resource that students and professionals will turn to throughout their careers.
Data, Databases, and the Software Engineering Process
Building a Database
What is the Software Engineering Process?
Entity Relationship Diagrams and the Software Engineering Life Cycle
Phase 1: Get the Requirements for the Database
Phase 2: Specify the Database
Phase 3: Design the Database
Data and Data Models
Files, Records, and Data Items
Moving from 3 × 5 Cards to Computers
The Hierarchical Model
The Network Model
The Relational Model
The Relational Model and Functional Dependencies
The Basic ER Diagram: A Data Modeling Schema
Beyond the First Entity Diagram
Extending Relationships/Structural Constraints
The Weak Entity
Further Extensions for ER Diagrams with Binary Relationships
Ternary and Higher-Order ER Diagrams
Relational Mapping and Reverse Engineering ER/EER Diagrams
Each chapter includes an introduction, chapter summary, exercises, and a bibliography
Dr. Sikha Saha Bagui is an associate professor and interim associate chair in the Department of Computer Science at the University of West Florida, Pensacola, Florida. She teaches a variety of computer science and database courses, and her research areas of concentration are database design, web databases, data mining and statistical computing. Dr. Bagui has published many journal articles and co-authored several books with Dr. Earp.
Dr. Richard Walsh Earp, Professor Emeritus, is a former chair of and former associate professor in the Department of Computer Science and former dean of the College of Science and Technology at the University of West Florida in Pensacola, Florida. Dr. Earp was also an instructor with Learning Tree International and worked for Computer Sciences Corporation at the Naval Air Station in Pensacola as a database consultant after his retirement from academia. He has co-authored several books with Dr. Bagui.
CRC Press eBooks are available through VitalSource. The free VitalSource Bookshelf® application allows you to access to your eBooks whenever and wherever you choose.The Bookshelf application offers access: