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 9
  Course Overview
• Monday, September 14
  Introduction to Database Concepts
  Suggested reading: Ch. 1 of Ramakrishnan and Gehrke
• Wednesday, September 16
  The Entity-Relationship (ER) Data Model
  Suggested reading: Ch. 2 of Ramakrishnan and Gehrke
• Monday, September 21
  The Entity-Relationship (ER) Data Model (cont.)
  The Relational Data Model
  Suggested reading: Ch. 3 of Ramakrishnan and Gehrke
• Wednesday, September 23
  The Relational Data Model (cont.)
• Monday, September 28
  Relational Algebra
  Suggested reading: Ch. 4 of Ramakrishnan and Gehrke
• Wednesday, September 30
  Relational Algebra (cont.)
• Monday, October 5
  SQL
  Suggested reading: Ch. 5 of Ramakrishnan and Gehrke
• Wednesday, October 7
  SQL (cont.)
• Monday, October 12
  Meetings with project groups
• Wednesday, October 14
  Java
• Monday, October 19
  Java (cont.)
• Wednesday, October 21
  JDBC and MySQL
• Monday, October 26
  JDBC and MySQL (cont.)
• Wednesday, October 28
  JSP
• Monday, November 2
  MIDTERM
• Wednesday, November 4
  JSP (cont.)
• Monday, November 9
  Meetings with project groups
• Wednesday, November 11
  Files and Indexing
  Suggested reading: Ch. 8 of Ramakrishnan and Gehrke
• Monday, November 16
  Files and Indexing (cont.)
• Wednesday, November 18
  Query Optimization
  Suggested reading: Ch. 12 of Ramakrishnan and Gehrke
• Monday, November 23
  Query Optimization (cont.)
• Wednesday, November 25
  Transactions
  Suggested reading: Ch. 16 of Ramakrishnan and Gehrke
• Monday, November 30
  Transactions (cont.)
• Wednesday, December 2
  Physical Database Tuning
  Suggested reading: Ch. 20 of Ramakrishnan and Gehrke
• Monday, December 7
  Physical Database Design (cont.)
• Wednesday, December 9
  Distributed Databases
  Suggested reading: Ch. 22 of Ramakrishnan and Gehrke
• Monday, December 14
  FINAL EXAM
• Wednesday, December 16
  PROJECT PRESENTATIONS
• Monday, December 21
  PROJECT PRESENTATIONS