Jukić: Database Systems: Introduction to Databases and Data Warehouses

Database Systems

Database Systems

Introduction to Databases and Data Warehouses

Edition 3.0 | Copyright 2026 | Publication Date: September 2025

Nenad Jukić, Loyola University Chicago

Instructors:
Order a Review Copy

Students:
Buy Now

Bookstore Orders

Library Orders

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.

Edition 3.0 includes more coverage of SQL. Additionally, ERDPlus (free web-based software) now allows students to run SQL queries on the preloaded datasets from the book. To that end, a third running review example has been added for additional and varied practice opportunities.

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.

Introduce material with 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.

Optionally cover advanced topics
Appendices provided cover additional topics including stored procedures, functions, and blockchain.

New in Edition 3.0

Provide increased emphasis on SQL
SQL coverage has been expanded. More and varied exercises have been included.

Enjoy integrated exercises and software
The new version of ERDPlus can run the SQL queries from the book. To this end, the datasets from the book have been preloaded into ERDPlus. Thus, instructors do not need to maintain their own SQL software; except if they wish to provide practice with the CREATE TABLE statement.

Explore the impact of AI
Database practitioners will still need the basic skills covered in this book to know if what gets produced from AI is good enough and to revise the software when need. This is discussed in an article "How does AI affect database design and use" that accompanies the book.

Vary practice activity
A new running case has been added to provide additional or varied practice.

Experience up-to-date coverage
Exercises, problems, and cases studies have been updated to assure current relevance. Coverage of big data and data lakes have been streamlined for more approachable coverage.

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

Articles on the following topics are available at the
Instructor and Student Resources sites to supplement the chapters

• Enhanced ER Modeling (EER)
• Further Notes on Normalization and Higher Normal Forms
• Enterprise Resource Planning (ERP)
• Data Governance and Master Data Management
• Further Notes on SQL Windows Functions
• Data Mining
• NoSQL Databases

About the Author

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. His research focuses on database modeling and management, data warehousing, business intelligence, data mining, business analytics, Big Data, e-business, and IT strategy.

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

Student Resources

Supplementary Articles

The articles below will be available soon.

Article 1: Enhanced ER Modeling (EER)

Nenad Jukić, Loyola University Chicago

Article 2: Further Notes on Normalization and Higher Normal Forms

Nenad Jukić, Loyola University Chicago

Kornelije Rabuzin, University of Zagreb

Article 3: Enterprise Resource Planning (ERP)

Nenad Jukić, Loyola University Chicago

Article 4: Data Governance and Master Data Management

Nenad Jukić, Loyola University Chicago

Article 5: Further Notes on SQL Windows Functions

Sippo Rossi, Hanken School of Economics

Article 6: Assertions, Triggers, Stored Procedures, and Functions

Abhishek Sharma, Loyola University Chicago

Svetlozar Nestorov, Loyola University Chicago

Article 7: Distributed Databases, Blockchain, Parallel Databases, and Cloud Computing

Abhishek Sharma, Loyola University Chicago

Svetlozar Nestorov, Loyola University Chicago

Nenad Jukić, Loyola University Chicago

Article 8: Data Mining

Svetlozar Nestorov, Loyola University Chicago

Nenad Jukić, Loyola University Chicago

Article 9: HTML, XML, and JSON

Abhishek Sharma, Loyola University Chicago

Nenad Jukić, Loyola University Chicago

Article 10: NoSQL Databases

Svetlozar Nestorov, Loyola University Chicago

Abhishek Sharma, Loyola University Chicago

Sippo Rossi, Hanken School of Economics

Article 11: Influence of AI on Database Modeling and Use

Nenad Jukić, Loyola University Chicago

Previous Editions

Database Systems: Introduction to Databases and Data Warehouses

Database Systems

Introduction to Databases and Data Warehouses

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

Edition 2.0
Copyright 2021
Publication date: April 15, 2020

View Previous Edition

Database Systems: Introduction to Databases and Data Warehouses

Database Systems: Introduction to Databases and Data Warehouses

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

Edition 1.0
Copyright 2017
Publication date: June 13, 2016

View Previous Edition

Videos

1-0

10-0

11-0

2-1

2-2

2-3

2-4

3-1

3-2

3-3

3-4

3-5

4-1

4-2

4-3

4-4

5-1

5-2

5-3

5-4

5-5

5-6

6-1

6-2

7-1

7-2

8-1

8-2

8-3

9-1

9-2

Ordering Information

Student Orders

eTextbooks:
Student Price
$65.80
ISBN: 978-1-958303-28-3

Paperbacks:
Student Price
$114.30 + shipping
ISBN: 978-1-958303-29-0

Order directly from our distributors:

RedShelf

Order eTextbook or Paperback

Order eTextbook

What's the difference between these two?

Bookstore Orders

Library Orders

Bulk eTextbook Orders
Bookstores may order eTextbooks in bulk directly from RedShelf or VitalSource. Please contact customer support for additional information.

RedShelf: PO@RedShelf.com
VitalSource: VitalSource Bulk Order

Bulk Paperback Orders
Bookstores may order paperbacks in bulk directly from RedShelf by going to the following link. Please contact customer support for additional information.

RedShelf: RedShelf Print Orders

BNED stores
Follow your usual ordering procedures.

Frequently Asked Questions

Individual Paperback Orders
To purchase an individual book, go to the Prospect Press webpage for that book and follow the link to RedShelf or go directly to the RedShelf website using the link below, search for the title, and order there.

Bulk Paperback Orders
To purchase paperbacks in bulk contact RedShelf using the link below:
PO@Redshelf.com

If you have any particular questions about bookstore orders please contact Beth.Golub@ProspectPressVT.com.

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:

VitalSource.com

FAQs

https://www.about.RedShelf.com/

http://store.VitalSource.com/store/about_bookshelf