CIS 4720 · Fall 2026

CIS 4720

Database Management and SQL. Chapter reviews, study guides, and worked examples for the section, gathered in one place.

Overview

What's on this page

This page collects everything specific to my CIS 4720 sections, starting with a set of chapter reviews written from Database Systems: Design, Implementation, and Management (14th ed.) by Carlos Coronel and Steven Morris. Each review lines up with a chapter quiz and is meant as a last pass before you take it, not a replacement for the book.

The chapter reviews link out to standalone reference and worked-example pages, joins, aggregates, and subqueries against a practice database, Crow's Foot notation, and the levels of data abstraction. Those live on the main Database Management page, since they aren't specific to this class.

At a Glance
  • Course: CIS 4720, Database Management and SQL
  • Text: Coronel & Morris, Database Systems, 14th ed.
  • Chapter reviews: aligned to the chapter quizzes
Chapter Reviews

Chapter reviews

Short study guides written from Database Systems. Each one lines up with the chapter quiz.

📝
Chapter 2 review

Relational terminology, DBMS versus RDBMS, DDL, business rules, the entity relationship building blocks, the object oriented model, and Big Data with Hadoop and MapReduce.

Open the review →
🔑
Chapter 3 review

Keys from superkey to primary key, entity and referential integrity, the data dictionary and system catalog, composite and bridge entities, functional dependence, and relational algebra.

Open the review →
🧮
Chapter 4 review (4.1–4.7)

SQL data types, AI in query optimization, and building and refining a SELECT statement with DISTINCT, aliases, logical operators, BETWEEN, IS NULL, LIKE, IN, ORDER BY, and transactions.

Open the review →
🔗
Chapter 4 review (4.8–4.13)

JOIN ON, JOIN USING, NATURAL and CROSS JOIN, outer joins, the five aggregate functions, GROUP BY, HAVING, subqueries, correlated subqueries with EXISTS, and recursive queries.

Open the review →
⏱️
Chapter 4 review (4.11)

Built-in SQL functions: date and time functions, numeric functions, string functions, and conversion functions, with dialect comparison tables.

Open the review →
📝
Chapter 5 review (5.1–5.6)

Database schemas and authentication, choosing data types, CREATE TABLE and CREATE TABLE AS SELECT, ALTER TABLE, INSERT/UPDATE/DELETE, COMMIT and ROLLBACK, and updatable views.

Open the review →
Related

More Database Management

Database Overview View My Courses