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...
Saved in:
| Main Author: | |
|---|---|
| Other Authors: | , |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Amsterdam : Boston :
Elsevier ; Morgan Kaufmann Publishers,
2005.
|
| Edition: | 4th ed. |
| Series: | Morgan Kaufmann series in data management systems.
|
| Subjects: | |
| Online Access: | CONNECT |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | mig00005424233 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 070426s2006 ne a ob 001 0 eng d | ||
| 005 | 20240612131313.5 | ||
| 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 1WRLDSHRocn123570185 | ||
| 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 | ||
| 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 | ||
| 049 | |a TXMM | ||
| 050 | 4 | |a QA76.9.D26 |b T45 2006eb | |
| 082 | 0 | 4 | |a 005.75/6 |2 22 |
| 100 | 1 | |a Teorey, Toby J. | |
| 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. | ||
| 500 | |a EBSCO eBook Academic Comprehensive Collection North America |5 TMurS | ||
| 650 | 0 | |a Relational databases. | |
| 650 | 0 | |a Database design. | |
| 650 | 0 | |a Database design |v Problems, exercises, etc. | |
| 650 | 0 | |a Distributed databases. | |
| 650 | 0 | |a Data structures (Computer science) | |
| 655 | 7 | |a exercise books. |2 aat | |
| 655 | 7 | |a Problems and exercises |2 fast | |
| 655 | 7 | |a Problems and exercises. |2 lcgft | |
| 700 | 1 | |a Lightstone, Sam. | |
| 700 | 1 | |a Nadeau, Tom. | |
| 730 | 0 | |a WORLDSHARE SUB RECORDS | |
| 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. | |
| 856 | 4 | 0 | |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=187205&authtype=ip,sso&custid=s4672406 |z CONNECT |3 eBooks on EBSCOhost |t 0 |
| 907 | |a 4700510 |b 05-21-21 |c 07-04-20 | ||
| 949 | |a ho0 | ||
| 994 | |a 92 |b TXM | ||
| 998 | |a wi |d z | ||
| 999 | f | f | |s 49bdd1c0-e751-4c3b-89f4-eb9b2431922a |i 1f95ac74-922e-4395-8b70-74b7b3889594 |t 0 |
| 952 | f | f | |a Middle Tennessee State University |b Main |c James E. Walker Library |d Electronic Resources |t 0 |e QA76.9.D26 T45 2006eb |h Library of Congress classification |
