Database Design Using Entity-Relationship Diagrams 3rd

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.

資料庫設計中不可或缺的實體關係（ER）圖表以其在資料建模和清晰資料庫設計方面的有用性而聞名。它們也以難以掌握而聞名。《使用實體關係圖進行資料庫設計，第三版》讓資料庫設計師、開發人員和準備進入這個領域的學生能夠通過ER圖表快速學習資料建模的要點。

在暢銷的第一版和第二版的基礎上，這本易於理解的書籍新增了一章關於關聯模型和功能依賴性。它還擴展了關於增強實體關係（EER）圖表和反向映射的章節。書中使用尖端案例研究和示例，幫助讀者掌握資料庫開發基礎知識，並以需求（最終用戶要求）和規格（設計師對這些要求的反饋）的角度定義ER和EER圖表，促進敏捷資料庫開發。

本書：

- 描述了從ER圖表生成關聯資料庫並開發的逐步方法
- 每章包含練習、示例、案例研究、參考文獻和摘要
- 詳細介紹了將ER圖表映射到關聯資料庫的規則
- 解釋了如何將關聯資料庫逆向工程回實體關係模型
- 包含可呈現給用戶的ER圖表語法，促進敏捷資料庫開發

更新的練習和章節摘要提供了開發ER和EER圖表、將其映射到關聯資料庫並測試結果的實際理解。本版還包含大量的額外練習和示例，應該成為任何資料庫課程的基本組成部分。其全面性和易於導航的結構使其成為學生和專業人士在整個職業生涯中的重要資源。

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.

Dr. Sikha Saha Bagui是佛羅里達州彭薩科拉市西佛羅里達大學計算機科學系的副教授和代理副主任。她教授各種計算機科學和數據庫課程，其研究專注於數據庫設計、網絡數據庫、數據挖掘和統計計算。Bagui博士發表了許多期刊文章，並與Earp博士合著了幾本書。

Richard Walsh Earp博士是佛羅里達州彭薩科拉市西佛羅里達大學科學與技術學院的前任系主任、前任副教授和名譽教授。Earp博士在學術界退休後，曾是Learning Tree International的講師，並在佛羅里達州彭薩科拉的海軍航空站擔任計算機科學公司的數據庫顧問。他與Bagui博士合著了幾本書。