In the newly revised third edition of Fundamentals of Database Management Systems, veteran database expert Dr. Mark Gillenson delivers an authoritative and comprehensive account of contemporary database management. The Third Edition assists readers in understanding critical topics in the subject, including data modeling, relational database concepts, logical and physical database design, SQL, data administration, data security, NoSQL, blockchain, database in the cloud, and more.
The author offers a firm grounding in the fundamentals of database while, at the same time, providing a wide-ranging survey of database subfields relevant to information systems professionals. And, now included in the supplements, the author's audio narration of the included PowerPoint slides! Readers will also find:
- Brand-new content on NoSQL database management, NewSQL, blockchain, and database-intensive applications, including data analytics, ERP, CRM, and SCM
- Updated and revised narrative material designed to offer a friendly introduction to database management
- Renewed coverage of cloud-based database management
- Extensive updates to incorporate the transition from rotating disk secondary storage to solid state drives
Table of Contents
Preface xix
About The Author xxiii
1 Data: The New Corporate Resource 1
2 Data Modeling 16
3 The Database Management System Concept 36
4 Relational Data Retrieval: SQL 59
5 The Relational Database Model: Introduction 95
6 The Relational Database Model: Additional Concepts 127
7 Logical Database Design 145
8 Physical Database Design 185
9 Object-Oriented Database Management 229
10 Data Administration, Database Administration, and Data Dictionaries 248
11 Database Control Issues: Security, Backup and Recovery, Concurrency 268
12 The Data Warehouse 289
13 NoSQL Database Management 319
14 Blockchain 341
15 Database in the Cloud 352
16 Database Applications 363
Index I-1
