Sale!

Test Bank for Database Systems: Design, Implementation, & Management (11th Edition) by Carlos Coronel

By:  
  • ISBN-10:  1285196147 / ISBN-13:  9781285196145
  • Ebook Details

    • Edition: 11th Edition
    • Format: Downloadable ZIP Fille
    • Resource Type : Testbank
    • Publication: 2014
    • Duration: Unlimited downloads
    • Delivery: Instant Download
     

    $35.00 $30.00

    SKU: ba6659f45d47 Category:

    Table of content:

    Brief Contents
    Table of Contents
    Preface
    Text Features
    Additional Features
    Acknowledgments
    Part I: Database Concepts
    Ch 1: Database Systems
    1.1: Why Databases?
    1.2: Data vs. Information
    1.3: Introducing the Database
    1.4: Why Database Design is Important
    1.5: Evolution of File System Data Processing
    1.6: Problems with File System Data Processing
    1.7: Database Systems
    1.8: Preparing for Your Database Professional Career
    Summary
    Key Terms
    Review Questions
    Problems
    Ch 2: Data Models
    2.1: Data Modeling and Data Models
    2.2: The Importance of Data Models
    2.3: Data Model Basic Building Blocks
    2.4: Business Rules
    2.5: The Evolution of Data Models
    2.6: Degrees of Data Abstraction
    Summary
    Key Terms
    Review Questions
    Problems
    Part II: Design Concepts
    Ch 3: The Relational Database Model
    3.1: A Logical View of Data
    3.2: Keys
    3.3: Integrity Rules
    3.4: Relational Algebra
    3.5: The Data Dictionary and the System Catalog
    3.6: Relationships within the Relational Database
    3.7: Data Redundancy Revisited
    3.8: Indexes
    3.9: Codd’s Relational Database Rules
    Summary
    Key Terms
    Review Questions
    Problems
    Ch 4: Entity Relationship (ER) Modeling
    4.1: The Entity Relationship Model (ERM)
    4.2: Developing an ER Diagram
    4.3: Database Design Challenges: Conflicting Goals
    Summary
    Key Terms
    Review Questions
    Problems
    Cases
    Ch 5: Advanced Data Modeling
    5.1: The Extended Entity Relationship Model
    5.2: Entity Clustering
    5.3: Entity Integrity: Selecting Primary Keys
    5.4: Design Cases: Learning Flexible Database Design
    Summary
    Key Terms
    Review Questions
    Problems
    Cases
    Ch 6: Normalization of Database Tables
    6.1: Database Tables and Normalization
    6.2: The Need for Normalization
    6.3: The Normalization Process
    6.4: Improving the Design
    6.5: Surrogate Key Considerations
    6.6: Higher-Level Normal Forms
    6.7: Normalization and Database Design
    6.8: Denormalization
    6.9: Data-Modeling Checklist
    Summary
    Key Terms
    Review Questions
    Problems
    Part III: Advanced Design and Implementation
    Ch 7: Introduction to Structured Query Language (SQL)
    7.1: Introduction to SQL
    7.2: Data Definition Commands
    7.3: Data Manipulation Commands
    7.4: Select Queries
    7.5: Additional Data Definition Commands
    7.6: Additional Select Query Keywords
    7.7: Joining Database Tables
    Summary
    Key Terms
    Review Questions
    Problems
    Cases
    Ch 8: Advanced SQL
    8.1: SQL Join Operators
    8.2: Subqueries and Correlated Queries
    8.3: SQL Functions
    8.4: Relational Set Operators
    8.5: Virtual Tables: Creating a View
    8.6: Oracle Sequences
    8.7: Procedural SQL
    8.8: Embedded SQL
    Summary
    Key Terms
    Review Questions
    Problems
    Cases
    Ch 9: Database Design
    9.1: The Information System
    9.2: The Systems Development Life Cycle
    9.3: The Database Life Cycle
    9.4: Conceptual Design
    9.5: DBMS Software Selection
    9.6: Logical Design
    9.7: Physical Design
    9.8: Database Design Strategies
    9.9: Centralized vs. Decentralized Design
    Summary
    Key Terms
    Review Questions
    Problems
    Part IV: Advanced Database Concepts
    Ch 10: Transaction Management and Concurrency Control
    10.1: What is a Transaction?
    10.2: Concurrency Control
    10.3: Concurrency Control with Locking Methods
    10.4: Concurrency Control with Time Stamping Methods
    10.5: Concurrency Control with Optimistic Methods
    10.6: ANSI Levels of Transaction Isolation
    10.7: Database Recovery Management
    Summary
    Key Terms
    Review Questions
    Problems
    Ch 11: Database Performance Tuning and Query Optimization
    11.1: Database Performance-Tuning Concepts
    11.2: Query Processing
    11.3: Indexes and Query Optimization
    11.4: Optimizer Choices
    11.5: SQL Performance Tuning
    11.6: Query Formulation
    11.7: DBMS Performance Tuning
    11.8: Query Optimization Example
    Summary
    Key Terms
    Review Questions
    Problems
    Ch 12: Distributed Database Management Systems
    12.1: The Evolution of Distributed Database Management Systems
    12.2: DDBMS Advantages and Disadvantages
    12.3: Distributed Processing and Distributed Databases
    12.4: Characteristics of Distributed Database Management Systems
    12.5: DDBMS Components
    12.6: Levels of Data and Process Distribution
    12.7: Distributed Database Transparency Features
    12.8: Distribution Transparency
    12.9: Transaction Transparency
    12.10: Performance and Failure Transparency
    12.11: Distributed Database Design
    12.12: The CAP Theorem
    12.13: Hadoop Distributed File System
    12.14: C. J. Date’s 12 Commandments for Distributed Databases
    Summary
    Key Terms
    Review Questions
    Problems
    Ch 13: Business Intelligence and Data Warehouses
    13.1: The Need for Data Analysis
    13.2: Business Intelligence
    13.3: Decision Support Data
    13.4: The Data Warehouse
    13.5: Star Schemas
    13.6: Data Analytics
    13.7: Online Analytical Processing
    13.8: SQL Extensions for OLAP
    Summary
    Key Terms
    Review Questions
    Problems
    Part V: Databases and the Internet
    Ch 14: Database Connectivity and Web Technologies
    14.1: Database Connectivity
    14.2: Database Internet Connectivity
    14.3: Extensible Markup Language (XML)
    14.4: Cloud Computing Services
    Summary
    Key Terms
    Review Questions
    Problems
    Part VI: Database Administration
    Ch 15: Database Administration and Security
    15.1: Data as a Corporate Asset
    15.2: The Need for a Database and Its Role in an Organization
    15.3: Introduction of a Database: Special Considerations
    15.4: The Evolution of Database Administration
    15.5: The Database Environment’s Human Component
    15.6: Security
    15.7: Database Administration Tools
    15.8: Developing a Data Administration Strategy
    15.9: The DBA at Work: Using Oracle for Database Administration
    Summary
    Key Terms
    Review Questions
    Glossary
    Index

    Reviews

    There are no reviews yet.

    Be the first to review “Test Bank for Database Systems: Design, Implementation, & Management (11th Edition) by Carlos Coronel”

    Additional Information


    Resource Type:

    Ebook Title:

    Authors:

    Publisher: