Notes and Slides

• Oracle Login & Password instruction
• How to publish your Web Page in the CS Web server? ( MS Word format, HTML format)
• Week 1-3: Review (Relational algebra and SQL)
• Slides for chapter 5 ( Slides PPT and Pictures PPT ) (book slide)
• My old note (PDF)
• Week 4
• Slides for chapter 9 ( PPT and Pictures PPT ) (book slide)
• My note for chapter 9
• Week 5 & 6
  •  Slides for chapter 10 (PDF and PPT)
  • My note for chapter 10 (updated 3/7/2007)
• Week 7 & 8
  •  Slides for chapter 11 (PDF and PPT)
• Solutions of homework:
  • Chapter 11
  • Chapter 10
  • An old test (2005)
• Midterm Solutions:
  • Set a
  • Set b
• Week 9
  •  Chapter 12 Database Tuning (PDF and PPT)
• Week 10-14
  • Chapter 15: XML Database (PDF and PPT)
  • Note: XMLPARSE does not seem to work on interactive mode, so is XMLEXISTS
  • XMLAGG works in conjunction with Group By - produces one element for a tuple in the group and places it one after the other.
• Week 15
  • Chapter 16: Distributed Database (PDF and PPT)
• Week 16
  • Chapter 17: OLAP and Data Mining (PDF and PPT)