DEPARTMENT OF
Computer Science and Engineering

CS 166 - Database Management Systems
Chotirat  "Ann"  Ratanamahatana

FALL 2004

Home | Schedule | Assignments | Resources | Project

 

HOME

 News & Announcements
09/23 Syllabus

10/03 PostgreSQL Manual

10/05 HOMEWORK 1 is posted. Due: Thu 10/14 at the beginning of the class.

10/06 QUIZ 1 Solution Graded by Lan Liu.

10/14 Vote Result: Midterm Exam will be on Tue Nov 9

10/15 Programming Assignment 1 is posted. Due: Thur 10/28 at noon (electronic turnin). Hardcopy is due in class. Download the data here.

10/20 Homework1 SOLUTION

10/28 Final Project is posted.

10/31 Programming Assignment 1 solution is here.

11/1 Midterm Review questions are posted (see Lecture Notes section below). Make sure you bring a copy to class this week. The solutions will ONLY be given out in class.

11/3 Quiz 3 and Programming assignment Solutions are here.

11/4 Midterm Review questions...solutions to questions 6 and 7 .

11/10 Midterm SOLUTIONS...Version A Version B. Updated 12/7.

11/12 HOMEWORK 2 is posted (updated 11/16, on problem 3a.). Due: Tue 11/23 at the beginning of the class.

11/14 Java driver files is posted.

11/19 There will be NO lecture on Tue. Nov 23. I'll be in my office (Surge 348) during the class hours answering questions about the project. Homework 2 can be dropped off in Surge 356 any time before the deadline. PDF file submission for the homework is also accepted via email for your convenience.

11/23 HOMEWORK 3 is posted. Due: Thu 12/2 at the beginning of class.

11/24 Homework 2 SOLUTION Updated Nov 25.

11/29 Review questions for final exam are posted (see Lecture Notes section below). Please bring a copy to class this week.

12/7 Final Exam will be on Saturday, Dec 11 (OLMH 1208), 11:30am - 2:30pm. BRING A SCANTRON (882-E), pencil, and Photo ID.

Current scores Updated December 11, 2004. Final Scores are in!!

Instructor:

Ann Ratanamahatana
Office Hours: Tu & Th 2:30-3:30 pm Surge 348 / Surge 356

Lecture Notes

Mailing List

cs166@lists.cs.ucr.edu
Click on the icon to open the sign-up page
Click on the icon to open the archives page

Classes

Tuesdays & Thursdays
3 :40pm - 5:00pm
OLMH 1208

Note: See Lab Sections and TAs below! 

Grading

  • 10% Lab Attendance / pop quizzes

  • 10% Homework

  • 25% Midterm Exam

  • 30% Programming Assignments

  • 25% Final Exam

Syllabus
 
Ch.1: Overview of Database Systems
Ch.2: Introduction to Database Design
Ch.3: The Relational Model
Ch.4: Relational Algebra
Ch.5: SQL
Ch.8: Storage and Indexing
Ch.9: Storing Data: Disks and Files
Ch.10: Tree-Structured Indexing
Ch.11: Hash-Based Indexing
Ch.26: Data Mining

Note: If time permits, more chapters will be added.

Textbook

"Database Management Systems" 3rd Edition
by Ramakrishnan and Gehrke

Lab Sections

Section TA When? Where? Contact this TA!
21 & 23
 
Mon 8:10am-11am
Mon 2:10pm-5pm
 
SURGE, 283
SURGE, 283
Office hrs: M 11am-noon & Th: 2:30 - 3:30pm
SURGE 357
22 
Mon 11:10am-2pm
SURGE, 283
lliu@cs.ucr.edu
Office hrs:M 10:10-11:10
   SURGE 350