Prospect Press eTextbooks are distributed through VitalSource. Print copies are now available on Amazon.
RedShelf, one of our former distributors, is no longer in business. VitalSource is committed to honoring any extended access you previously purchased from RedShelf.

Database Systems

Database Systems

Introduction to Databases and Data Warehouses

Edition 2 | Copyright 2021 | Publication Date: April 2020

Nenad Jukić, Loyola University Chicago
Susan Vrbsky, University of Alabama
Svetlozar Nestorov, Loyola University Chicago
Rekha Sharma, Hewlett Packard Enterprise

Overview


Database Systems: Introduction to Databases and Data Warehouses covers the design and use of both operational and analytical database systems in detail. A solid theoretical foundation and meaningful hands-on experiences are provided. This understanding prepares students to apply their knowledge in today's business environments.

 

For additional videos and content about the textbook, click on a subject below:

 

Features


Experience logical step-by-step coverage
Clear and straightforward coverage of topics that successively build on each other.

Solidify knowledge with examples, mini cases, and exercises
Numerous easy-to-understand examples, mini-cases, and hands-on exercises cement understanding of each topic introduced.

Save time with running examples
The ZAGI Retail Company Sales Department Database Example is used to illustrate the main concepts for both operational databases and data warehouses. Use of a running example enables quick and straightforward coverage, because students are already familiar with the details of the case.

Free software
Access ERDPlus, a free, easy-to-use, web-based, data modeling suite designed for use in conjunction with this textbook.



New in Edition 2.0


Online videos
As more classes are being offered remotely in these challenging time, the need for online resources has been increasing. A series of videos that introduce each chapter are available for the book.

Up-to-date coverage
Exercises, problems, and cases studies have been updated to assure current relevance.

New topics
A chapter on big data and data lakes has been added. Appendices have been updated to cover additional topics including stored procedures, functions, and blockchain.

 

Table of Contents


Detailed Table of Contents PDF
  • Chapter 1: Introduction

Part 1: Operational Databases
Chapter 2: Database Requirements and ER Modeling
Chapter 3: Relational Database Modeling
Chapter 4: Update Operations, Update Anomalies, and Normalization
Chapter 5: SQL
Chapter 6: Database Implementation and Use

Part 2: Analytical Databases
Chapter 7: Data Warehousing Concepts
Chapter 8: Data Warehouse Modeling
Chapter 9: Data Warehouse Implementation and Use
Chapter 10: Big Data and Data Lakes

Part 3: Other Topics
Chapter 11: Overview of DBMS Functionalities and Database Administration

Part 4: Appendices
Appendix 1: Enhanced ER
Appendix 2: Further Notes on Normalization and Higher Normal Forms
Appendix 3: Enterprise Resource Planning (ERP)
Appendix 4: Data Governance and Master Data Management
Appendix 5: Object-Oriented Databases
Appendix 6: Assertions, Triggers, Stored Procedures and Functions
Appendix 7: Distributed Databases, Blockchain, Parallel Databases, and Cloud Computing
Appendix 8: Data Mining
Appendix 9: XML Markup Languages
Appendix 10: NoSQL Databases

About the Authors


Nenad Jukić teaches undergraduate, graduate, and executive and professional education classes at the Quinlan School of Business of Loyola University of Chicago. His classes cover databases, data warehousing, business intelligence, computer programming, business computer applications, and health care information systems.

Dr. Jukić was named Loyola’s Faculty Member of the Year, Quinlan’s Outstanding Undergraduate Teacher of the Year and has twice been recognized as Quinlan’s top researcher. He is also the founder of ERDPlus.com, a widely used web tool for database modeling. His research focuses on database modeling and management, data warehousing, business intelligence, data mining, business analytics, Big Data, e-business, and IT strategy. He earned his Ph.D. in Computer Science from The University of Alabama in 1997.

Nenad Jukić

Susan V. Vrbsky is an associate professor and interim department head of Computer Science at the University of Alabama. Dr. Vrbsky is the director of the Cloud and Cluster Computing Laboratory. Her research has explored topics including data intensive computing, real-time databases, database security, mobile databases, and green computing. She has co-authored over 100 peer-reviewed publications.

Susan Vrbsky

Svetlozar Evtimov Nestorov is an Assistant Professor in the Quinlan School of Business at Loyola University Chicago. His research and teaching focus on data mining, data warehousing, and web technologies.

Svetlozar Nestorov


Instructor Resources


Prospect Press provides instructors with an instructor manual, lecture slides and a test bank for each title. Some texts have additional resources including case teaching notes, tutorials, and addenda.

This content is available to instructors only and is password protected.

Resources Login

Current Edition


Database Systems:
Introduction to Databases and Data Warehouses

Edition 3.0
Copyright 2026
Publication date: September 2025

Nenad Jukić, Loyola University Chicago

View Current Edition

Previous Editions


Database Systems: Introduction to Databases and Data Warehouses

Database Systems: Introduction to Databases and Data Warehouses

Nenad Jukić, Loyola University Chicago
Susan Vrbsky, University of Alabama
Svetlozar Nestorov, Loyola University Chicago

Edition 1
Copyright 2017
Publication date: June 13, 2016

View Previous Edition

 

Videos

Free Resources for the Database Course
The Data Analytics Curriculum

Ordering Information

Student Orders

eTextbooks:
Student Price
$54.85
ISBN: 978-1-943153-67-1
Paperbacks:
Student Price
$89.10 + shipping
ISBN: 978-1-943153-68-8

Order directly from our distributors:

Bulk eTextbook Orders
Bookstores may order eTextbooks from

 

Bulk Paperback Orders
Bookstores may order paperbacks from Ingram/Lightning Source via iPage. Note that all paperbacks are print-on-demand and are not returnable.

If you have questions about bookstore orders, please contact Beth.Golub@ProspectPressVT.com or call 802-862-4684.

 

Frequently Asked Questions

Paperback Orders

Libraries may order paperbacks from Ingram/Lightning Source via iPage. Note that all paperbacks are print-on-demand and are not returnable

If you have questions about library orders, please contact Beth.Golub@ProspectPressVT.com or call 802-862-4684.

 

VitalSource VS RedShelf

 
RedShelf eTextbook
VitalSource eTextbook
Online or download
Online only
Online and Download
Duration?
Permanent online access
365-day access for online, perpetual download
Returnable?
Yes, within 14 days from purchase
Yes, within 14 days from purchase
Where can I buy this online?
Go to RedShelf.com and search by author name, title, or ISBN.
Go to VitalSource.com and search by author name, title, or ISBN
Can I buy this in the campus bookstore?
Yes, at selected campus and university bookstores. Check if your bookstore sells RedShelf ebooks.
Yes, at selected campus bookstores. Check if your bookstore sells VitalSource ebooks.
For more info: