CSCI 575: Database Systems II

Department of Computer and Information Science
The University of Mississippi

Announcements:

• Winners! Well, just because you aren't on the list doesn't mean you aren't a winner, just that this is how many prizes I had to give. Overall I was pleased at the quality of the projects, given the time you had to complete them. Stop by my office to pick up your prize.
  • Overall Project (Designer) - Chad
    Prize: 2GB USB drive
  • Best paper (and use of XML) - Wayne
    Prize: Google tumbler
  • Best User Interface Design - tie between Rong and John
    Prize: Google Yo-yos
  • Overall Design - Shweta and Lohith
    Prize: Google Yo-yos
  • Creative use of Database - tie between Scott and Joseph
    Prize: Google T-shirt (I have two, you don't have to share)
  • Best experimental project - Mark
    Prize: Google frisbee
  • Good Effort Awards - Shengnan, Suresh and Zhendong
    Prize: a Google blinky pin or Google pencils

• Reading material for the final exam:
  • Chapter 8: Overview of Storage and Indexing (all)
  • Chapter 16: Overview of Transaction Management (all except ARIES section)
  • Chapter 17: Concurrency Control (17.1-17.5)
  • Chapter 18: Crash Recovery (18.1-18.6)
  • Chapter 20: Physical DB Design and Tuning (all except 20.11)
  • Chapter 21: Security and Authorization (21.1-21.6)

  The exam will have some matching (terms), some short essay questions, and a database normalization problem (like on the midterm).

• The project description is available.
• Here is a tab-delimited sample data file for the second part of homework #5.

Course Information

• Fall 2007 Syllabus
• Homework and Projects

Assignments

• Homework #1    FAQ    Due 9/4/2007 at the beginning of class.
• Homework #2    FAQ    Due 9/13/2007 at midnight

• Homework #3

  Do the lab exercise distributed in class last Thursday. Write a script to create and populate the two tables described. Graduate students should do all three programs (one web-based, one command line driven using $argv, and the third that runs from the command line, but prompts the user for which list to display). Undergraduates should do two versions of the program--the web-based version and one of the other two.

  Hand in: the script to create and populate the database tables, the php scripts for the two or three programs, and the ouput generated by each. Please document, indent, choose variable names wisely, etc. The output of the programs does not have to be beautiful, but it should be neatly arranged.

  Due: Tuesday, Sept 24th at Midnight

• Homework #4    FAQ    Due 10/9/2007 at midnight
• Homework #5    FAQ    Part 1 due 10/25/2007 at midnight. Part 2 due 11/1/2007 at midnight.
• Project

Useful Links and Class Examples

• Info on MySQL, PHP and Pear