Instruction Manual for Database Systems Design Implementation Management 12th edition by Carlos Coronel, Steven Morris ISBN 1305886841 9781305886841

Instruction Manual for Database Systems Design Implementation Management 12th edition by Carlos Coronel, Steven Morris – Ebook PDF Instant Download/Delivery:  1305886841 , 9781305886841
Full download Database Systems Design Implementation Management 12th edition after payment

Product details:

ISBN 10: 1305886841
ISBN 13: 9781305886841
Author: Carlos Coronel, Steven Morris

Readers gain a solid foundation in database design and implementation with the practical and easy-to-understand approach in DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, 12E. Filled with diagrams, illustrations, and tables, this market-leading text provides in-depth coverage of database design. Readers learn the key to successful database implementation: proper design of databases to fit within a larger strategic view of the data environment. Renowned for its clear, straightforward writing style, this text provides an outstanding balance of theory and practice. Updates include the latest coverage of cloud data services and a new chapter on Big Data Analytics and NoSQL, including related Hadoop technologies. In addition, new review questions, problem sets, and cases offer multiple opportunities to test understanding and develop useful design skills.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Database Systems Design Implementation Management 12th Table of contents:

Part 1: Database Concepts

Ch 1: Database Systems

Ch 1: In This Chapter, You Will Learn

Ch 1: Preview

Ch 1: Data Files and Available Formats

1-1: Why Databases?

1-2: Data versus 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

Ch 1: Summary

Ch 1: Key Terms

Ch 1: Review Questions

Ch 1: Problems

Ch 2: Data Models

Ch 2: In This Chapter, You Will Learn

Ch 2: Preview

Ch 2: Data Files and Available Formats

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

Ch 2: Summary

Ch 2: Key Terms

Ch 2: Review Questions

Ch 2: Problems

Part 2: Design Concepts

Ch 3: The Relational Database Model

Ch 3: In This Chapter, You Will Learn

Ch 3: Preview

Ch 3: Data Files and Available Formats

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

Ch 3: Summary

Ch 3: Key Terms

Ch 3: Review Questions

Ch 3: Problems

Ch 4: Entity Relationship (ER) Modeling

Ch 4: In This Chapter, You Will Learn

Ch 4: Preview

Ch 4: Data Files and Available Formats

4-1: The Entity Relationship Model (ERM)

4-2: Developing an ER Diagram

4-3: Database Design Challenges: Conflicting Goals

Ch 4: Summary

Ch 4: Key Terms

Ch 4: Review Questions

Ch 4: Problems

Ch 4: Cases

Ch 5: Advanced Data Modeling

Ch 5: In This Chapter, You Will Learn

Ch 5: Preview

Ch 5: Data Files and Available Formats

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

Ch 5: Summary

Ch 5: Key Terms

Ch 5: Review Questions

Ch 5: Problems

Ch 5: Cases

Ch 6: Normalization of Database Tables

Ch 6: In This Chapter, You Will Learn

Ch 6: Preview

Ch 6: Data Files and Available Formats

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

Ch 6: Summary

Ch 6: Key Terms

Ch 6: Review Questions

Ch 6: Problems

Part 3: Advanced Design and Implementation

Ch 7: Introduction to Structured Query Language (SQL)

Ch 7: In This Chapter, You Will Learn

Ch 7: Preview

Ch 7: Data Files and Available Formats

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

Ch 7: Summary

Ch 7: Key Terms

Ch 7: Review Questions

Ch 7: Problems

Ch 7: Cases

Ch 8: Advanced SQL

Ch 8: In This Chapter, You Will Learn

Ch 8: Preview

Ch 8: Data Files and Available Formats

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: Sequences

8-7: Procedural SQL

8-8: Embedded SQL

Ch 8: Summary

Ch 8: Key Terms

Ch 8: Review Questions

Ch 8: Problems

Ch 8: Cases

Ch 9: Database Design

Ch 9: In This Chapter, You Will Learn

Ch 9: Preview

Ch 9: Note

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 Versus Decentralized Design

Ch 9: Summary

Ch 9: Key Terms

Ch 9: Review Questions

Ch 9: Problems

Part 4: Advanced Database Concepts

Ch 10: Transaction Management and Concurrency Control

Ch 10: In This Chapter, You Will Learn

Ch 10: Preview

Ch 10: Data Files and Available Formats

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

Ch 10: Summary

Ch 10: Key Terms

Ch 10: Review Questions

Ch 10: Problems

Ch 11: Database Performance Tuning and Query Optimization

Ch 11: In This Chapter, You Will Learn

Ch 11: Preview

Ch 11: Data Files and Available Formats

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

Ch 11: Summary

Ch 11: Key Terms

Ch 11: Review Questions

Ch 11: Problems

Ch 12: Distributed Database Management Systems

Ch 12: In This Chapter, You Will Learn

Ch 12: Preview

Ch 12: Data Files and Available Formats

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: C. J. Date’s 12 Commandments for Distributed Databases

Ch 12: Summary

Ch 12: Key Terms

Ch 12: Review Questions

Ch 12: Problems

Ch 13: Business Intelligence and Data Warehouses

Ch 13: In This Chapter, You Will Learn

Ch 13: Preview

Ch 13: Data Files and Available Formats

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: Online Analytical Processing

13-7: SQL Extensions for OLAP

Ch 13: Summary

Ch 13: Key Terms

Ch 13: Review Questions

Ch 13: Problems

Ch 14: Big Data Analytics and NoSQL

Ch 14: In This Chapter, You Will Learn

Ch 14: Preview

Ch 14: Note

14-1: Big Data

14-2: Hadoop

14-3: NoSQL

14-4: Data Analytics

Ch 14: Summary

Ch 14: Key Terms

Ch 14: Review Questions

Part 5: Databases and the Internet

Ch 15: Database Connectivity and Web Technologies

Ch 15: In This Chapter, You Will Learn

Ch 15: Preview

Ch 15: Data Files and Available Formats

15-1: Database Connectivity

15-2: Database Internet Connectivity

15-3: Extensible Markup Language (XML)

15-4: Cloud Computing Services

Ch 15: Summary

Ch 15: Key Terms

Ch 15: Review Questions

Ch 15: Problems

Part 6: Database Administration

Ch 16: Database Administration and Security

Ch 16: In This Chapter, You Will Learn

Ch 16: Preview

Ch 16: Note

16-1: Data as a Corporate Asset

16-2: The Need for a Database and its Role in an Organization

16-3: Introduction of a Database: Special Considerations

16-4: The Evolution of Database Administration

16-5: The Database Environment’s Human Component

16-6: Security

16-7: Database Administration Tools

16-8: Developing a Data Administration Strategy

16-9: The DBA’s Role in the Cloud

16-10: The DBA at Work: Using Oracle for Database Administration

Ch 16: Summary

Ch 16: Key Terms

Glossary

Index

People also search for Database Systems Design Implementation Management 12th:

database systems design implementation & management 13th edition

database systems design implementation & management 14th edition

borrow database systems design implementation and management

spatial database systems design implementation and project management

database systems design implementation & management 14th edition answers

Tags: Carlos Coronel, Steven Morris, Database Systems, Implementation Management