Skip to main content

Introduction to Database Systems

General

Prefix

SE

Course Number

211

Course Level

Undergraduate

College/School

College of Science and Engineering

Description

Database management, design, and implementation. Database theory, data modeling, relational model concepts, data normalization, relational algebra, Structured Query Language (SQL), database design. Use of conventional Database Management Systems (DBMSs) and modeling tools.

Prerequisites

Credits

Min

3

Max

3

Repeatable

No

Goals and Diversity

MN Goal Course

No

Cultural Diversity

No

Learning Outcomes

Outcome

Define database concepts and theories.

Outcome

Apply data modeling techniques.

Outcome

Use relational algebra notation and apply it to construct SQL instructions.

Outcome

Design normalized relational databases.

Outcome

Use common Database Management Systems and modeling tools.

Course Outline

Course Outline

Database theory. 10% Relational data model. 15% Relational algebra. 10% Structured query language. 15% Database management. 10% Database design and implementation. 10% Database normalization. 10% Common database management systems and modeling tools. 10% Non relational (NOSQL) databases. 10%

Dependencies

Programs

SE211 is a completion requirement for: