Topics

This course covers relational databases in detail. Other optional material listed at the bottom.

Relational Databases (required of all students)

  • Querying Relational Databases
    • Relational Algebra
    • SQL (in some depth, including recursion)
  • Contraints
    • Attribute and tuple constraints
    • Referential Integrity
    • General constraints (assertions)
  • Triggers
  • Universal Modeling Language (for conceptual database design)
  • Relational Design Theory
    • Functional Dependencies
    • Normal Forms
    • Design by Decomposition
  • Views
  • Indexing
  • Transactions

Optional Material (see the bottom of Schedule)

  • XML Schema
  • Querying XML Data
  • JSON Data
  • Multivalued Dependencies
  • Online Analytical Processing
  • Recursion in SQL
  • Authorization in SQL

I encourage you to pursue these optional topics. We have no second course in database where you might formally study non-SQL database schemes and other advanced database topics, such as data mining, but we can talk about a followup independent study if you are interested in formal credit for any of these other topics.