Database Management

Program: MSIS/PhD
Course Areas
General Information Studies Elective

Catalog Description

Principles and practices of database management and database design. Discussion and implementation of a database. Application life cycle, data dictionaries, relational database design, SQL queries, reports and other interfaces to database data, and documentation. Students work on individual and group projects.

Instructor Description

Database is the foundation of Data Science. It provides the unique design to store, retrieve, and manage data. Data become the essential gas to power the generative AI. How to model data, encode context, enforce business rules, and achieve efficiency are critical for database design. This course provides the introductory understanding of relational database design with the focus on three parts. The first part is centered around the database design lifecycle by introducing business rules, ER diagram, normalization, and UML chart. The second part talks about database query language SQL by explaining concepts and providing examples. The third part gives you the forward introduction of XML database which is the commonly used NoSQL database. The learning content will be delivered in the variety of exercises including lectures, tutorials, class activities, individual assignments, group assignments, and group projects. This course empathizes peer learning, hands-on practices, forward exploring, and risk taking.

Prerequisites

Graduate Standing.

Restrictions

Restricted to graduate student in the School of Information.
Skills and Knowledge
ER Diagram
Database Management
Topics and Concepts
SQL
conceptual Modeling
XML Database

Scheduled and Upcoming Classes for this Course

Class Name Semester Day(s) Start Time(s) End Time(s) Building Room
INF 385M: Database Management

Ying Ding

Fall Term 2025
  • Tuesday
  • 9:30 am
  • 12:30 pm
  • UTA
  • 1.208
INF 385M: Database Management

Michael Mcquaid

Summer Term 2025
INF 385M: Database Management

Shounak Roychowdhury Syllabus

Spring Term 2025
  • Wednesday
  • 12:00 PM
  • 3:00 PM
  • UTA
  • 1.208

Past Classes for this Course

Class Name Semester Day(s) Start Time(s) End Time(s) Building Room
INF 385M: Database Management

Stan Gunn Syllabus

Summer Term 2024
INF 385M: Database Management

Stan Gunn Syllabus

Spring Term 2024
INF 385M: Database Management

Ying Ding Syllabus

Fall Term 2024
  • Tuesday
  • 9:30 AM
  • 12:30 PM
  • UTA
  • 1.208
INF 385M: Database Management

Stan Gunn

Summer First Term 2023
INF 385M: Database Management

Stan Gunn Syllabus

Spring Term 2023
INF 385M: Database Management

Stan Gunn Syllabus

Fall Term 2023
INF 385M: Database Management

Stan Gunn Syllabus

Summer Term 2022
INF 385M: Database Management

Stan Gunn Syllabus

Spring Term 2022
INF 385M: Database Management

Stan Gunn Syllabus

Fall Term 2022