APPLIED DATABASE DESIGN
Introduces the applications of databases to real-world data and information problems. Overview of the principles and practices of user-oriented database design, management, and application. Discussion and practice cover database application lifecycle, data modeling, relational database design, SQL queries, reports and other interfaces to database data, and database documentation.
Prerequisites & course information
Requisites: Sophomore standing and satisfied Quantitative Reasoning (QR) A Course Designation: Core GenEd - Natural Science & Wellness + Lab Breadth - Natural Science Level - Intermediate L&S Credit - L&S Liberal Arts and Science Repeatable for Credit: No Last Taught: Fall 2026 Learning Outcomes: 1. Understand the technical vocabulary and concepts used to describe databases and related technologies Audience: Undergraduate 2. 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 Audience: Undergraduate 3. Apply normalization techniques to reduce data redundancy and improve data integrity Audience: Undergraduate 4. Understand the concepts of de-normalization and its rationale in real-world applications Audience: Undergraduate 5. Create, modify, and query relational databases using the SQL language Audience: Undergraduate 6. Perform a real-world database design and implementation in MySQL Audience: Undergraduate 7. Understand the concept of No-SQL database models and the difference between SQL and NO-SQL database Audience: Undergraduate Learning Outcomes: 1. Understand the technical vocabulary and concepts used to describe databases and related technologies Audience: Undergraduate 2. 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 Audience: Undergraduate 3. Apply normalization techniques to reduce data redundancy and improve data integrity Audience: Undergraduate 4. Understand the concepts of de-normalization and its rationale in real-world applications Audience: Undergraduate 5. Create, modify, and query relational databases using the SQL language Audience: Undergraduate 6. Perform a real-world database design and implementation in MySQL Audience: Undergraduate 7. Understand the concept of No-SQL database models and the difference between SQL and NO-SQL database Audience: Undergraduate
Sources
- Course catalogue ↗2026-2027