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%
  Click here for instructions on submitting proposals
  Click here for instructions on submitting schemas
  Click here for instructions on submitting final write-ups

Schedule

The schedule will be updated as the semester progresses.

• Wednesday, September 7
  Course Overview
  Introduction to Database Concepts
  Suggested reading: Ch. 1 of Ramakrishnan and Gehrke
• Thursday, September 8
  Introduction to Database Concepts (cont.)
  The Entity-Relationship (ER) Data Model
  Suggested reading: Ch. 2 of Ramakrishnan and Gehrke
• Wednesday, September 14
  The Entity-Relationship (ER) Data Model (cont.)
• Thursday, September 15
  Project Proposals Assigned
  The Relational Data Model
  Suggested reading: Ch. 3 of Ramakrishnan and Gehrke
• Wednesday, September 21
  The Relational Data Model (cont.)
• Thursday, September 22
  Relational Algebra
  Suggested reading: Ch. 4 of Ramakrishnan and Gehrke
• Wednesday, September 28
  Relational Algebra (cont.)
  SQL
  Suggested reading: Ch. 5 of Ramakrishnan and Gehrke
• Thursday, September 29
  SQL (cont.)
• Wednesday, October 5
  SQL (cont.)
  Java
• Thursday, October 6
  Java (cont.)
• Wednesday, October 12
  Java (cont.)
  Project Schemas Assigned
• Thursday, October 13
  JDBC and MySQL
• Wednesday, October 19
  JDBC and MySQL (cont.)
  JSP
• Thursday, October 20
  JSP (cont.)
• Wedneday, October 26
  Midterm review
• Thursday, October 27
  MIDTERM
• Wednesday, November 2
  Files and Indexes
  Suggested reading: Ch. 8 of Ramakrishnan and Gehrke
• Thursday, November 3
  Files and Indexes (cont.)
• Wednesday, November 9
  Query Evaluation
  Suggested reading: Ch. 12 of Ramakrishnan and Gehrke
• Thursday, November 10
  Query Evaluation (cont.)
• Wednesday, November 16
  Transaction
  Suggested reading: Ch. 16 of Ramakrishnan and Gehrke
• Thursday, November 17
  Transactions (cont.)
• Tuesday, November 22 (Thursday schedule)
  Physical Database Design
  Suggested reading: Ch. 20 of Ramakrishnan and Gehrke
• Wednesday, November 30
  Physical Database Design (cont.)
• Thursday, December 1
  NoSQL and MongoDB
• Wednesday, December 7
  Final exam review
• Thursday, December 8
  FINAL EXAM
• Monday, December 19
  PROJECT DEMOS