Spring 2027

Applied Database Design

Applied Database Design introduces applications of databases to real-world problems, covering user-oriented design, management, SQL, and MySQL implementation.

offering recorded3 credits
Recorded instructors · Spring 2027 No instructors listed

Summary

1 / 6

Past student reviews · Kristin Eschenfelder

Group projects took some time but were interesting, while exams were described as very lecture-heavy.

What you’ll be able to do

  • Understand the technical vocabulary and concepts used to describe databases and related technologies

  • Understand, and critically evaluate and implement the full spectrum database design process, from the initial user needs analysis, to conceptualization, development of schemas, and final production

  • Apply normalization techniques to reduce data redundancy and improve data integrity

  • Understand the concepts of de-normalization and its rationale in real-world applications

  • Create, modify, and query relational databases using the SQL language

  • Perform a real-world database design and implementation in MySQL

  • Understand the concept of No-SQL database models and the difference between SQL and NO-SQL database

Source: UW Guide

Grade history

↗
average GPA
letter grades
A
AB
B
BC
C
D
F

All recorded terms · compare terms & instructors

Prerequisites

Course map

Sophomore standing and satisfied Quantitative Reasoning (QR) A

    • Sophomore standing
    • satisfied Quantitative Reasoning (QR) A
    take all
LIS 464

This is a best-effort interpretation; check the catalog requirements above.

Prerequisite text tree
  • All of
    • Sophomore standing
    • satisfied Quantitative Reasoning (QR) A

Professors

Spring 2027

No instructors recorded for this selection.

Historical instructors & teaching patterns

KRISTIN ESCHENFELDER is recorded teaching in Fall 2022, Fall 2023, Fall 2024. Recorded history may be incomplete and does not establish a future schedule.

Recorded history may be incomplete and does not establish a future schedule.

Calendar & sections

Spring 2027

Schedule loads here as you scroll.

SectionModeEnrolled / capacityWaitlist
LEC 001Classroom Instruction0 / 870

Times are Central. Select a meeting for details; export includes recorded dates for the selected sections. Enrollment reflects scan time.

Meeting source records
Download part 1

Student experience

the class

Past student reviews · Kristin Eschenfelder

Kristin Eschenfelder taught this course as an accessible introduction to databases and SQL, breaking down technical concepts for non-technical students.

Recent recorded grades — Spring 2025: 3.79 GPA, 89.4% A/AB (n=85 letter grades); Fall 2025: 3.72 GPA, 88.4% A/AB (n=95 letter grades); Spring 2026: 3.68 GPA, 86.4% A/AB (n=88 letter grades).

difficulty & workload

Past student reviews · Kristin Eschenfelder

Group projects took some time but were interesting, while exams were described as very lecture-heavy.

Past student reviews · Kristin Eschenfelder

Students found the class easy to understand due to extensive use of examples in lectures, and they often finished assignments during class time.

Topics

  • User-oriented database design, management, and application.
  • Database application lifecycle, data modeling, and relational database design.
  • SQL queries, reports, database interfaces, and documentation.
  • De-normalization concepts and No-SQL database models.

Skills

  • Implementing the full database design process including user needs analysis, schema development, and production.
  • Applying normalization techniques to reduce data redundancy and improve data integrity.
  • Creating, modifying, and querying relational databases using SQL.
  • Performing real-world database design and implementation in MySQL.
  • Understanding the database application lifecycle, data modeling, and database documentation.

Grades

Latest available · Spring 2026— not enough history to project Spring 2027.

average GPA
A / AB grades
letter grades
Instructor

Grade distribution · % of letter grades

A
AB
B
BC
C
D
F

Grades over time

Through Spring 2026

More grade details Grade mix, volume & source data

Where this course fits relative to

Latest available grades · Spring 2026 · all course levels

GPA

Higher than % of other courses in this group.

Course GPAs · red marks this course’s range

letter grades

More recorded grades than % of other courses in this group.

Typical course in this group: letter grades.

About this comparison

1280 courses over the same term, each with at least 30 recorded letter grades. Cross-listed courses count once. GPA is not a measure of difficulty or teaching quality. The typical course is the median by recorded grade count; tied values are not counted as lower. Grade counts describe course scale, not unique students or typical section size.

Descriptions compare GPA with this group’s average: at least 0.20 higher or lower; otherwise close to average. Section size uses median recorded enrollment: small up to 30, mid-sized 31–99, large 100+. Lectures and discussion/lab sections are described separately.

Sources & history

UW–Madison

Catalog & offerings

Descriptions, prerequisites, and recorded course offerings.

Catalog observation history

Observations at scan time; dates do not imply when a catalog change took effect.

Download part 1
Selected offering source records
LIS 464 · Spring 2027

Applied Database Design

Recorded 2026-10-14
Raw records 
[
  {
    "run_id": "20261014T203208-0851c9a1",
    "semester": "1274",
    "observed_at": "2026-10-14 17:50:09.728220+00:00",
    "offering_id": "1274:544:026057",
    "course_id": "LIS 464",
    "course_uid": "course_b7124aab0f885840575f8fab",
    "term_id": "1274",
    "source_course_id": "026057",
    "source_subject_id": "544",
    "title": "Applied Database Design",
    "credits_min": 3,
    "credits_max": 3,
    "typically_offered": "Not Applicable"
  }
]
Rate My Professors

Student reviews

Original comments behind the course and instructor summaries.

Read original reviews
Download part 1
Madgrades

Grade history

Recorded grade distributions by term, section, and instructor.

Explore recorded grades
Dataset & model

Recorded 2026-10-14

View the dataset on Hugging Face
Model outputs & technical records
Qwen/Qwen3.8-27B
LLM outputs across runs
Download part 1
Full model traces

Recorded model configuration, reasoning, and tool conversations.

Download part 1
Model & dataset provenance 
{
  "model": "Qwen/Qwen3.8-27B",
  "model_revision": "1d4bf0f2ff6012fd82039f2fa52739d0dd7c60c0",
  "task_version": "17",
  "output_id": "cff251630564823f6c9231fa09c9f6db08d3aa80559593fde996e5c63e3f0fcd",
  "requirements_status": "needs_review",
  "dataset_revision": "fc1811fa52e581ea57a35c0cf3343f8740a8ffbf",
  "observed_at": "2026-10-14 17:50:09.728220+00:00"
}