Relational database design and implementation
Relational Database Design and Implementation: Clearly Explained, Fourth Edition , provides the conceptual and practical information necessary to develop a database design and management scheme that ensures data accuracy and user satisfaction while optimizing performance. Database systems underlie t...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Amsterdam, [Netherlands] :
Morgan Kaufmann
2016.
|
| Edición: | 4th ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630197306719 |
Tabla de Contenidos:
- Cover; Title Page; Copyright Page; Contents; Preface to the Fourth Edition; Changes in the Fourth Edition; What You Need to Know; Teaching Materials; Acknowledgments; Part I - Introduction; Chapter 1 - The Database Environment; Defining a Database; Lists and Files; Databases; Systems that Use Databases; Data "Ownership"; Service-Oriented Architecture (SOA); Database Software: DBMSs; Database Hardware Architecture; Centralized; Client/Server; Distributed; Web; Remote Access; Cloud Storage; Advantages of Cloud Storage; Problems with Cloud Storage; Other Factors in the Database Environment
- SecurityGovernment Regulations and Privacy; Legacy Databases; Open Source Relational DBMSs; For Further Reading; Chapter 2 - Systems Analysis and Database Requirements; Dealing with Resistance to Change; The Structured Design Life Cycle; Conducting the Needs Assessment; Assessing Feasibility; Generating Alternatives; Evaluating and Choosing an Alternative; Creating Design Requirements; Alternative Analysis Methods; Prototyping; Spiral Methodology; Object-Oriented Analysis; For Further Reading; Part II - Relational Database Design Theory; Chapter 3 - Why Good Design Matters
- Effects of Poor Database DesignUnnecessary Duplicated Data and Data Consistency; Data Insertion Problems; Data Deletion Problems; Meaningful Identifiers; The Bottom Line; Chapter 4 - Entities and Relationships; Entities and Their Attributes; Entity Identifiers; Single-Valued Versus Multivalued Attributes; Avoiding Collections of Entities; Documenting Entities and Their Attributes; Entities and Attributes for Antique Opticals; Domains; Documenting Domains; Practical Domain Choices; Basic Data Relationships; One-to-One Relationships; One-to-Many Relationships; Many-to-Many Relationships
- Weak Entities and Mandatory RelationshipsDocumenting Relationships; The Chen Method; IE Style Diagrams; UML Style Diagrams; Basic Relationships for Antique Opticals; Dealing with Many-to-Many Relationships; Composite Entities; Documenting Composite Entities; Resolving Antique Opticals' Many-to-Many Relationships; N-Way Composite Entities; Relationships and Business Rules; Data Modeling Versus Data Flow; Schemas; For Further Reading; Chapter 5 - The Relational Data Model; Understanding Relations; Columns and Column Characteristics; Rows and Row Characteristics; Types of Tables
- A Notation for RelationsPrimary Keys; Primary Keys to Identify People; Avoiding Meaningful Identifiers; Concatenated Primary Keys; All-Key Relations; Representing Data Relationships; Referential Integrity; Concatenated Foreign Keys; Foreign Keys That Reference the Primary Key of Their Own Table; Views; The View Mechanism; Why Use Views?; The Data Dictionary; Sample Data Dictionary Tables; A Bit of History; For Further Reading; Chapter 6 - Relational Algebra; The Relational Algebra and SQL Example Database: Rare Books; The Sample Data; Making Vertical Subsets: Project
- Making Horizontal Subsets: Restrict
