Store

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

By: Carlos Coronel , Steven Morris
ISBN-10: 1285196147
/ ISBN-13: 9781285196145

Study Guide Details

Format: Downloadable ZIP Fille
Authors: Carlos Coronel , Steven Morris
Secure Stripe Payment Logo.png

TEST BANK

$35.00 $30.00

Instant Download to your account.

Description

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:

Related Test Books

Reviews

Your #1 Online Study Guide Resource

* We don’t share your personal info with anyone. Check out our Privacy Policy for more information