Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Database modeling & design [[electronic resource] ] : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau
| Database modeling & design [[electronic resource] ] : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau |
| Autore | Teorey Toby J |
| Edizione | [4th ed.] |
| Pubbl/distr/stampa | Amsterdam, : Elsevier |
| Descrizione fisica | 1 online resource (294 p.) |
| Disciplina | 005.75/6 |
| Altri autori (Persone) |
LightstoneSam
NadeauTom <1958-> |
| Collana | The Morgan Kaufmann Series in Data Management Systems |
| Soggetto topico |
Relational databases
Database design |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-280-96150-3
9786610961504 0-08-047077-7 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
front cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 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 Notations2.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 Usage3.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 Models4.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 Transformation5.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 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF 6.5.4 Fifth Normal Form |
| Record Nr. | UNINA-9910458109403321 |
Teorey Toby J
|
||
| Amsterdam, : Elsevier | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Database modeling & design [[electronic resource] ] : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau
| Database modeling & design [[electronic resource] ] : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau |
| Autore | Teorey Toby J |
| Edizione | [4th ed.] |
| Pubbl/distr/stampa | Amsterdam, : Elsevier |
| Descrizione fisica | 1 online resource (294 p.) |
| Disciplina | 005.75/6 |
| Altri autori (Persone) |
LightstoneSam
NadeauTom <1958-> |
| Collana | The Morgan Kaufmann Series in Data Management Systems |
| Soggetto topico |
Relational databases
Database design |
| ISBN |
1-280-96150-3
9786610961504 0-08-047077-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
front cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 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 Notations2.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 Usage3.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 Models4.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 Transformation5.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 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF 6.5.4 Fifth Normal Form |
| Record Nr. | UNINA-9910784564903321 |
|
Teorey Toby J
|
||
| Amsterdam, : Elsevier | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Database modeling & design : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau
| Database modeling & design : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau |
| Autore | Teorey Toby J |
| Edizione | [4th ed.] |
| Pubbl/distr/stampa | Amsterdam, : Elsevier |
| Descrizione fisica | 1 online resource (294 p.) |
| Disciplina | 005.75/6 |
| Altri autori (Persone) |
LightstoneSam
NadeauTom <1958-> |
| Collana | The Morgan Kaufmann Series in Data Management Systems |
| Soggetto topico |
Relational databases
Database design |
| ISBN |
1-280-96150-3
9786610961504 0-08-047077-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
front cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 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 Notations2.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 Usage3.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 Models4.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 Transformation5.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 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF 6.5.4 Fifth Normal Form |
| Altri titoli varianti | Database modeling and design |
| Record Nr. | UNINA-9910825615203321 |
|
Teorey Toby J
|
||
| Amsterdam, : Elsevier | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Proceedings of the 1981 ACM SIGMOD International Conference on Management of Data
| Proceedings of the 1981 ACM SIGMOD International Conference on Management of Data |
| Autore | Teorey Toby J |
| Pubbl/distr/stampa | [Place of publication not identified], : ACM, 1981 |
| Descrizione fisica | 1 online resource (237 pages) |
| Collana | ACM Conferences |
| Soggetto topico |
Engineering & Applied Sciences
Computer Science |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Altri titoli varianti |
Proceedings of the 1981 Association for Computing Machinery Special Interest Group on Management of Data International Conference on Management of Data
SIGMOD '81 Proceedings of the 1981 ACM SIGMOD International Conference on Management of Data |
| Record Nr. | UNINA-9910375990003321 |
|
Teorey Toby J
|
||
| [Place of publication not identified], : ACM, 1981 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||