Messages

Week 12

Friday, 5/03/96, Final milestone of project is due.

Class 24: Thursday, 5/02/96, Review major topics of course. Homework # 5 due.

Class 23: Tuesday, 4/30/96, Student presentation (Rob) of independent project. Discuss project.

Week 11

Class 22: Thursday, 4/25/96, More time spent on Teradata SQL3 Multimedia Server case study. Wrap-up discussions on multimedia databases and their future use. Final Project milestone will de due May 3rd, 1996 (versus April 26th).

Class 21: Tuesday, 4/23/96, Complete discussions on recovery and log management. Start Case study a multimedia database system.

Week 10

Class 20: Thursday, 4/18/96, Start discussions on recovery and log management.

Class 19: Tuesday, 4/16/96, Complete discussion on Concurrency Control; touch on lightly lesser degree isolation, and how and when it can be used. Hmwk 4 (on access methods) due today.

Week 9

Class 18: Tursday, 4/11/96, Start discussion on Concurrency Control; lecture notes will be distributed in class.

Class 17: Tuesday, 4/09/96, Discussion on Transaction Processing; lecture notes will be distributed in class. Hmwk 4 (on access methods) is assigned today.

Week 8

Wednesday, 4/03/96, Second milestone of project due (relation and schema routines).

Class 15: Tuesday, 4/02/96, Continue discussing Access Methods of object/record groupings. Will distribute lecture notes on access methods.

Week 7

Class 14: Thursday, 3/28/96, Continue discussions on storage management of small and large object techniques. Discuss object groupings and start discussion on access methods.

Class 13: Tuesday, 3/26/96, Discussions on storage management, allocation techniques, and buffering. Returned Mid-Terms.

Week 6

Class 12: Thursday, 03/14/96, Mid-Term. Homework #3 is due. Mid-Term will only touch on material covered through week 5.

Class 11: Tuesday, 03/12/96, Review for Mid-Term. Start discussions on storage systems -- secondary memory (not testable on mid-term). Distributed initial lecture notes on storage systems.

Week 5

Class 9: Tuesday, 3/05/96, Last class introduced lossy/lossless database designs and function dependencies (FDs). Will continue with determining closure, and a minimal set of FDs on a set. Will also cover the normal forms. Read paper distributed last class and corresponding textbook chapter.

Week 4

Class 7: Tuesday, 2/27/96, Finish commercial relational languages. Homework #2 is due. Discuss project (if questions). Relate Relational model to other logical models (e.g., OO, Network, Hierarchical). Distributed course notes on Normalization.

Saturday, 2/24/96 -- fixed permissions on cs425 directory.

Week 3

Late note: Distributed project handout, is available online.

Class 5: Tuesday, 2/20/96, Review Relational Algebra. Discuss relational calculus.
See course notes handed out from previous class.

Week 2

Class 4: Thursday, 2/15/96, Discussions on Relational Data Modeling and Relational Algebra.
Read the hand-out of the paper published by E.F. Codd along with textbook chapters.
Distributed lecture notes on the Relational Model. Homework #1 is due.

Class 3: Tuesday, 2/13/96, We will finish E-R Data Modeling and move on to the Relational model. Homework #1 is assigned after completion of the E-R discussions and due next class.

Week 1

Class 2: Thursday, 2/8/96, will discuss E-R Data Modeling.
Read the hand-out of the paper published by P. Chen along with Chapter 3 of the text book.
Homework #1 may tentatively be distributed in this class (it is available online).

Class 1: First day of class is Tuesday, Feb. 6th, 1996 from 3:00 - 4:20pm in room CS102.
We will cover material from the first two chapters of the text book.

[ Home]