C S 452

Download as PDF

Database Modeling Concepts

Computer Science College of Computational, Mathematical, & Physical Sciences

Course Description

Database models: relational, deductive, object-oriented. Integrity constraints, query languages, database design.

When Taught

Fall, Winter, and Spring

Credit Hours

Min

Fixed

Lecture Hours

Fixed

Lab Hours

Fixed

Learning Outcomes

Title

Query Languages

Learning Outcome

Be able to use a variety of commercial query languages (SQL, XQuery, SPARQL), both stand-alone and embeded in high-level programming languages. Know how relational algebra and relational calculus provide a basis for commercial query languages.

Title

Query Optimization

Learning Outcome

Understand performance issues and optimization strategies. This includes query rewriting, secondary storage characteristics, and access strategies.

Title

Database Design

Learning Outcome

Be able to design and develop relational database applications. This includes conceptual modeling and normalization theory.

Title

Current Challenges

Learning Outcome

Be familiar with some of the current challenges facing database professionals.