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 3
  Course Overview
  Introduction to Database Concepts
  Suggested reading: Ch. 1 of Ramakrishnan and Gehrke
• Thursday, September 4
  Introduction to Database Concepts (cont.)
• Wednesday, September 10
  The Entity-Relationship (ER) Data Model
  Suggested reading: Ch. 2 of Ramakrishnan and Gehrke
• Thursday, September 11
  The Entity-Relationship (ER) Data Model (cont.)
  Project Proposals Assigned
• Wednesday, September 17
  The Relational Data Model
  Suggested reading: Ch. 3 of Ramakrishnan and Gehrke
• Thursday, September 18
  Relational Algebra
  Suggested reading: Ch. 4 of Ramakrishnan and Gehrke
• Wednesday, September 24
  Relational Algebra (cont.)
• Thursday, September 25
  SQL
  Suggested reading: Ch. 5 of Ramakrishnan and Gehrke
• Wednesday, October 1
  SQL (cont.)
• Thursday, October 2
  SQL (cont.)
• Wednesday, October 8
  Java
• Thursday, October 9
  Java (cont.)
• Wednesday, October 15
  JDBC and MySQL
• Thursday, October 16
  JDBC and MySQL (cont.)
• Wednesday, October 22
  MIDTERM
• Thursday, October 23
  JSP
• Wedneday, October 29
  JSP (cont.)
• Thursday, October 30
  Files and Indexes
  Suggested reading: Ch. 8 of Ramakrishnan and Gehrke
• Wednesday, November 5
  Files and Indexes (cont.)
• Thursday, November 6
  Query Evaluation
  Suggested reading: Ch. 12 of Ramakrishnan and Gehrke
• Wednesday, November 12
  Query Evaluation (cont.)
• Thursday, November 13
  Transaction
  Suggested reading: Ch. 16 of Ramakrishnan and Gehrke
• Wednesday, November 19
  Transactions (cont.)
• Thursday, November 20
  Physical Database Design
  Suggested reading: Ch. 20 of Ramakrishnan and Gehrke
• Tuesday, November 25 (Thursday schedule)
  Physical Database Design (cont.)
• Wednesday, December 3
  NoSQL and MongoDB
• Thursday, December 4
  NoSQL and MongoDB (cont.)
• Wednesday, December 10
  FINAL EXAM
• Friday, December 12
  PROJECT DEMOS