Database design using entity relationship diagrams:
"This comprehensive guide clarifies ER diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). This book explains how open communication between designers and end users is critical to developing usable, easy-to-understand...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Boca Raton [u.a.]
Auerbach
2003
|
| Series: | Foundations of database design series
|
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Summary: | "This comprehensive guide clarifies ER diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). This book explains how open communication between designers and end users is critical to developing usable, easy-to-understand ER diagrams that model both requirements and specifications." "The authors examine, in an intuitive, informal manner, how to develop an ER diagram, how to map it to a database, and how the resulting database can be tested. This definitive volume is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers."--BOOK JACKET. |
| Physical Description: | XIX, 242 S. graph. Darst. |
| ISBN: | 0849315484 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV019799686 | ||
| 003 | DE-604 | ||
| 005 | 20091026 | ||
| 007 | t | ||
| 008 | 050504s2003 d||| |||| 00||| eng d | ||
| 020 | |a 0849315484 |9 0-8493-1548-4 | ||
| 035 | |a (OCoLC)51582153 | ||
| 035 | |a (DE-599)BVBBV019799686 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-29T |a DE-20 | ||
| 050 | 0 | |a QA76.9.D26 | |
| 082 | 0 | |a 005.74 |2 21 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 100 | 1 | |a Bagui, Sikha |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Database design using entity relationship diagrams |c Sikha Bagui and Richard Earp |
| 246 | 1 | 3 | |a Database design using entity-relationship diagrams |
| 264 | 1 | |a Boca Raton [u.a.] |b Auerbach |c 2003 | |
| 300 | |a XIX, 242 S. |b graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Foundations of database design series | |
| 520 | 1 | |a "This comprehensive guide clarifies ER diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). This book explains how open communication between designers and end users is critical to developing usable, easy-to-understand ER diagrams that model both requirements and specifications." "The authors examine, in an intuitive, informal manner, how to develop an ER diagram, how to map it to a database, and how the resulting database can be tested. This definitive volume is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers."--BOOK JACKET. | |
| 650 | 4 | |a Database design | |
| 650 | 4 | |a Relational databases | |
| 650 | 0 | 7 | |a Entity-Relationship-Datenmodell |0 (DE-588)4230505-6 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankentwurf |0 (DE-588)4127613-9 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Datenbankentwurf |0 (DE-588)4127613-9 |D s |
| 689 | 0 | 1 | |a Entity-Relationship-Datenmodell |0 (DE-588)4230505-6 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Earp, Richard |e Verfasser |4 aut | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013125275&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-013125275 | ||
Record in the Search Index
| _version_ | 1804133292624052224 |
|---|---|
| adam_text | Titel: Database design using entity relationship diagrams
Autor: Bagui, Sikha
Jahr: 2003
Contents
Preface xiii
Acknowledgments xv
Introduction xvii
1 The Software Engineering Process
and Relational Databases 1
Chapter Topics 1
What Is the Software Engineering Process? 2
ER Diagrams and the Software Engineering Life Cycle 3
Data Models 4
The Hierarchical Model 5
The Network Model 7
The Relational Model 7
Functional Dependencies 8
A Brief Look at Normal Forms 15
First Normal Form (INF) 15
Second Normal Form (2NF) 15
Third Normal Form (3NF) 16
Examples of INF, 2NF, and 3NF 17
Chapter Summary 20
Chapter 1 Exercises 20
References 20
2 The Basic ER Diagram: A Data Modeling Schema 23
Chapter Topics 23
What Is a Data Modeling Schema? 24
What Is an Entity Relationship (ER) Diagram? 24
Defining the Database — Some Definitions: Entity,
Relationship, Attribute 25
vii
viii Database Design Using Entity-Relationship Diagrams
A Beginning Methodology 26
ER Design Methodology 27
A First Entity-Only ER Diagram: An Entity with Attributes 28
More about Attributes 28
The Simple or Atomic Attribute 30
The Composite Attribute 31
The Multi-Valued Attribute 32
The Derived Attribute 33
Keys 33
English Description of the Entity 36
The Method 36
ER Design Methodology 37
Examples 38
ER Design Methodology 41
Mapping the Entity Diagram to a Relational Database 42
Chapter Summary 46
Chapter 2 Exercises 46
References 47
Case Study 48
3 Beyond the First Entity Diagram 53
Chapter Topics 53
Examining an Entity — Changing an Attribute to an Entity 54
Defining a Relationship for Our New Entity 54
ER Design Methodology 56
A Preliminary Grammar for the ER Diagrams 57
Defining a Second Entity 58
Does a Relationship Exist? 60
Attribute or Relationship? 6l
ER Design Methodology 62
Chapter Summary 63
Chapter 3 Exercises 63
References 64
Case Study 65
4 Extending Relationships/Structural Constraints 73
Chapter Topics 73
The Cardinality Ratio of a Relationship 74
One-to-One (1:1) 74
Many-to-One (M:l) 74
One-to-Many (1:M) 76
Many-to-Many (M:N) 76
Participation: Full/Partial 78
English Descriptions 80
Contents ix
: 1 Tighter English 80
Pattern 1 — x:y::k:l 81
: Pattern 2 — x:y::k:l 82
Pattern 3 — x:y::k:M 82
; Pattern 4 — x:y::k:M 83
v . Summary of the above Patterns and Relationships 84
ER Design Methodology 88
Some Examples of Other Relationships 89
An Example of the One-to-Many Relationship (1:M) 89
An Example of the Many-to-One Relationship (M:l) 91
An Example of the Many-to-Many Relationship (M:N) 92
One Final Example 94
ER Design Methodology 94
Mapping Relationships to a Relational Database 98
Chapter Summary 105
Chapter 4 Exercises 106
References 108
Case Study 109
5 The Weak Entity 115
Chapter Topics 115
Strong and Weak Entities 116
Weak Entities and Structural Constraints 119
Weak Entities and the Identifying Owner 119
Another Example of a Weak Entity and the Identifying Owner.... 121
Weak Entities Connected to Other Weak Entities 121
Revisiting the Methodology 123
Weak Entity Grammar 124
Mapping Weak Entities to a Relational Database 125
Chapter Summary 126
Chapter 5 Exercises 127
References 127
Case Study 128
6 Further Extensions for ER Diagrams
with Binary Relationships 133
Chapter Topics 133
Attributes of Relationships 134
Relationships Developing into Entities:
The M:N Relationship Revisited 136
More Entities and Relationships 138
More than Two Entities 138
Pattern 4 — x:y::l:M, from the 1 Side, Partial Participation.. 139
Pattern 1 — x:y::M:l, from the M Side, Full Participation 139
Adding More Attributes that Evolve into Entities 140
X
Database Design Using Entity-Relationship Diagrams
More Evolution of the Database 141
Attributes that Evolve into Entities 142
Recursive Relationships 145
Recursive Relationships and Structural Constraints 147
Multiple Relationships 149
The Derived or Redundant Relationship 150
Optional Section 154
An Alternative ER Notation for Specifying Structural
Constraints on Relationships 154
Review of the Methodology 156
ER Design Methodology 156
Mapping Rules for Recursive Relationships 158
Chapter Summary 159
Chapter 6 Exercises 160
References 161
Case Study 162
7 Ternary and Higher-Order ER Diagrams 165
Chapter Topics 165
Binary or Ternary Relationship? 166
Structural Constraints for Ternary Relationships 169
Many-to-Many-to-Many (M:M:M) Structural Constraint 169
Example of n-ary Relationship 171
n-ary Relationships Do Not Preclude Binary Relationships 171
Methodology and Grammar for the n-ary Relationship 172
The More Exact Grammar 174
Grammar in a Partial Participation, Ternary Relationship
with a 1-Relationship 175
Ternary Relationships from Relationship-Relationship
Situations 176
n-ary Relationships that May Be Resolved into Binary
Relationships 179
Mapping Ternary Diagrams to a Relational Database 182
ER Design Methodology 183
Chapter Summary 184
Chapter 7 Exercises 185
References 185
8 Generalizations and Specializations 187
Chapter Topics 187
What Is a Generalization or Specialization? 188
A Problem with Variants 188
Example of a Generalization or Specialization 189
Methodology and Grammar for Generalization/Specialization
Relationships 194
Contents xi
Mapping Rules for Generalizations and Specializations 195
ER Design Methodology 196
Chapter Summary 198
Chapter 8 Exercises 198
References 199
Case Study 200
9 Relational Mapping and Reverse-Engineering
ER Diagrams 205
Chapter Topics 205
Steps Used to Map an ER Diagram to a Relational Database... 205
Reverse-Engineering 210
Chapter Summary 216
Chapter 9 Exercises 217
References 218
10 A Brief Overview of the Barker/Oracle-Like Model 219
Chapter Topics 219
A First Entity-Only ER Diagram — An Entity with Attributes 220
Attributes in the Barker/Oracle-Like Model 221
Optional versus Mandatory Attributes 221
Relationships in the Barker/Oracle-Like Model 222
Structural Constraints in the Barker/Oracle-Like Model 223
Dealing with the Concept of the Weak Entity
in the Barker/Oracle-Like Model 225
Dealing with the Concept of Multi-Valued Attributes
in the Barker/Oracle-Like Model 226
Treatment of Foreign Keys 227
Recursive Relationships in the Barker/Oracle-Like Model 227
Mapping M:N Relationships 228
Chapter Summary 229
Chapter 10 Exercises 230
References 231
Glossary .233
Index 237
|
| any_adam_object | 1 |
| author | Bagui, Sikha Earp, Richard |
| author_facet | Bagui, Sikha Earp, Richard |
| author_role | aut aut |
| author_sort | Bagui, Sikha |
| author_variant | s b sb r e re |
| building | Verbundindex |
| bvnumber | BV019799686 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D26 |
| callnumber-search | QA76.9.D26 |
| callnumber-sort | QA 276.9 D26 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)51582153 (DE-599)BVBBV019799686 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02335nam a2200433 c 4500</leader><controlfield tag="001">BV019799686</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20091026 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">050504s2003 d||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0849315484</subfield><subfield code="9">0-8493-1548-4</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)51582153</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV019799686</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-29T</subfield><subfield code="a">DE-20</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D26</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">21</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Bagui, Sikha</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Database design using entity relationship diagrams</subfield><subfield code="c">Sikha Bagui and Richard Earp</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Database design using entity-relationship diagrams</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Boca Raton [u.a.]</subfield><subfield code="b">Auerbach</subfield><subfield code="c">2003</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIX, 242 S.</subfield><subfield code="b">graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Foundations of database design series</subfield></datafield><datafield tag="520" ind1="1" ind2=" "><subfield code="a">"This comprehensive guide clarifies ER diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). This book explains how open communication between designers and end users is critical to developing usable, easy-to-understand ER diagrams that model both requirements and specifications." "The authors examine, in an intuitive, informal manner, how to develop an ER diagram, how to map it to a database, and how the resulting database can be tested. This definitive volume is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers."--BOOK JACKET.</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database design</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Entity-Relationship-Datenmodell</subfield><subfield code="0">(DE-588)4230505-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Entity-Relationship-Datenmodell</subfield><subfield code="0">(DE-588)4230505-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Earp, Richard</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013125275&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-013125275</subfield></datafield></record></collection> |
| id | DE-604.BV019799686 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T20:06:24Z |
| institution | BVB |
| isbn | 0849315484 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-013125275 |
| oclc_num | 51582153 |
| open_access_boolean | |
| owner | DE-29T DE-20 |
| owner_facet | DE-29T DE-20 |
| physical | XIX, 242 S. graph. Darst. |
| publishDate | 2003 |
| publishDateSearch | 2003 |
| publishDateSort | 2003 |
| publisher | Auerbach |
| record_format | marc |
| series2 | Foundations of database design series |
| spelling | Bagui, Sikha Verfasser aut Database design using entity relationship diagrams Sikha Bagui and Richard Earp Database design using entity-relationship diagrams Boca Raton [u.a.] Auerbach 2003 XIX, 242 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier Foundations of database design series "This comprehensive guide clarifies ER diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). This book explains how open communication between designers and end users is critical to developing usable, easy-to-understand ER diagrams that model both requirements and specifications." "The authors examine, in an intuitive, informal manner, how to develop an ER diagram, how to map it to a database, and how the resulting database can be tested. This definitive volume is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers."--BOOK JACKET. Database design Relational databases Entity-Relationship-Datenmodell (DE-588)4230505-6 gnd rswk-swf Datenbankentwurf (DE-588)4127613-9 gnd rswk-swf Datenbankentwurf (DE-588)4127613-9 s Entity-Relationship-Datenmodell (DE-588)4230505-6 s DE-604 Earp, Richard Verfasser aut HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013125275&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Bagui, Sikha Earp, Richard Database design using entity relationship diagrams Database design Relational databases Entity-Relationship-Datenmodell (DE-588)4230505-6 gnd Datenbankentwurf (DE-588)4127613-9 gnd |
| subject_GND | (DE-588)4230505-6 (DE-588)4127613-9 |
| title | Database design using entity relationship diagrams |
| title_alt | Database design using entity-relationship diagrams |
| title_auth | Database design using entity relationship diagrams |
| title_exact_search | Database design using entity relationship diagrams |
| title_full | Database design using entity relationship diagrams Sikha Bagui and Richard Earp |
| title_fullStr | Database design using entity relationship diagrams Sikha Bagui and Richard Earp |
| title_full_unstemmed | Database design using entity relationship diagrams Sikha Bagui and Richard Earp |
| title_short | Database design using entity relationship diagrams |
| title_sort | database design using entity relationship diagrams |
| topic | Database design Relational databases Entity-Relationship-Datenmodell (DE-588)4230505-6 gnd Datenbankentwurf (DE-588)4127613-9 gnd |
| topic_facet | Database design Relational databases Entity-Relationship-Datenmodell Datenbankentwurf |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013125275&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT baguisikha databasedesignusingentityrelationshipdiagrams AT earprichard databasedesignusingentityrelationshipdiagrams |