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