Database modeling & design :: logical design /
Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you mo...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Weitere Verfasser: | , |
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Amsterdam : Boston :
Elsevier ; Morgan Kaufmann Publishers,
2005.
|
| Ausgabe: | 4th ed. |
| Schriftenreihe: | Morgan Kaufmann series in data management systems.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs? In the extensively revised fourth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you'll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems: a detailed look at the Unified Modeling Language (UML-2) as well as the entity-relationship (ER) approach for data requirements specification and conceptual modeling--with examples throughout the book in both approaches; the details and examples of how to use data modeling concepts in logical database design, and the transformation of the conceptual model to the relational model and to SQL syntax; the fundamentals of database normalization through the fifth normal form; practical coverage of the major issues in business intelligence--data warehousing, OLAP for decision support systems, and data mining; examples for how to use the most popular CASE tools to handle complex data modeling problems; exercises that test understanding of all material, plus solutions for many exercises. |
| Beschreibung: | 1 online resource (xviii, 275 pages) : illustrations |
| Bibliographie: | Includes bibliographical references and index. |
| ISBN: | 9780080470771 0080470777 9780126853520 0126853525 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn123570185 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 070426s2006 ne a ob 001 0 eng d | ||
| 040 | |a N$T |b eng |e pn |c N$T |d OCLCQ |d MERUC |d DEBBG |d IDEBK |d OCLCQ |d OCLCO |d OCLCF |d NLGGC |d YDXCP |d OCLCQ |d COO |d AZK |d COCUF |d AGLDB |d ZCU |d JBG |d OCLCQ |d D6H |d OCLCQ |d VTS |d INT |d OCLCQ |d AU@ |d OCLCQ |d STF |d LEAUB |d M8D |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCQ |d OCL |d OCLCO | ||
| 019 | |a 154702794 |a 441773674 |a 961620354 |a 962623464 |a 1058110342 | ||
| 020 | |a 9780080470771 |q (electronic bk.) | ||
| 020 | |a 0080470777 |q (electronic bk.) | ||
| 020 | |a 9780126853520 | ||
| 020 | |a 0126853525 | ||
| 020 | |z 0126853525 |q (Paper) | ||
| 035 | |a (OCoLC)123570185 |z (OCoLC)154702794 |z (OCoLC)441773674 |z (OCoLC)961620354 |z (OCoLC)962623464 |z (OCoLC)1058110342 | ||
| 037 | |a 105785:105815 |b Elsevier Science & Technology |n http://www.sciencedirect.com | ||
| 050 | 4 | |a QA76.9.D26 |b T45 2006eb | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 7 | |a 005.75/6 |2 22 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Teorey, Toby J. |0 http://id.loc.gov/authorities/names/n81145227 | |
| 245 | 1 | 0 | |a Database modeling & design : |b logical design / |c Tobey Teorey, Sam Lightstone, Tom Nadeau. |
| 246 | 3 | |a Database modeling and design | |
| 250 | |a 4th ed. | ||
| 260 | |a Amsterdam : |b Elsevier ; |a Boston : |b Morgan Kaufmann Publishers, |c 2005. | ||
| 300 | |a 1 online resource (xviii, 275 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Morgan Kaufmann series in data management systems | |
| 504 | |a Includes bibliographical references and index. | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |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 -- 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. | |
| 520 | |a Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs? In the extensively revised fourth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you'll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems: a detailed look at the Unified Modeling Language (UML-2) as well as the entity-relationship (ER) approach for data requirements specification and conceptual modeling--with examples throughout the book in both approaches; the details and examples of how to use data modeling concepts in logical database design, and the transformation of the conceptual model to the relational model and to SQL syntax; the fundamentals of database normalization through the fifth normal form; practical coverage of the major issues in business intelligence--data warehousing, OLAP for decision support systems, and data mining; examples for how to use the most popular CASE tools to handle complex data modeling problems; exercises that test understanding of all material, plus solutions for many exercises. | ||
| 650 | 0 | |a Relational databases. |0 http://id.loc.gov/authorities/subjects/sh86007768 | |
| 650 | 0 | |a Database design. |0 http://id.loc.gov/authorities/subjects/sh88004472 | |
| 650 | 0 | |a Database design |v Problems, exercises, etc. | |
| 650 | 0 | |a Distributed databases. |0 http://id.loc.gov/authorities/subjects/sh88000865 | |
| 650 | 0 | |a Data structures (Computer science) |0 http://id.loc.gov/authorities/subjects/sh85035862 | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 6 | |a Bases de données |x Conception. | |
| 650 | 6 | |a Bases de données |x Conception |v Problèmes et exercices. | |
| 650 | 6 | |a Bases de données réparties. | |
| 650 | 6 | |a Structures de données (Informatique) | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Relational databases. |2 blmlsh | |
| 650 | 7 | |a Database design. |2 blmlsh | |
| 650 | 7 | |a Distributed databases |2 fast | |
| 650 | 7 | |a Data structures (Computer science) |2 fast | |
| 650 | 7 | |a Database design |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 650 | 7 | |a Banco de dados (projeto) |2 larpcal | |
| 650 | 7 | |a Modelagem de dados. |2 larpcal | |
| 655 | 2 | |a Problems and Exercises |0 https://id.nlm.nih.gov/mesh/D020497 | |
| 655 | 7 | |a exercise books. |2 aat | |
| 655 | 7 | |a Problems and exercises |2 fast | |
| 655 | 7 | |a Problems and exercises. |2 lcgft |0 http://id.loc.gov/authorities/genreForms/gf2014026154 | |
| 655 | 7 | |a Problèmes et exercices. |2 rvmgf | |
| 700 | 1 | |a Lightstone, Sam. | |
| 700 | 1 | |a Nadeau, Tom. | |
| 776 | 0 | 8 | |i Print version: |a Teorey, Toby J. |t Database modeling & design. |b 4th ed. |d Amsterdam : Elsevier ; Boston : Morgan Kaufmann Publishers, 2005 |z 0126853525 |z 9780126853520 |w (DLC) 2005052013 |w (OCoLC)61169898 |
| 830 | 0 | |a Morgan Kaufmann series in data management systems. |0 http://id.loc.gov/authorities/names/n90627178 | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=187205 |3 Volltext |
| 938 | |a EBSCOhost |b EBSC |n 187205 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n 96150 | ||
| 938 | |a YBP Library Services |b YANK |n 2551326 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn123570185 |
|---|---|
| _version_ | 1816881647267610624 |
| adam_text | |
| any_adam_object | |
| author | Teorey, Toby J. |
| author2 | Lightstone, Sam Nadeau, Tom |
| author2_role | |
| author2_variant | s l sl t n tn |
| author_GND | http://id.loc.gov/authorities/names/n81145227 |
| author_facet | Teorey, Toby J. Lightstone, Sam Nadeau, Tom |
| author_role | |
| author_sort | Teorey, Toby J. |
| author_variant | t j t tj tjt |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D26 T45 2006eb |
| callnumber-search | QA76.9.D26 T45 2006eb |
| callnumber-sort | QA 276.9 D26 T45 42006EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | 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. |
| ctrlnum | (OCoLC)123570185 |
| 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>08299cam a2200817 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn123570185</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">070426s2006 ne a ob 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">N$T</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">N$T</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">MERUC</subfield><subfield code="d">DEBBG</subfield><subfield code="d">IDEBK</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">NLGGC</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">COO</subfield><subfield code="d">AZK</subfield><subfield code="d">COCUF</subfield><subfield code="d">AGLDB</subfield><subfield code="d">ZCU</subfield><subfield code="d">JBG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">D6H</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">VTS</subfield><subfield code="d">INT</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AU@</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">STF</subfield><subfield code="d">LEAUB</subfield><subfield code="d">M8D</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCL</subfield><subfield code="d">OCLCO</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">154702794</subfield><subfield code="a">441773674</subfield><subfield code="a">961620354</subfield><subfield code="a">962623464</subfield><subfield code="a">1058110342</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080470771</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080470777</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780126853520</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0126853525</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">0126853525</subfield><subfield code="q">(Paper)</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)123570185</subfield><subfield code="z">(OCoLC)154702794</subfield><subfield code="z">(OCoLC)441773674</subfield><subfield code="z">(OCoLC)961620354</subfield><subfield code="z">(OCoLC)962623464</subfield><subfield code="z">(OCoLC)1058110342</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">105785:105815</subfield><subfield code="b">Elsevier Science & Technology</subfield><subfield code="n">http://www.sciencedirect.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D26</subfield><subfield code="b">T45 2006eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051170</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.75/6</subfield><subfield code="2">22</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Teorey, Toby J.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n81145227</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="3" ind2=" "><subfield code="a">Database modeling and design</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">4th ed.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Amsterdam :</subfield><subfield code="b">Elsevier ;</subfield><subfield code="a">Boston :</subfield><subfield code="b">Morgan Kaufmann Publishers,</subfield><subfield code="c">2005.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (xviii, 275 pages) :</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Morgan Kaufmann series in data management systems</subfield></datafield><datafield tag="504" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index.</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="505" ind1="0" 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 -- 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.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs? In the extensively revised fourth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you'll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems: a detailed look at the Unified Modeling Language (UML-2) as well as the entity-relationship (ER) approach for data requirements specification and conceptual modeling--with examples throughout the book in both approaches; the details and examples of how to use data modeling concepts in logical database design, and the transformation of the conceptual model to the relational model and to SQL syntax; the fundamentals of database normalization through the fifth normal form; practical coverage of the major issues in business intelligence--data warehousing, OLAP for decision support systems, and data mining; examples for how to use the most popular CASE tools to handle complex data modeling problems; exercises that test understanding of all material, plus solutions for many exercises.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Relational databases.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh86007768</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database design.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh88004472</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database design</subfield><subfield code="v">Problems, exercises, etc.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Distributed databases.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh88000865</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Data structures (Computer science)</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035862</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données relationnelles.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Conception.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Conception</subfield><subfield code="v">Problèmes et exercices.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données réparties.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Structures de données (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Programming Languages</subfield><subfield code="x">SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Relational databases.</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database design.</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Distributed databases</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Data structures (Computer science)</subfield><subfield code="2">fast</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="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="655" ind1=" " ind2="2"><subfield code="a">Problems and Exercises</subfield><subfield code="0">https://id.nlm.nih.gov/mesh/D020497</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">exercise books.</subfield><subfield code="2">aat</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Problems and exercises</subfield><subfield code="2">fast</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Problems and exercises.</subfield><subfield code="2">lcgft</subfield><subfield code="0">http://id.loc.gov/authorities/genreForms/gf2014026154</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Problèmes et exercices.</subfield><subfield code="2">rvmgf</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Lightstone, Sam.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Nadeau, Tom.</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Teorey, Toby J.</subfield><subfield code="t">Database modeling & design.</subfield><subfield code="b">4th ed.</subfield><subfield code="d">Amsterdam : Elsevier ; Boston : Morgan Kaufmann Publishers, 2005</subfield><subfield code="z">0126853525</subfield><subfield code="z">9780126853520</subfield><subfield code="w">(DLC) 2005052013</subfield><subfield code="w">(OCoLC)61169898</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Morgan Kaufmann series in data management systems.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n90627178</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=187205</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">187205</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">96150</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">2551326</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| genre | Problems and Exercises https://id.nlm.nih.gov/mesh/D020497 exercise books. aat Problems and exercises fast Problems and exercises. lcgft http://id.loc.gov/authorities/genreForms/gf2014026154 Problèmes et exercices. rvmgf |
| genre_facet | Problems and Exercises exercise books. Problems and exercises Problems and exercises. Problèmes et exercices. |
| id | ZDB-4-EBA-ocn123570185 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:16:02Z |
| institution | BVB |
| isbn | 9780080470771 0080470777 9780126853520 0126853525 |
| language | English |
| oclc_num | 123570185 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (xviii, 275 pages) : illustrations |
| psigel | ZDB-4-EBA |
| publishDate | 2005 |
| publishDateSearch | 2006 |
| publishDateSort | 2006 |
| publisher | Elsevier ; Morgan Kaufmann Publishers, |
| record_format | marc |
| series | Morgan Kaufmann series in data management systems. |
| series2 | Morgan Kaufmann series in data management systems |
| spelling | Teorey, Toby J. http://id.loc.gov/authorities/names/n81145227 Database modeling & design : logical design / Tobey Teorey, Sam Lightstone, Tom Nadeau. Database modeling and design 4th ed. Amsterdam : Elsevier ; Boston : Morgan Kaufmann Publishers, 2005. 1 online resource (xviii, 275 pages) : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier Morgan Kaufmann series in data management systems Includes bibliographical references and index. Print version record. 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. Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs? In the extensively revised fourth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you'll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems: a detailed look at the Unified Modeling Language (UML-2) as well as the entity-relationship (ER) approach for data requirements specification and conceptual modeling--with examples throughout the book in both approaches; the details and examples of how to use data modeling concepts in logical database design, and the transformation of the conceptual model to the relational model and to SQL syntax; the fundamentals of database normalization through the fifth normal form; practical coverage of the major issues in business intelligence--data warehousing, OLAP for decision support systems, and data mining; examples for how to use the most popular CASE tools to handle complex data modeling problems; exercises that test understanding of all material, plus solutions for many exercises. Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Database design. http://id.loc.gov/authorities/subjects/sh88004472 Database design Problems, exercises, etc. Distributed databases. http://id.loc.gov/authorities/subjects/sh88000865 Data structures (Computer science) http://id.loc.gov/authorities/subjects/sh85035862 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 Relational databases. blmlsh Database design. blmlsh Distributed databases fast Data structures (Computer science) fast Database design fast Relational databases fast Banco de dados (projeto) larpcal Modelagem de dados. larpcal Problems and Exercises https://id.nlm.nih.gov/mesh/D020497 exercise books. aat Problems and exercises fast Problems and exercises. lcgft http://id.loc.gov/authorities/genreForms/gf2014026154 Problèmes et exercices. rvmgf Lightstone, Sam. Nadeau, Tom. Print version: Teorey, Toby J. Database modeling & design. 4th ed. Amsterdam : Elsevier ; Boston : Morgan Kaufmann Publishers, 2005 0126853525 9780126853520 (DLC) 2005052013 (OCoLC)61169898 Morgan Kaufmann series in data management systems. http://id.loc.gov/authorities/names/n90627178 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=187205 Volltext |
| spellingShingle | Teorey, Toby J. Database modeling & design : logical design / Morgan Kaufmann series in data management systems. 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. Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Database design. http://id.loc.gov/authorities/subjects/sh88004472 Database design Problems, exercises, etc. Distributed databases. http://id.loc.gov/authorities/subjects/sh88000865 Data structures (Computer science) http://id.loc.gov/authorities/subjects/sh85035862 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 Relational databases. blmlsh Database design. blmlsh Distributed databases fast Data structures (Computer science) fast Database design fast Relational databases fast Banco de dados (projeto) larpcal Modelagem de dados. larpcal |
| subject_GND | http://id.loc.gov/authorities/subjects/sh86007768 http://id.loc.gov/authorities/subjects/sh88004472 http://id.loc.gov/authorities/subjects/sh88000865 http://id.loc.gov/authorities/subjects/sh85035862 https://id.nlm.nih.gov/mesh/D020497 http://id.loc.gov/authorities/genreForms/gf2014026154 |
| 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 | Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Database design. http://id.loc.gov/authorities/subjects/sh88004472 Database design Problems, exercises, etc. Distributed databases. http://id.loc.gov/authorities/subjects/sh88000865 Data structures (Computer science) http://id.loc.gov/authorities/subjects/sh85035862 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 Relational databases. blmlsh Database design. blmlsh Distributed databases fast Data structures (Computer science) fast Database design fast Relational databases fast Banco de dados (projeto) larpcal Modelagem de dados. larpcal |
| topic_facet | Relational databases. Database design. Database design Problems, exercises, etc. Distributed databases. Data structures (Computer science) 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. Distributed databases Database design Relational databases Banco de dados (projeto) Modelagem de dados. Problems and Exercises exercise books. Problems and exercises Problems and exercises. Problèmes et exercices. |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=187205 |
| work_keys_str_mv | AT teoreytobyj databasemodelingdesignlogicaldesign AT lightstonesam databasemodelingdesignlogicaldesign AT nadeautom databasemodelingdesignlogicaldesign AT teoreytobyj databasemodelinganddesign AT lightstonesam databasemodelinganddesign AT nadeautom databasemodelinganddesign |