Skip to main content

C S 452

Database Modeling Concepts

Computer Science College of Physical and Mathematical Sciences

Course Description

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

When Taught

Fall

Grade Rule

Grade Rule 8: A, B, C, D, E, I (Standard grade rule)

Min

3

Fixed

3

Fixed

3

Fixed

0

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.