Database modeling & design: logical design
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Amsterdam
Elsevier
2005
|
| Ausgabe: | 4th ed |
| Schriftenreihe: | Morgan Kaufmann series in data management systems
|
| Schlagworte: | |
| Online-Zugang: | FAW01 FAW02 Volltext |
| Beschreibung: | Includes bibliographical references and index Cover -- Contents -- Preface -- Organization -- Typographical Conventions -- Acknowledgments -- Solutions Manual -- 1 Introduction -- 1.1 Data and Database Management -- 1.2 The Database Life Cycle -- 1.3 Conceptual Data Modeling -- 1.4 Summary -- 1.5 Literature Summary -- 2 The Entity-Relationship Model -- 2.1 Fundamental ER Constructs -- 2.1.1 Basic Objects: Entities, Relationships, Attributes -- 2.1.2 Degree of a Relationship -- 2.1.3 Connectivity of a Relationship -- 2.1.4 Attributes of a Relationship -- 2.1.5 Existence of an Entity in a Relationship -- 2.1.6 Alternative Conceptual Data Modeling Notations -- 2.2 Advanced ER Constructs -- 2.2.1 Generalization: Supertypes and Subtypes -- 2.2.2 Aggregation -- 2.2.3 Ternary Relationships -- 2.2.4 General n-ary Relationships -- 2.2.5 Exclusion Constraint -- 2.2.6 Referential Integrity -- 2.3 Summary -- 2.4 Literature Summary -- 3 The Unified Modeling Language (UML) -- 3.1 Class Diagrams -- 3.1.1 Basic Class Diagram Notation -- - 3.1.2 Class Diagrams for Database Design -- 3.1.3 Example from the Music Industry -- 3.2 Activity Diagrams -- 3.2.1 Activity Diagram Notation Description -- 3.2.2 Activity Diagrams for Workflow -- 3.3 Rules of Thumb for UML Usage -- 3.4 Summary -- 3.5 Literature Summary -- 4 Requirements Analysis and Conceptual Data Modeling -- 4.1 Introduction -- 4.2 Requirements Analysis -- 4.3 Conceptual Data Modeling -- 4.3.1 Classify Entities and Attributes -- 4.3.2 Identify the Generalization Hierarchies -- 4.3.3 Define Relationships -- 4.3.4 Example of Data Modeling: Company Personnel and Project Database -- 4.4 View Integration -- 4.4.1 Preintegration Analysis -- 4.4.2 Comparison of Schemas -- 4.4.3 Conformation of Schemas -- 4.4.4 Merging and Restructuring of Schemas -- 4.4.5 Example of View Integration -- 4.5 Entity Clustering for ER Models -- 4.5.1 Clustering Concepts -- 4.5.2 Grouping Operations -- 4.5.3 Clustering Technique -- 4.6 Summary -- 4.7 Literature Summary -- - 5 Transforming the Conceptual Data Model to SQL -- 5.1 Transformation Rules and SQL Constructs -- 5.1.1 Binary Relationships -- 5.1.2 Binary Recursive Relationships -- 5.1.3 Ternary and n-ary Relationships -- 5.1.4 Generalization and Aggregation -- 5.1.5 Multiple Relationships -- 5.1.6 Weak Entities -- 5.2 Transformation Steps -- 5.2.1 Entity Transformation -- 5.2.2 Many-to-Many Binary Relationship Transformation -- 5.2.3 Ternary Relationship Transformation -- 5.2.4 Example of ER-to-SQL Transformation -- 5.3 Summary -- 5.4 Literature Summary -- 6 Normalization -- 6.1 Fundamentals of Normalization -- 6.1.1 First Normal Form -- 6.1.2 Superkeys, Candidate Keys, and Primary Keys -- 6.1.3 Second Normal Form -- 6.1.4 Third Normal Form -- 6.1.5 Boyce-Codd Normal Form -- 6.2 The Design of Normalized Tables: A Simple Example -- 6.3 Normalizati |
| Beschreibung: | 1 Online-Ressource (xviii, 275 p.) |
| ISBN: | 0080470777 0126853525 9780080470771 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043095541 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151126s2006 |||| o||u| ||||||eng d | ||
| 020 | |a 0080470777 |c electronic bk. |9 0-08-047077-7 | ||
| 020 | |a 0126853525 |c Paper |9 0-12-685352-5 | ||
| 020 | |a 9780080470771 |c electronic bk. |9 978-0-08-047077-1 | ||
| 035 | |a (OCoLC)123570185 | ||
| 035 | |a (DE-599)BVBBV043095541 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 |a DE-1047 | ||
| 082 | 0 | |a 005.75/6 |2 22 | |
| 100 | 1 | |a Teorey, Toby J. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Database modeling & design |b logical design |c Tobey Teorey, Sam Lightstone, Tom Nadeau |
| 246 | 1 | 3 | |a Database modeling and design |
| 250 | |a 4th ed | ||
| 264 | 1 | |a Amsterdam |b Elsevier |c 2005 | |
| 300 | |a 1 Online-Ressource (xviii, 275 p.) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 0 | |a Morgan Kaufmann series in data management systems | |
| 500 | |a Includes bibliographical references and index | ||
| 500 | |a Cover -- Contents -- Preface -- Organization -- Typographical Conventions -- Acknowledgments -- Solutions Manual -- 1 Introduction -- 1.1 Data and Database Management -- 1.2 The Database Life Cycle -- 1.3 Conceptual Data Modeling -- 1.4 Summary -- 1.5 Literature Summary -- 2 The Entity-Relationship Model -- 2.1 Fundamental ER Constructs -- 2.1.1 Basic Objects: Entities, Relationships, Attributes -- 2.1.2 Degree of a Relationship -- 2.1.3 Connectivity of a Relationship -- 2.1.4 Attributes of a Relationship -- 2.1.5 Existence of an Entity in a Relationship -- 2.1.6 Alternative Conceptual Data Modeling Notations -- 2.2 Advanced ER Constructs -- 2.2.1 Generalization: Supertypes and Subtypes -- 2.2.2 Aggregation -- 2.2.3 Ternary Relationships -- 2.2.4 General n-ary Relationships -- 2.2.5 Exclusion Constraint -- 2.2.6 Referential Integrity -- 2.3 Summary -- 2.4 Literature Summary -- 3 The Unified Modeling Language (UML) -- 3.1 Class Diagrams -- 3.1.1 Basic Class Diagram Notation -- | ||
| 500 | |a - 3.1.2 Class Diagrams for Database Design -- 3.1.3 Example from the Music Industry -- 3.2 Activity Diagrams -- 3.2.1 Activity Diagram Notation Description -- 3.2.2 Activity Diagrams for Workflow -- 3.3 Rules of Thumb for UML Usage -- 3.4 Summary -- 3.5 Literature Summary -- 4 Requirements Analysis and Conceptual Data Modeling -- 4.1 Introduction -- 4.2 Requirements Analysis -- 4.3 Conceptual Data Modeling -- 4.3.1 Classify Entities and Attributes -- 4.3.2 Identify the Generalization Hierarchies -- 4.3.3 Define Relationships -- 4.3.4 Example of Data Modeling: Company Personnel and Project Database -- 4.4 View Integration -- 4.4.1 Preintegration Analysis -- 4.4.2 Comparison of Schemas -- 4.4.3 Conformation of Schemas -- 4.4.4 Merging and Restructuring of Schemas -- 4.4.5 Example of View Integration -- 4.5 Entity Clustering for ER Models -- 4.5.1 Clustering Concepts -- 4.5.2 Grouping Operations -- 4.5.3 Clustering Technique -- 4.6 Summary -- 4.7 Literature Summary -- | ||
| 500 | |a - 5 Transforming the Conceptual Data Model to SQL -- 5.1 Transformation Rules and SQL Constructs -- 5.1.1 Binary Relationships -- 5.1.2 Binary Recursive Relationships -- 5.1.3 Ternary and n-ary Relationships -- 5.1.4 Generalization and Aggregation -- 5.1.5 Multiple Relationships -- 5.1.6 Weak Entities -- 5.2 Transformation Steps -- 5.2.1 Entity Transformation -- 5.2.2 Many-to-Many Binary Relationship Transformation -- 5.2.3 Ternary Relationship Transformation -- 5.2.4 Example of ER-to-SQL Transformation -- 5.3 Summary -- 5.4 Literature Summary -- 6 Normalization -- 6.1 Fundamentals of Normalization -- 6.1.1 First Normal Form -- 6.1.2 Superkeys, Candidate Keys, and Primary Keys -- 6.1.3 Second Normal Form -- 6.1.4 Third Normal Form -- 6.1.5 Boyce-Codd Normal Form -- 6.2 The Design of Normalized Tables: A Simple Example -- 6.3 Normalizati | ||
| 650 | 4 | |a Bases de données relationnelles | |
| 650 | 4 | |a Bases de données / Conception | |
| 650 | 4 | |a Bases de données / Conception / Problèmes et exercices | |
| 650 | 4 | |a Bases de données réparties | |
| 650 | 4 | |a Structures de données (Informatique) | |
| 650 | 7 | |a COMPUTERS / Programming Languages / SQL. |2 bisacsh | |
| 650 | 7 | |a Banco de dados (projeto) |2 larpcal | |
| 650 | 7 | |a Modelagem de dados |2 larpcal | |
| 650 | 7 | |a Database design |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 650 | 4 | |a Relational databases | |
| 650 | 4 | |a Database design | |
| 650 | 0 | 7 | |a Datenbanksystem |0 (DE-588)4113276-2 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankentwurf |0 (DE-588)4127613-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Datenbankentwurf |0 (DE-588)4127613-9 |D s |
| 689 | 0 | |8 1\p |5 DE-604 | |
| 689 | 1 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 1 | |8 2\p |5 DE-604 | |
| 689 | 2 | 0 | |a Datenbanksystem |0 (DE-588)4113276-2 |D s |
| 689 | 2 | |8 3\p |5 DE-604 | |
| 700 | 1 | |a Lightstone, Sam |e Sonstige |4 oth | |
| 700 | 1 | |a Nadeau, Tom |e Sonstige |4 oth | |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=187205 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBA | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028519733 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 2\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 3\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=187205 |l FAW01 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=187205 |l FAW02 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1804175500396986368 |
|---|---|
| any_adam_object | |
| author | Teorey, Toby J. |
| author_facet | Teorey, Toby J. |
| author_role | aut |
| author_sort | Teorey, Toby J. |
| author_variant | t j t tj tjt |
| building | Verbundindex |
| bvnumber | BV043095541 |
| collection | ZDB-4-EBA |
| ctrlnum | (OCoLC)123570185 (DE-599)BVBBV043095541 |
| dewey-full | 005.75/6 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/6 |
| dewey-search | 005.75/6 |
| dewey-sort | 15.75 16 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 4th ed |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05816nmm a2200733zc 4500</leader><controlfield tag="001">BV043095541</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151126s2006 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080470777</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">0-08-047077-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0126853525</subfield><subfield code="c">Paper</subfield><subfield code="9">0-12-685352-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080470771</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-0-08-047077-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)123570185</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043095541</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-1046</subfield><subfield code="a">DE-1047</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/6</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Teorey, Toby J.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Database modeling & design</subfield><subfield code="b">logical design</subfield><subfield code="c">Tobey Teorey, Sam Lightstone, Tom Nadeau</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Database modeling and design</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">4th ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Amsterdam</subfield><subfield code="b">Elsevier</subfield><subfield code="c">2005</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xviii, 275 p.)</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">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Morgan Kaufmann series in data management systems</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Cover -- Contents -- Preface -- Organization -- Typographical Conventions -- Acknowledgments -- Solutions Manual -- 1 Introduction -- 1.1 Data and Database Management -- 1.2 The Database Life Cycle -- 1.3 Conceptual Data Modeling -- 1.4 Summary -- 1.5 Literature Summary -- 2 The Entity-Relationship Model -- 2.1 Fundamental ER Constructs -- 2.1.1 Basic Objects: Entities, Relationships, Attributes -- 2.1.2 Degree of a Relationship -- 2.1.3 Connectivity of a Relationship -- 2.1.4 Attributes of a Relationship -- 2.1.5 Existence of an Entity in a Relationship -- 2.1.6 Alternative Conceptual Data Modeling Notations -- 2.2 Advanced ER Constructs -- 2.2.1 Generalization: Supertypes and Subtypes -- 2.2.2 Aggregation -- 2.2.3 Ternary Relationships -- 2.2.4 General n-ary Relationships -- 2.2.5 Exclusion Constraint -- 2.2.6 Referential Integrity -- 2.3 Summary -- 2.4 Literature Summary -- 3 The Unified Modeling Language (UML) -- 3.1 Class Diagrams -- 3.1.1 Basic Class Diagram Notation -- </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - 3.1.2 Class Diagrams for Database Design -- 3.1.3 Example from the Music Industry -- 3.2 Activity Diagrams -- 3.2.1 Activity Diagram Notation Description -- 3.2.2 Activity Diagrams for Workflow -- 3.3 Rules of Thumb for UML Usage -- 3.4 Summary -- 3.5 Literature Summary -- 4 Requirements Analysis and Conceptual Data Modeling -- 4.1 Introduction -- 4.2 Requirements Analysis -- 4.3 Conceptual Data Modeling -- 4.3.1 Classify Entities and Attributes -- 4.3.2 Identify the Generalization Hierarchies -- 4.3.3 Define Relationships -- 4.3.4 Example of Data Modeling: Company Personnel and Project Database -- 4.4 View Integration -- 4.4.1 Preintegration Analysis -- 4.4.2 Comparison of Schemas -- 4.4.3 Conformation of Schemas -- 4.4.4 Merging and Restructuring of Schemas -- 4.4.5 Example of View Integration -- 4.5 Entity Clustering for ER Models -- 4.5.1 Clustering Concepts -- 4.5.2 Grouping Operations -- 4.5.3 Clustering Technique -- 4.6 Summary -- 4.7 Literature Summary -- </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - 5 Transforming the Conceptual Data Model to SQL -- 5.1 Transformation Rules and SQL Constructs -- 5.1.1 Binary Relationships -- 5.1.2 Binary Recursive Relationships -- 5.1.3 Ternary and n-ary Relationships -- 5.1.4 Generalization and Aggregation -- 5.1.5 Multiple Relationships -- 5.1.6 Weak Entities -- 5.2 Transformation Steps -- 5.2.1 Entity Transformation -- 5.2.2 Many-to-Many Binary Relationship Transformation -- 5.2.3 Ternary Relationship Transformation -- 5.2.4 Example of ER-to-SQL Transformation -- 5.3 Summary -- 5.4 Literature Summary -- 6 Normalization -- 6.1 Fundamentals of Normalization -- 6.1.1 First Normal Form -- 6.1.2 Superkeys, Candidate Keys, and Primary Keys -- 6.1.3 Second Normal Form -- 6.1.4 Third Normal Form -- 6.1.5 Boyce-Codd Normal Form -- 6.2 The Design of Normalized Tables: A Simple Example -- 6.3 Normalizati</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données relationnelles</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données / Conception</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données / Conception / Problèmes et exercices</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données réparties</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Structures de données (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Banco de dados (projeto)</subfield><subfield code="2">larpcal</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Modelagem de dados</subfield><subfield code="2">larpcal</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database design</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Relational databases</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database design</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</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="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</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=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="8">2\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="8">3\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Lightstone, Sam</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Nadeau, Tom</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=187205</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028519733</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">2\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">3\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=187205</subfield><subfield code="l">FAW01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=187205</subfield><subfield code="l">FAW02</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043095541 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:17:16Z |
| institution | BVB |
| isbn | 0080470777 0126853525 9780080470771 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028519733 |
| oclc_num | 123570185 |
| open_access_boolean | |
| owner | DE-1046 DE-1047 |
| owner_facet | DE-1046 DE-1047 |
| physical | 1 Online-Ressource (xviii, 275 p.) |
| psigel | ZDB-4-EBA ZDB-4-EBA FAW_PDA_EBA |
| publishDate | 2005 |
| publishDateSearch | 2006 |
| publishDateSort | 2006 |
| publisher | Elsevier |
| record_format | marc |
| series2 | Morgan Kaufmann series in data management systems |
| spelling | Teorey, Toby J. Verfasser aut Database modeling & design logical design Tobey Teorey, Sam Lightstone, Tom Nadeau Database modeling and design 4th ed Amsterdam Elsevier 2005 1 Online-Ressource (xviii, 275 p.) txt rdacontent c rdamedia cr rdacarrier Morgan Kaufmann series in data management systems Includes bibliographical references and index Cover -- Contents -- Preface -- Organization -- Typographical Conventions -- Acknowledgments -- Solutions Manual -- 1 Introduction -- 1.1 Data and Database Management -- 1.2 The Database Life Cycle -- 1.3 Conceptual Data Modeling -- 1.4 Summary -- 1.5 Literature Summary -- 2 The Entity-Relationship Model -- 2.1 Fundamental ER Constructs -- 2.1.1 Basic Objects: Entities, Relationships, Attributes -- 2.1.2 Degree of a Relationship -- 2.1.3 Connectivity of a Relationship -- 2.1.4 Attributes of a Relationship -- 2.1.5 Existence of an Entity in a Relationship -- 2.1.6 Alternative Conceptual Data Modeling Notations -- 2.2 Advanced ER Constructs -- 2.2.1 Generalization: Supertypes and Subtypes -- 2.2.2 Aggregation -- 2.2.3 Ternary Relationships -- 2.2.4 General n-ary Relationships -- 2.2.5 Exclusion Constraint -- 2.2.6 Referential Integrity -- 2.3 Summary -- 2.4 Literature Summary -- 3 The Unified Modeling Language (UML) -- 3.1 Class Diagrams -- 3.1.1 Basic Class Diagram Notation -- - 3.1.2 Class Diagrams for Database Design -- 3.1.3 Example from the Music Industry -- 3.2 Activity Diagrams -- 3.2.1 Activity Diagram Notation Description -- 3.2.2 Activity Diagrams for Workflow -- 3.3 Rules of Thumb for UML Usage -- 3.4 Summary -- 3.5 Literature Summary -- 4 Requirements Analysis and Conceptual Data Modeling -- 4.1 Introduction -- 4.2 Requirements Analysis -- 4.3 Conceptual Data Modeling -- 4.3.1 Classify Entities and Attributes -- 4.3.2 Identify the Generalization Hierarchies -- 4.3.3 Define Relationships -- 4.3.4 Example of Data Modeling: Company Personnel and Project Database -- 4.4 View Integration -- 4.4.1 Preintegration Analysis -- 4.4.2 Comparison of Schemas -- 4.4.3 Conformation of Schemas -- 4.4.4 Merging and Restructuring of Schemas -- 4.4.5 Example of View Integration -- 4.5 Entity Clustering for ER Models -- 4.5.1 Clustering Concepts -- 4.5.2 Grouping Operations -- 4.5.3 Clustering Technique -- 4.6 Summary -- 4.7 Literature Summary -- - 5 Transforming the Conceptual Data Model to SQL -- 5.1 Transformation Rules and SQL Constructs -- 5.1.1 Binary Relationships -- 5.1.2 Binary Recursive Relationships -- 5.1.3 Ternary and n-ary Relationships -- 5.1.4 Generalization and Aggregation -- 5.1.5 Multiple Relationships -- 5.1.6 Weak Entities -- 5.2 Transformation Steps -- 5.2.1 Entity Transformation -- 5.2.2 Many-to-Many Binary Relationship Transformation -- 5.2.3 Ternary Relationship Transformation -- 5.2.4 Example of ER-to-SQL Transformation -- 5.3 Summary -- 5.4 Literature Summary -- 6 Normalization -- 6.1 Fundamentals of Normalization -- 6.1.1 First Normal Form -- 6.1.2 Superkeys, Candidate Keys, and Primary Keys -- 6.1.3 Second Normal Form -- 6.1.4 Third Normal Form -- 6.1.5 Boyce-Codd Normal Form -- 6.2 The Design of Normalized Tables: A Simple Example -- 6.3 Normalizati Bases de données relationnelles Bases de données / Conception Bases de données / Conception / Problèmes et exercices Bases de données réparties Structures de données (Informatique) COMPUTERS / Programming Languages / SQL. bisacsh Banco de dados (projeto) larpcal Modelagem de dados larpcal Database design fast Relational databases fast Relational databases Database design Datenbanksystem (DE-588)4113276-2 gnd rswk-swf Datenbankentwurf (DE-588)4127613-9 gnd rswk-swf SQL (DE-588)4134010-3 gnd rswk-swf Datenbankentwurf (DE-588)4127613-9 s 1\p DE-604 SQL (DE-588)4134010-3 s 2\p DE-604 Datenbanksystem (DE-588)4113276-2 s 3\p DE-604 Lightstone, Sam Sonstige oth Nadeau, Tom Sonstige oth http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=187205 Aggregator Volltext 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 2\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 3\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Teorey, Toby J. Database modeling & design logical design Bases de données relationnelles Bases de données / Conception Bases de données / Conception / Problèmes et exercices Bases de données réparties Structures de données (Informatique) COMPUTERS / Programming Languages / SQL. bisacsh Banco de dados (projeto) larpcal Modelagem de dados larpcal Database design fast Relational databases fast Relational databases Database design Datenbanksystem (DE-588)4113276-2 gnd Datenbankentwurf (DE-588)4127613-9 gnd SQL (DE-588)4134010-3 gnd |
| subject_GND | (DE-588)4113276-2 (DE-588)4127613-9 (DE-588)4134010-3 |
| title | Database modeling & design logical design |
| title_alt | Database modeling and design |
| title_auth | Database modeling & design logical design |
| title_exact_search | Database modeling & design logical design |
| title_full | Database modeling & design logical design Tobey Teorey, Sam Lightstone, Tom Nadeau |
| title_fullStr | Database modeling & design logical design Tobey Teorey, Sam Lightstone, Tom Nadeau |
| title_full_unstemmed | Database modeling & design logical design Tobey Teorey, Sam Lightstone, Tom Nadeau |
| title_short | Database modeling & design |
| title_sort | database modeling design logical design |
| title_sub | logical design |
| topic | Bases de données relationnelles Bases de données / Conception Bases de données / Conception / Problèmes et exercices Bases de données réparties Structures de données (Informatique) COMPUTERS / Programming Languages / SQL. bisacsh Banco de dados (projeto) larpcal Modelagem de dados larpcal Database design fast Relational databases fast Relational databases Database design Datenbanksystem (DE-588)4113276-2 gnd Datenbankentwurf (DE-588)4127613-9 gnd SQL (DE-588)4134010-3 gnd |
| topic_facet | Bases de données relationnelles Bases de données / Conception Bases de données / Conception / Problèmes et exercices Bases de données réparties Structures de données (Informatique) COMPUTERS / Programming Languages / SQL. Banco de dados (projeto) Modelagem de dados Database design Relational databases Datenbanksystem Datenbankentwurf SQL |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=187205 |
| work_keys_str_mv | AT teoreytobyj databasemodelingdesignlogicaldesign AT lightstonesam databasemodelingdesignlogicaldesign AT nadeautom databasemodelingdesignlogicaldesign AT teoreytobyj databasemodelinganddesign AT lightstonesam databasemodelinganddesign AT nadeautom databasemodelinganddesign |