Database Design Using Entity-Relationship Diagrams
Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all...
Đã lưu trong:
| Những tác giả chính: | , |
|---|---|
| Định dạng: | Sách |
| Ngôn ngữ: | English |
| Được phát hành: |
CRC Press
2009
|
| Truy cập trực tuyến: | http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/1355 |
| Các nhãn: |
Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
|
| Thư viện lưu trữ: | Thư viện Trường Đại học Đà Lạt |
|---|
| id |
oai:scholar.dlu.edu.vn:DLU123456789-1355 |
|---|---|
| record_format |
dspace |
| institution |
Thư viện Trường Đại học Đà Lạt |
| collection |
Thư viện số |
| language |
English |
| description |
Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Because E-R diagrams are so fundamental to database design, this book is also an indispensable text for teaching computer science students the basics of database development.
Database Design Using Entity-Relationship Diagrams clarifies E-R diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). The book explains how open communication between designers and end users is critical to developing usable, easy-to-understand E-R diagrams that model both requirements and specifications.
The authors explain, in an intuitive, informal manner, how to develop an E-R diagram, how to map it to a database, and how the resulting database can be tested. This definitive guide is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers. |
| format |
Book |
| author |
Bagui, Sikha Earp, Richard |
| spellingShingle |
Bagui, Sikha Earp, Richard Database Design Using Entity-Relationship Diagrams |
| author_facet |
Bagui, Sikha Earp, Richard |
| author_sort |
Bagui, Sikha |
| title |
Database Design Using Entity-Relationship Diagrams |
| title_short |
Database Design Using Entity-Relationship Diagrams |
| title_full |
Database Design Using Entity-Relationship Diagrams |
| title_fullStr |
Database Design Using Entity-Relationship Diagrams |
| title_full_unstemmed |
Database Design Using Entity-Relationship Diagrams |
| title_sort |
database design using entity-relationship diagrams |
| publisher |
CRC Press |
| publishDate |
2009 |
| url |
http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/1355 |
| _version_ |
1757671140558372864 |
| spelling |
oai:scholar.dlu.edu.vn:DLU123456789-13552009-11-27T09:22:49Z Database Design Using Entity-Relationship Diagrams Bagui, Sikha Earp, Richard Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Because E-R diagrams are so fundamental to database design, this book is also an indispensable text for teaching computer science students the basics of database development. Database Design Using Entity-Relationship Diagrams clarifies E-R diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). The book explains how open communication between designers and end users is critical to developing usable, easy-to-understand E-R diagrams that model both requirements and specifications. The authors explain, in an intuitive, informal manner, how to develop an E-R diagram, how to map it to a database, and how the resulting database can be tested. This definitive guide is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers. 1 The Software Engineering Process and Relational Databases * Chapter Topics * What Is the Software Engineering Process? * ER Diagrams and the Software Engineering Life Cycle * Data Models * The Hierarchical Model * The Network Model * The Relational Model * Functional Dependencies * A Brief Look at Normal Forms * First Normal Form (1NF) * Second Normal Form (2NF) * Third Normal Form (3NF) * Examples of 1NF, 2NF, and 3NF * Chapter Summary * Chapter 1 Exercises * References 2 The Basic ER Diagram: A Data Modeling Schema * Chapter Topics * What Is a Data Modeling Schema? * What Is an Entity Relationship (ER) Diagram? * Defining the Database — Some Definitions: Entity, * Relationship, Attribute * A Beginning Methodology * ER Design Methodology * A First “Entity-Only” ER Diagram: An Entity with Attributes * More about Attributes * The Simple or Atomic Attribute * The Composite Attribute * The Multi-Valued Attribute * The Derived Attribute * Keys * English Description of the Entity * The Method * ER Design Methodology * Examples * ER Design Methodology * Mapping the Entity Diagram to a Relational Database * Chapter Summary * Chapter 2 Exercises * References * Case Study 3 Beyond the First Entity Diagram * Chapter Topics * Examining an Entity — Changing an Attribute to an Entity * Defining a Relationship for Our New Entity * ER Design Methodology * A Preliminary Grammar for the ER Diagrams * Defining a Second Entity * Does a Relationship Exist? * Attribute or Relationship? * ER Design Methodology * Chapter Summary * Chapter 3 Exercises * References * Case Study 4 Extending Relationships/Structural Constraints * Chapter Topics * The Cardinality Ratio of a Relationship * One-to-One (1:1) * Many-to-One (M:1) * One-to-Many (1:M) * Many-to-Many (M:N) * Participation: Full/Partial * English Descriptions * Tighter English * Pattern 1 — x:y::k:1 * Pattern 2 — x:y::k:1 * Pattern 3 — x:y::k:M * Pattern 4 — x:y::k:M * Summary of the above Patterns and Relationships * ER Design Methodology * Some Examples of Other Relationships * An Example of the One-to-Many Relationship (1:M) * An Example of the Many-to-One Relationship (M:1) * An Example of the Many-to-Many Relationship (M:N) * One Final Example * ER Design Methodology * Mapping Relationships to a Relational Database * Chapter Summary * Chapter 4 Exercises * References * Case Study 5 The Weak Entity * Chapter Topics * Strong and Weak Entities * Weak Entities and Structural Constraints * Weak Entities and the Identifying Owner * Another Example of a Weak Entity and the Identifying Owner * Weak Entities Connected to Other Weak Entities * Revisiting the Methodology * Weak Entity Grammar * Mapping Weak Entities to a Relational Database * Chapter Summary * Chapter 5 Exercises * References * Case Study 6 Further Extensions for ER Diagrams with Binary Relationships * Chapter Topics * Attributes of Relationships * Relationships Developing into Entities: * The M:N Relationship Revisited * More Entities and Relationships * More than Two Entities * Pattern 4 — x:y::1:M, from the 1 Side, Partial Participation * Pattern 1 — x:y::M:1, from the M Side, Full Participation * Adding More Attributes that Evolve into Entities * More Evolution of the Database * Attributes that Evolve into Entities * Recursive Relationships * Recursive Relationships and Structural Constraints * Multiple Relationships * The Derived or Redundant Relationship * Optional Section * An Alternative ER Notation for Specifying Structural * Constraints on Relationships * Review of the Methodology * ER Design Methodology * Mapping Rules for Recursive Relationships * Chapter Summary * Chapter 6 Exercises * References * Case Study 7 Ternary and Higher-Order ER Diagrams * Chapter Topics * Binary or Ternary Relationship? * Structural Constraints for Ternary Relationships * Many-to-Many-to-Many (M:M:M) Structural Constraint * Example of n-ary Relationship * n-ary Relationships Do Not Preclude Binary Relationships * Methodology and Grammar for the n-ary Relationship * The More Exact Grammar * Grammar in a Partial Participation, Ternary Relationship with a 1-Relationship * Ternary Relationships from Relationship–Relationship Situations * n-ary Relationships that May Be Resolved into Binary Relationships * Mapping Ternary Diagrams to a Relational Database * ER Design Methodology * Chapter Summary * Chapter 7 Exercises * References 8 Generalizations and Specializations * Chapter Topics * What Is a Generalization or Specialization? * A Problem with Variants * Example of a Generalization or Specialization * Methodology and Grammar for Generalization/Specialization * Relationships * Mapping Rules for Generalizations and Specializations * ER Design Methodology * Chapter Summary * Chapter 8 Exercises * References * Case Study 9 Relational Mapping and Reverse-Engineering * ER Diagrams * Chapter Topics * Steps Used to Map an ER Diagram to a Relational Database * Reverse-Engineering * Chapter Summary * Chapter 9 Exercises * References 10 A Brief Overview of the Barker/Oracle-Like Model * Chapter Topics * A First “Entity-Only” ER Diagram — An Entity with Attributes * Attributes in the Barker/Oracle-Like Model * Optional versus Mandatory Attributes * Relationships in the Barker/Oracle-Like Model * Structural Constraints in the Barker/Oracle-Like Model * Dealing with the Concept of the Weak Entity in the Barker/Oracle-Like Model * Dealing with the Concept of Multi-Valued Attributes in the Barker/Oracle-Like Model * Treatment of Foreign Keys * Recursive Relationships in the Barker/Oracle-Like Model * Mapping M:N Relationships * Chapter Summary * Chapter 10 Exercises * References Glossary 2009-11-27T09:22:49Z 2009-11-27T09:22:49Z 2003 Book http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/1355 en application/octet-stream CRC Press |