CSci 455 Lecture Schedule
Please note: This is an estimate of the schedule we will
follow. Please check with the "this week / next week" files for
the current schedule. I intend to keep the exam dates as below, but will
give you at least a week's warning if they have to change. Please note
that the last hour exam is in the final full week of the term.
University dates given below should be accurate, but please check the main
university calendar for the final word.
Change History:
- 1/20/04: Modified for Spring 2004
Notes:
- This should be considered very much a document in development.
While I will try as much as possible to stick to the posted exam
dates, the schedule of lectures and homework may change as the
term progresses. Updates, and detailed weekly plans, will be
posted on the This Week /
Next Week pages..
- Please note that reading assignments for an individual lecture
should be completed before the lecture. Readings may include
handouts to be provided, and may also include readings in books on
reserve.
Exam dates:
- Exam 1: Friday, February 20
- Exam 2: Friday, March 26
- Exam 3: Wednesday, April 28. Please note that this is in the
last full week of class. Please note the correction in the date
(class does not meet on Tuesdays)
- Final exam: Friday, May 14, 8:00 AM - 10:00 AM. All
students must take the exam at this date and time.
Week 1: Monday, January 19
- Topic: Introduction
- Reading: Date, chapters 1, 2
- Other notes
- Monday is Martin Luther King day (no classes or office hours)
Week 2: Monday, January 26
- Topics:
- File Organizations and Access Methods
- Database Models
- Reading:
- Date, chapter 3, appendix D
- Sunderraman, chapter 1
- Other notes
Week 3: Monday, February 2
- Topics:
- Relational Algebra
- Introduction to Oracle
- Introduction to SQL
- Reading:
- Date, chapter 3, 4
- Sunderraman, chapter 2
- Other notes
Week 4: Monday, February 9
- Topics:
- Continuation of Week 3
- Introduction to top-down design with entity-relationship diagrams
- SQL DDL Basics
- Introduction to Rational Rose
- Reading:
- Date, chapters 4, 14
- Sundarraman, chapter 2
- Other notes
- The first hour exam will be next week.
Week 5: Monday, February 16
- Topics:
- Database tools (SQLLDR)
- Rational Rose
- Introduction to the group project (Monday)
- Reading:
- Date, chapters 4, 14
- Sunderraman, chapter 2
- Notes on Rational Rose
- Other notes
- The first hour exam will be Friday, February 20.
- Monday, Feburary 16 is the last day to withdraw with an automatic "W".
- Group work days start this week. The class will generally not meet
on Thursdays to provide time for groups to meet. I will be in my office
for office hours, with preference given to groups that want to meet with me.
Please note: please do not make other arrangements for Thursdays
as we may need the time for lectures.
Week 6: Monday, February 23
- Topics:
- Views and indexes
- Oracle tools: the report writer
- Reading:
- Date chapter 10
- Sunderraman chapter 2
- Other notes
- Project proposals due Wednesday, February 54.
Week 7: Monday, March 1
- Topics:
- Bottom-up design
- Data normalization
- Forms and reports
- Reading:
- Date, chapters 11, 12
- Oracle documentation on forms and reports
- Other notes
- I may be at a conference Friday, March 5. More details
later.
Week 8: Monday, March 8
- Topics:
- Reading:
- Sunderraman, chapters 3, 4
- Other notes
- Friday, March 12 is Mid-Term
- The second hour exam will be Friday, March 26.
- Requirements document due Monday, March 8
Week 9: Monday, March 15
- Topic: Spring Break (no classes or office hours)
Week 10: Monday, March 22
- Topics:
- PL/SQL
- SQL functions / aggregation /group by / having
- Reading:
- Sunderraman chapters 2, 3, 4
- Other notes
- The second hour exam will be Friday, March 26.
- Preliminary Design Document due next Friday
Week 11: Monday, March 29
- Topics:
- PL/SQL
- Forms
- Building web applications
- Reading:
- Sundarraman, chapters 4, 5
- Oracle documentation
- Other notes
- Preliminary Design Document Due Friday, April 2
Week 12: Monday, April 5
- Topics:
- Building web applications
- Reading:
- Sundarraman, chapters 4, 5, 8
- Date chapter 27
- Other notes
- Full design document due next Friday.
- Registration for Fall Term begins Monday, April 5
Week 13: Monday, April 12
- Topics:
- Reading:
- Date, chapters 6 - 8
- Relational algebra notes
- Prolog notes
- Relational calculus notes
- Other notes
- Design Document Due Friday, April 16
- Early registration for Summer begins Monday, April 12
Week 14: Monday, April 19
- Topics:
- Reading:
- Date chapter 25
- Sundarraman section 2.9
- Other notes
- The third hour exam will be on Wednesday of next week.
Week 15: Monday, April 26
- Topics:
- Reading:
- Date, chapters 7, 8 revisited
- Other notes
- The third hour exam will be on Wednesday, April 28. Please note
that this is in the last full week of class.
- Thursday and Friday will both be group work days
- Group presentations will be on Monday and Wednesday of next week.
The schedule will be ready this week.
Week 16: Monday, May 3
- Topics:
- Reading:
- Other notes
- All project materials are due at 5:00 Wednesday. Since, however,
that is the time of the Math/CSci picnic, they will be accepted handed in at
my office until Friday at 5:00. I will send the class an email saying
when I will be in my office during reading period.
Week 17: Monday, May 10
- The final exam for this class will be Friday, May 14, 8:00 AM - 10:00
AM. All students must take the exam at this date and time.