ECE 464: Databases

• Instructor Info
• Textbook
• Grading
• Schedule

Instructor Info

Instructor: Carl Sable
e-mail: CarlSable.Cooper@gmail.com
Office: Room 614

Textbook

"Database Management Systems, 3rd Edition"
Ramakrishnan and Gehrke

Grading

• Test #1: 25%
• Test #2: 25%
• Programming Project (due in parts): 50%

Schedule

The schedule will be updated as the semester progresses.

• Wednesday, January 19
  Course Overview
• Thursday January 20
  Introduction to Database Concepts
  Suggested reading: Ch. 1 of Ramakrishnan and Gehrke
• Wednesday, January 26
  The Entity-Relationship (ER) Data Model
  Suggested reading: Ch. 2 of Ramakrishnan and Gehrke
• Thursday, January 27
  NO CLASS! Cooper Union closed due to snow storm!
• Wednesday, February 2
  NO CLASS! No class due to STTR kickoff meeting.
• Thursday, February 3
  The Entity-Relationship (ER) Data Model (cont.)
• Wednesday, February 9
  The Relational Data Model
  Suggested reading: Ch. 3 of Ramakrishnan and Gehrke
• Thursday, February 10
  The Relational Data Model (cont.)
• Wednesday, Februray 16
  Relational Algebra
  Suggested reading: Ch. 4 of Ramakrishnan and Gehrke
• Thursday, February 17
  Relational Algebra (cont.)
• Wednesday, February 23
  SQL
  Suggested reading: Ch. 5 of Ramakrishnan and Gehrke
• Thursday, February 24
  SQL (cont.)
• Wednesday, March 2
  Java
• Thursday, March 3
  Java (cont.)
• Wednesday, March 9
  JDBC and MySQL
• Thursday, March 10
  JSP
• Wednesday, March 23
  MIDTERM
• Thursday, March 24
  Meetings with groups in my office
• Wednesday, March 30
  Files and Indexes
  Suggested reading: Ch. 8 of Ramakrishnan and Gehrke
• Thursday, March 31
  Files and Indexes (cont.)
• Wednesday, April 6
  Query Evaluation
  Suggested reading: Ch. 12 of Ramakrishnan and Gehrke
• Thursday, April 7
  Query Evaluation (cont.)
• Wednesday, April 13
  Transaction
  Suggested reading: Ch. 16 of Ramakrishnan and Gehrke
• Thursday, April 14
  Transactions (cont.)
• Wednesday, April 20
  Physical Database Design
  Suggested reading: Ch. 20 of Ramakrishnan and Gehrke
• Thursday, April 21
  Physical Database Design (cont.)
• Wednesday, April 27
  FINAL EXAM
• Thursday, April 21
  Discuss Final Exam (optional)
• Wednesday, May 4
  PROJECT DEMOS