Title: Fundamentals of Database Management Systems (2nd Edition)

The author: Mark L. Gillenson

File format: PDF

Book volume: 416 Pages

File size: 12.8 MB

Content:

DATA: THE NEW CORPORATE RESOURCE

  • The History of Data
  • Data in Today‚Äôs Information Systems Environment

DATA MODELING

  • Binary, Unary and Ternary Relationships with Examples

THE DATABASE MANAGEMENT SYSTEM CONCEPT

  • Data Before Database Management
  • The Database Concept and DBMS Approaches

RELATIONAL DATA RETRIEVAL: SQL

  • Data Retrieval with the SQL SELECT Command with Examples
  • Grouping Rows, The Join and Subqueries

THE RELATIONAL DATABASE MODEL: INTRODUCTION

  • The Relational Database Concept with Primary, Candidate and Foreign Keys
  • Data Retrieval from a Relational Database with Select and Project Operator

THE RELATIONAL DATABASE MODEL: ADDITIONAL CONCEPTS

  • Relational Structures for Unary (One-to-Many and Many-to-Many) and Ternary Relationships
  • Referential Integrity and Three Delete Rules

LOGICAL DATABASE DESIGN

  • Converting E-R Diagrams into Relational Tables with Examples
  • The Data Normalization Process with Examples
  • Building the Data Structure with SQL and Manipulating the Data with SQL

PHYSICAL DATABASE DESIGN

  • Need for Disk Storage
  • File Organizations and Access Methods
  • Physical Database Design Techniques with Examples

OBJECT-ORIENTED DATABASE MANAGEMENT

  • Generalization, Inheritance of Operations, Polymorphism and Aggregation
  • Encapsulation, Abstract Data Types

DATA ADMINISTRATION, DATABASE ADMINISTRATION, AND DATA DICTIONARIES

DATABASE CONTROL ISSUES: SECURITY, BACKUP AND RECOVERY, CONCURRENCY

CLIENT/SERVER DATABASE AND DISTRIBUTED DATABASE

THE DATA WAREHOUSE

  • Characteristics of Data in The Data Warehouse Concept
  • Types of Data Warehouses
  • Designing, Building, Using and Administering a Data Warehouse
  • Challenges in Data Warehousing

DATABASES AND THE INTERNET

  • Database Control Issues
  • Data Extraction into XML

eBook download