CS 491: Special Topics in Web Database Applications

Winter 2004

READING & OTHER ASSIGNMENTS

Reading and other assignments will be listed here in chronological order, i.e., with the most recent ones at the bottom of the list. Homework assignments must be neatly written or typed. All answers should be complete sentences unless the answer is just a number. Homework is due by 4 pm on the due date. If late homework becomes a problem, I will announce a late policy in class and on news and announcements.

This document was last modified on February 27, 2004.

Week 1:

Reading Assignment #1 (First Week) --
- Reading from Database Management Systems: Chapter 1
- Reading from Web Database Applications: Chapters 1 & 2 (skim pages 61-91).
Homework Assignment #1: page 23-24, problems 1.2, 1.3, 1.4, 1.6, 1.9 (all parts).
(due Monday of Second Week)
Friday discussion question: Read through Exercise 2.6 on pages 53-54. We will discuss the information that is needed to implement this database.
Programming Assignment #1: PHP Re-design of MAGE Web Page
(due Monday of Fifth Week)

Week 2:

Reading Assignment #2 (Second Week)
- Reading from Database Management Systems: Chapter 2
- Reading from Web Database Applications: Appendix C (pages 504-516)
- Reading from Web Database Applications: Chapter 9 (pages 341-354)
Homework Assignment #2: pages 52-53, problems 2.2, 2.4, and 2.5.
(due Wednesday of Third Week)
Friday discussion question: Exercise 2.6 on pages 53-54.

Week 3:

Reading Assignment #3 (Third Week)
- Reading from Database Management Systems: Chapter 3
- Reading from Web Database Applications: Appendix A (pages 516-522)
- Reading from Web Database Applications: Chapter 9 (pages 355-367)
Homework Assignment #3: pages 95-97, exercises 3.5, 3.8, 3.9, 3.12, 3.14, 3.15, 3.19
(due Monday of Forth Week)
Friday discussion question: Exercise 3.16 on page 97.

Week 4:

Reading Assignment #4 (Fourth Week)
- Reading from Database Management Systems: Chapter 5
- Reading from Web Database Applications: Chapter 3 (skip pages 151-159) and Chapter 4 (skip pages 195-201)
Homework Assignment #4: pages 174-179, 5.1, 5.4, 5.7
(due Monday of Fifth Week)
Friday discussion question: Exercise 5.3 on page 175-176.

Week 5:

Reading Assignment #5 (Fifth Week)
- Reading from Database Management Systems: Chapter 4 (skip sections 4.3.2 and 4.4)
- Reading from Web Database Applications: Chapters 5 & 6
Homework Assignment #5: pages 127-128, 4.3 (do the odd numbered parts in relational algebra,
the even numbered parts in either tuple relational calculus or domain relational calculus)
(due Monday of Sixth Week)
Midterm Exam will be take home handed out on Wednesday, 2/4 and due on Monday, 2/9. It will cover Chapters 1-3 and 5 of Database Management Systems skipping sections 1.2, 1.3, 1.9, 3.6, 3.7, 5.8, 5.9 and the case study.
There will be no class on Friday, 2/6

Week 6:

Reading Assignment #6 (Sixth Week)
- Reading from Database Management Systems: Chapter 6 (skim this chapter to get a feel for ways to program using a database)
- Reading from Web Database Applications: Chapter 7
Homework Assignment #6: Implement the administrator's web access page for the MAGE web site
(due Wednesday of Eighth Week)
Programming Assignment #2: Database Accessor for Customers
(due Monday of Finals Week)

Week 7 and Week 8:

Reading Assignment #7 (Seventh Week)
- Reading from Database Management Systems: Chapter 7
- Reading from Web Database Applications: Chapter 8
Recall that Homework Assignment #6: is due Wednesday of Eighth Week

Week 9:

Reading Assignment #8 (Ninth Week)
- Reading from Database Management Systems: Chapter 8
- Reading from Web Database Applications: Chapter 10
Your final paper description is now available and is due on Thursday of Finals Week.
Shawn will give a presentation on sections 8.1-8.3 on Monday, Kelly will finish chapter 8. Bo will give a presentation on Data Mining on Wednesday and Kelly will talk about Normallization. Friday will be a group work day.

Week 10:

Reading Assignment #9 (Tenth Week)
- Reading from Database Management Systems: Chapter 21
Zachary will give a presentation on Object-Oriented Databases on Monday, Stephen will give a presentation on Deductive Databases also on Monday. Wednesday will be a group work day. Kelly will talk about Tuning on Friday.