COMS4111, Spring 2013
Schedule & Class Notes

This is an approximate schedule; it is subject to changes as the course progresses. Notes for a paricular lecture will be available ahead of the lecture. The notes are PDF files, one slide per page; if you plan on printing the notes, you may want to set up the printer to print at least two slides per page.  

 

Lecture
No		 Date    Topic, Reading, Lecture Notes Due
1 Jan 23 Course Overview. Introduction to Database Systems. 
The Entity-Relationship Model.
Chapters 1 and 2. Notes.
2 Jan 30

The Entity-Relationship Model (cont.).

The Relational Model, SQL Schema.
Chapter 3. Notes.

  
3 Feb 6 The Relational Model, SQL Schema (cont.)
4 Feb 13 Relational Algebra.
Chapter 4, Sections 4.1 and 4.2 only. Notes.		 Project 1.1 aproval; Monday Feb 11 through Friday Feb 15.
5 Feb 20 SQL: Queries, Constraints, Triggers. 
Chapter 5. Notes. 		Project 1.1, in class.
HW1, in class.
6 Feb 27 SQL (cont.).  
7 Mar 6 Embedded SQL, Cursors, SQL APIs.
Chapter 6. Notes. 		HW2, electronically by Tuesday March 5, 5:00pm.
8 Mar 13 Midterm Exam (closed book/notes).  It covers all topics up to and including lecture #6. It does not cover lecture #7 ("Embedded SQL, Cursors, SQL APIs"). There will be no lecture after the exam.

To assist you in preparing for the exam, we provide a sample midterm exam and the answers.

Answers to your midterm exam.

March 20: No class - spring break.
  
9 Mar 27 Schema Refinement and Normal Forms.
Chapter 19, except for Sections 19.6.2 (Decomposition into 3NF) and 19.8 (Other Kinds of Dependencies). Notes. 		Project 1.2, electronically by Monday March 25, 5:00pm. 
10 Apr 3

Object-Relational DBMS: Database Design.
Chapter 23, Sections 23.1 through 23.7.
Also skim over the Oracle Database Application Developer's Guide--Object-Relational Features. Start at the "Introduction to Oracle Objects" section for a general view of key features and get familiar with the terminology; then proceed to the "Basic Components of Oracle Objects" section. Notes. 
11 Apr 10 Overview of Storage and Indexing.
Chapter 8 (only at the level of detail covered in class). Notes. 		Project 1.3.
Expanded-design option, electronically, by Tuesday April 9, 5pm.
Web Front-End option demos on Thursday April 11.
12 Apr 17 Introduction to Query Processing and Optimization.
Chapter 12 (only at the level of detail covered in class). Notes.
13 Apr 24 Introduction to Transaction Processing.
Chapter 16 (only at the level of detail covered in class), except for Sections 16.5 ("Performance of Locking") and 16.6 ("Transaction Support in SQL"). Notes. 		HW3, electronically by Monday April 22, 5:00pm.

Project 2, electronically by Thursday April 25, 5:00pm.
14 May 1

Overflow material and review. Notes.

 HW4, electronically by Tuesday April 30, 11:55pm..
15 May 8 No Class - Study Day  
16 May 15 Final Exam (closed book/notes).
It covers the topics of all lectures above except lectures #7 and #14. 

Time and location of the final exam for both sections: Wednesday May 15th from 5 - 7pm in room 501 Schermerhorn.