Database Systems

Database Systems

Introduction to Databases and Data Warehouses

Edition 2.0 | Copyright 2021 | Publication Date: April 2020

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

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

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

Abishek Sharma teaches in the Quinlan School of Business at Loyola University Chicago. He is also CEO of Awishkar Consulting Company that provides complete consulting services regarding implementation of technology and strategic consulting for data driven leadership to solve business problems.

Abhishek Sharma

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

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

Edition 1.0
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:

What's the difference between these two?

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: