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, September 5
  Course Overview
  Introduction to Database Concepts
  Suggested reading: Ch. 1 of Ramakrishnan and Gehrke
• Thursday September 6
  Introduction to Database Concepts (cont.)
  The Entity-Relationship (ER) Data Model
  Suggested reading: Ch. 2 of Ramakrishnan and Gehrke
• Wednesday, September 12
  The Entity-Relationship (ER) Data Model (cont.)
• Thursday, September 13
  The Entity-Relationship (ER) Data Model (cont.)
  The Relational Data Model
  Suggested reading: Ch. 3 of Ramakrishnan and Gehrke
• Wednesday, September 19
  The Relational Data Model (cont.)
• Thursday, September 20
  Relational Algebra
  Suggested reading: Ch. 4 of Ramakrishnan and Gehrke
• Wednesday, September 26
  Relational Algebra (cont.)
  SQL
  Suggested reading: Ch. 5 of Ramakrishnan and Gehrke
• Thursday, September 27
  SQL (cont.)
• Wednesday, October 3
  Java
• Thursday, October 4
  Java (cont.)
• Wednesday, October 10
  Meetings with groups in Rmn. 101
• Thursday, Ocrtober 11
  JDBC and MySQL
• Wednesday, October 17
  JDBC and MySQL (cont.)
• Thursday, October 18
  JSP
• Wednesday, October 24
  MIDTERM
• Wednesday, October 31
  COOPER CLOSED DUE TO HURRICANE SANDY
• Thursday, November 1
  COOPER CLOSED DUE TO HURRICANE SANDY
• Wednesday, November 7
  JSP (cont.)
  Files and Indexes
  Suggested reading: Ch. 8 of Ramakrishnan and Gehrke
• Thursday, November 8
  Files and Indexes (cont.)
• Wednesday, November 14
  MongoDB and NoSQL
  Lecture presented by Yaniv Eyny
• Thursday, November 15
  CLASS CANCELLED
• Wednesday, November 21
  Query Evaluation
  Suggested reading: Ch. 12 of Ramakrishnan and Gehrke
• Thursday, November 22
  Query Evaluation (cont.)
• Wednesday, November 28
  Transaction
  Suggested reading: Ch. 16 of Ramakrishnan and Gehrke
• Thursday, November 29
  Transactions (cont.)
• Wednesday, December 5
  Physical Database Design
  Suggested reading: Ch. 20 of Ramakrishnan and Gehrke
• Thursday, December 6
  Physical Database Design (cont.)
• Wednesday, December 12
  FINAL EXAM
• Friday, December 14
  PROJECT DEMOS