ECE 464: Databases

• Instructor Info
• Textbook
• Grading
• Schedule

Instructor Info

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

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 23
  Course Overview
• Thursday, January 24
  Introduction to Database Concepts
  Suggested reading: Ch. 1 of Ramakrishnan and Gehrke
• Wednesday, January 30
  The Entity-Relationship (ER) Data Model
  Suggested reading: Ch. 2 of Ramakrishnan and Gehrke
• Thursday, January 31
  The Entity-Relationship (ER) Data Model (cont.)
  The Relational Data Model
  Suggested reading: Ch. 3 of Ramakrishnan and Gehrke
• Wednesday, February 6
  The Relational Data Model (cont.)
• Thursday, February 7
  The Relational Data Model (cont.)
• Wednesday, February 13
  Relational Algebra
  Suggested reading: Ch. 4 of Ramakrishnan and Gehrke
• Thursday, February 14
  Relational Algebra (cont.)
• Wednesday, February 20
  SQL
  Suggested reading: Ch. 5 of Ramakrishnan and Gehrke
• Thuesday, February 21
  SQL (cont.)
• Wednesday, February 27
  Java Overview
• Thursday, February 28
  Java Overview (cont.)
• Wednesday, March 5
  Java Database Connectivity (JDBC)
• Thursday, March 6
  JDBC (cont.)
• Wednesday, March 12
  Java Server Pages (JSP)
• Thursday, March 13
  MIDTERM
• Wednesday, March 26
  JSP (cont.)
• Thursday, March 27
  Meetings with groups in my office
• Wednesday, April 2
  Files and Indexes
  Suggested reading: Ch. 8 of Ramakrishnan and Gehrke
• Thursday, April 3
  Files and Indexes (cont.)
• Wednesday, April 9
  Query Evaluation
  Suggested reading: Ch. 12 of Ramakrishnan and Gehrke
• Thursday, April 10
  Query Evaluation (cont.)
• Wednesday, April 16
  Transactions
  Suggested reading: Ch. 16 of Ramakrishnan and Gehrke
• Thursday, April 17
  Transactions (cont.)
• Wednesday, April 23
  Physical Database Design
  Suggested reading: Ch. 20 of Ramakrishnan and Gehrke
• Thursday, April 24
  Physical Database Design (cont.)
• Wednesday, April 30
  Review for Final Exam
• Thursday, May 1
  FINAL EXAM
• Wednesday, May 7
  PROJECT DEMONSTRATIONS
• Thursday, May 8
  PROJECT DEMONSTRATIONS