Lecture and exam schedule

Note:  The following presents the lecture, reading and exam schedule for Spring 2005.  Please note that, except for scheduled University events and exam dates, the schedule of topics, readings, and assignments is tentative. It may be necessary to change an exam date: if that happens, I will give you at least a week's notice and make alternate arrangements for students unable to take the exam on the rescheduled date. Please inform me of any conflict between the dates entered here and those in the catalog and course schedule. In the event of any conflicts, the catalog and course schedule have the final say.

Exam Schedule:

• Hour Exam #1 will be Friday, February 18
• Hour Exam #2 will be Friday, March 25
• Hour Exam #3 will be Wednesday, April 27.  Please note that this is in the last full week of classes.
• The Final Exam for CSci 455 will be at 8:00 AM Monday, May 9.  It will be a mandatory, in-class final exam.

Group Project Schedule:

• Informal project proposals (email) due Friday, February 11
• Formal Project Proposal due Friday, February 25
• Requirements Document due Friday, March 11 (submissions earlier that week cheerfully accepted).
• Friday, April 1: Preliminary design document due
• Friday, April 15: Design Document due
• Week of May 2:  Formal Presentations
• Wednesday, May 4 (last day of class):  all project materials due.  Documents should be bound (binding available through the print shop).

Weekly Schedule

Week 1:  Monday, January 17

• Topics:  Introduction
• Reading:  Date, chapters 1, 2
• Other notes
• Monday is Martin Luther King Jr. Birthday (no classes or office hours)

Week 2: Monday, January 24

• Topics
• File organizations and access methods
• Database models
• The relational model
• Reading: 
• Date, chapter 3
• Sunderraman, chapter 1
• Other notes

Week 3:  Monday, January 31

• Topics
• Introduction to Oracle
• Introduction to SQL
• Reading: 
• Date, chapter 3,4
• Sunderraman, chapter 2
• Other notes
• Monday, January 31, is the last day to drop without record.

Week 4:  Monday, February 7

• Topics
• Introduction to top-down design with entity-relationship diagrams
• Reading: 
• Date, chapter 12
• Sunderraman, chapter 2
• Other notes
• Starting with this week, Thursdays will be reserved for group meetings.  I will be in my office during class times on Thursday, with priority given to groups.  Please do not schedule other activities into this slot as we may need it for an extra lecture.
• The first hour exam will be next Friday.

Week 5:  Monday, February  14

• Topics:  Views and indexes
• Reading: 
• Date, chapter 10
• Sunderraman, chapter 2
• Other notes
• Monday, February 14 is the last day to drop with an Automatic "W".
• Hour Exam #1 will be Friday, February 18

Week 6:  Monday, February 21

• Topics
• The data dictionary
• Bottom-up design and data normalization
• The database loader
• Reading: 
• Date, chapters 11, 12
• Other notes
• Formal project proposals will be due Friday, Februrary 25

Week 7:  Monday, February 28

• Topics
• Bottom-up design and data normalization
• Reading: 
• Date, chapters 11, 12
• Other notes
• Dydd Dewi Sant yn hapus iawn i bawb!

Week 8:  Monday, March 7

• Topics
• Data normalization
• Reading: 
• Date, chapters 11, 12
• Other notes
• Friday, March 11, is Mid-term (not an exam date for us)
• Requirements document due Friday, March 11
• But there will be an hour exam on the Friday after spring break.

Week 9:  Monday, March 14

• Topics **SPRING BREAK**  No classes or office hours
• Reading
• Other notes

Week 10:  Monday, March 21

• Topics
• Resolving top-down and bottom-up design
• Advanced SQL
• Reading: 
• Date, chapters 11, 12
• Sunderraman, chapter 2
• Other notes
• The second hour exam will be Friday, March 25

Week 11:  Monday, March 28

• Topics
• Advanced SQL
• Reading: 
• Date, chapters 11, 12
• Sunderraman, chapter 2
• Other notes
• Preliminary design document due Friday, April 1

Week 12:  Monday, April 4

• Topics
• Tools:  UML, Reports and forms
• Advanced SQL
• PL/SQL
• Reading: 
• Sunderraman, chapters 3, 4
• Oracle documentation forms and reports
• Other notes

Week 13:  Monday, April 11

• Topics
• More tools
• PL/SQL
• Reading: 
• Sunderraman, chapters 3, 4
• Other notes
• .The full design document is due Friday, April 15

Week 14:  Monday, April 18

• Topics
• The full relational algebra
• Advanced SQL
• Reading: 
• Sunderraman, chapters 3, 4
• Date chapter 7
• Other notes

Week 15:  Monday, April 25

• Topics
• Review and exam
• Reading: 
•  
• Other notes
• Hour exam #3 will be Wednesday, April 27.  Please note that this is in the last full week of classes.

Week 16:  Monday, May 2

• Topics
• Presentations
• Reading: 
•  
• Other notes
• Last day of class is Wednesday, May 4.

Week 17:  Monday, May 9

• Topics:  Final Exams
• Reading
• Other notes
• The final exam for CSci 455 will be at 8:00 AM Monday, May 9.  It will be a mandatory, in-class final exam.