MCS-274: Database Systems (Spring 2015)

This web page will be filled in as the semester progresses.

• General information and schedule
• Homework
  • Chapter 2
  • Chapter 6
  • Chapter 3
  • Chapter 4
  • Chapter 7
  • Chapter 8
  • Chapter 9
  • Chapter 10
  • Chapter 11
  • Chapter 12
• Labs
  • Lab 1: Basic SQL
  • Lab 2: Database design
  • Lab 3: Intermediate SQL
  • Lab 4: Stored procedures
  • Lab 5: Project
• Examples worked in class
  • Multi-table queries (2015-02-19)
  • Aggregation and grouping (2015-02-26)
  • Test 1 from 2013
  • Decompositions (2015-03-10)
  • Constraints (2015-03-24)
  • Test 2 from 2013
  • count_candidates.py (2015-04-16)
  • XML example from book: StarMovieData
  • XML example with internal DTD (which you may only see if you "view source"): MSwDTD (2015-04-28)
  • XML Schema example: MovieStars (2015-04-28)
  • Other XML examples from XPath section: Movies, Products, Ships
  • Final exam from 2013
  • XQuery example (2015-05-07)
• Other links
  • Textbook errata
  • MySQL documentation
  • www.xmlvalidation.com
  • AquaPath, AquaQuery, and XSLPalette
  • Web page that can be used for testing both XQuery and XPath
  • Free Online XSLT Test Tool

  Instructor: Max Hailperin

  Let me know what you think

  I would appreciate feedback about the course. I welcome your comments in person or by email to max@gustavus.edu.