Database Design Using Entity-Relationship Diagrams, 2/e (Hardcover)

Sikha Bagui, Richard Earp

買這商品的人也買了...

商品描述

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).

  • 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

 

 

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.

商品描述(中文翻譯)

資料庫設計中不可或缺的實體關係(ER)圖表以其在清晰的資料庫設計中的有用性而聞名。它們也以難以掌握而聞名。《使用實體關係圖進行資料庫設計,第二版》讓資料庫設計師、開發人員和準備進入這個領域的學生能夠快速學習ER圖表的訣竅。

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

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

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