Skip to main content

Database Theory and Design

General

Prefix

CSCI

Course Number

411

Course Level

Undergraduate

College/School

College of Science and Engineering

Description

Principles of database systems, theory of relational databases, design techniques, concurrency control and recovery, object-oriented systems.

Prerequisites

Credits

Min

3

Max

3

Repeatable

No

Goals and Diversity

MN Goal Course

No

Cultural Diversity

No

Learning Outcomes

Outcome

Develop database applications using programming languages and application program interfaces.

Outcome

Develop indexing and optimization strategies appropriate to the requirements.

Outcome

Evaluate and optimize query execution plans.

Outcome

Manage spatial data within a database and apply spatial indexing techniques.

Course Outline

Course Outline

Entity relationship model of databases. 15% Relational model of databases. 15% Structured query language (SQL). 10% Storage and indexing. 10% Tree structured indexing. 10% Query evaluation. 10% Optimization. 10% Transaction management. 10% Concurrency control. 10%

Dependencies

Courses

CSCI411 is a prerequisite for:

Programs

CSCI411 is a completion requirement for: