Database Systems A Pragmatic Approach
Database Systems: A Pragmatic Approach is a classroom textbook for use by students who are learning about relational databases, and the professors who teach them. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. The...
| Autores principales: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2014.
|
| Edición: | 1st ed. 2014. |
| Colección: | The expert's voice in database Database systems
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629816706719 |
Tabla de Contenidos:
- Contents at a Glance; Contents; About the Authors; Preface; Acknowledgments; Part1: Preliminary Topics; Chapter 1: Introduction to Database Systems; 1.1 Definitions and Rationale; 1.2 Objectives of a Database System; Clarification on Data Independence; 1.3 Advantages of a Database System; 1.4 Approaches to Database Design; 1.5 Desirable Features of a DBS; 1.6 Database Development Life Cycle; 1.7 Summary and Concluding Remarks; 1.8 Review Questions; 1.9 References and/or Recommended Readings; Chapter 2: The Database System Environment; 2.1 Levels of Architecture; 2.1.1 External Level
- 2.1.2 Conceptual Level2.1.3 Internal Level; 2.2 Inter-level Mappings; 2.3 The Database Administrator; 2.4 The Database Management System; 2.5 Components of DBMS Suite; 2.5.1 The DBMS Engine; 2.5.2 Definition Tools Subsystem; 2.5.3 The User Interface Subsystem; 2.5.4 Application Development Subsystem; 2.5.5 Data Administration Subsystem; 2.5.6 Data Dictionary Subsystem; 2.5.7 Data Communications Manager; 2.5.8 Utilities Subsystem; 2.6 The Front-end and Back-end Perspectives; 2.7 Database System Architecture; 2.8 Summary and Concluding Remarks; 2.9 Review Questions
- 2.10 References and/or Recommended ReadingsPart2: The Relational Database Model; Chapter 3: The Relational Model; 3.1 Basic Concepts; 3.2 Domains; Significance of Domains; 3.3 Relations; 3.3.1 Properties of a Relation; 3.3.2 Kinds of Relations; 3.4 Relational Database System; Steps in Building a Relational Database System; 3.5 Identifying, Representing, and Implementing Relationships; 3.5.1 Identifying Relationships; 3.5.2 Representing Relationships; The Entity-Relationship Model; The Object-Relationship Model; Database Tree; Database Networks; 3.5.3 Multiplicity of Relationships
- 3.5.4 Implementing Relationships3.6 The Relation-Attributes List and Relationship List; 3.7 Non-Relational Approaches; 3.8 Summary and Concluding Remarks; 3.9 Review Questions; 3.10 References and/or Recommended Readings; Chapter 4: Integrity Rules and Normalization; 4.1 Fundamental Integrity Rules; 4.2 Foreign Key Concept; Deletion of Referenced Tuples; 4.3 Rationale for Normalization; 4.4 Functional Dependence and Non-loss Decomposition; 4.4.1 Functional Dependence; 4.4.2 Non-loss Decomposition; Corollary of Heath's Theorem; Conclusion; 4.5 The First Normal Form
- Problems with Relations in 1NF Only4.6 The Second Normal Form; Problems with Relations in 2NF Only; 4.7 The Third Normal Form; Problems with Relations in 3NF Only; 4.8 The Boyce-Codd Normal Form; 4.9 The Fourth Normal Form; 4.9.1 Multi-valued Dependency; 4.9.2 Fagin's Theorem; 4.10 The Fifth Normal Form; 4.10.2 Fagin's Theorem; 4.11 Other Normal Forms; 4.11.1 The Domain-Key Normal Form; 4.11.2 The Sixth Normal Form; 4.12 Summary and Concluding Remarks; 4.13 Review Questions; 4.14 References and/or Recommended Readings; Chapter 5: Database Modeling and Design
- 5.1 Database Model and Database Design
