Database Modeling Concepts

Database Modeling Concepts
Database models: relational, deductive, object-oriented. Integrity constraints, query languages, database design.
C S
452
 Hours3.0 Credit, 3.0 Lecture, 0.0 Lab
 PrerequisitesC S 240
 TaughtFall
 ProgramsContaining C S 452
Course Outcomes

Query Languages

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.

Query Optimization

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

Database Design

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

Current Challenges

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