University of California, Berkeley

CS 186: Introduction to Database Systems

Fall 2003 - Eben Haber

[Basic Info and Times] [Resources] [Homeworks] [Syllabus and Lecture Notes]

Announcements and Upcoming Events:

12/26 - I have submitted the grades. After hearing many complaints about my grade cutoffs, I checked with the department and found that I don't have to stick to a strict 2.9 average. I moved the average up to 3.0, so some of you will see better grades. Merry Christmas! (Given the amount of complaining I received about the old cutoffs from people asking to be rounded up, however, I will not post the new cutoffs.)
12/18 - The final weighting of assignments and grade cutoffs have been decided:

Project 1	13%
Project 2	10%
Project 3	8%
Project 4	15%
Project 5	12%
Midterm	15%
Final Exam	27%

A	90-100
A-	85-90
B+	80-85
B	72-80
B-	67-72
C+	62-67
C	56-62
C-	50-56
D	40-50
F	0-40

12/11 - You can find all in-class exercises and the keys here.
12/9 - Sample final exams from past CS186s can be found here, here, and here. As always, past performance is *no* guarantee of future exams. A solution for s2000 is here, I don't have solutions for the others.
12/7 - Solution to Homework 3 can be found here.
12/4 - A new version of the Homework 5 assignment is available, including the performance section and what to hand in.
12/1 - Final Review Session on December 9 from 1pm-3pm in 306 Soda.
11/20 - The first part of Homework 5 is available here. More will be added later.
11/10 - After lots of debugging, Homework 4 is now available here.
11/5 - The solution for in-class exercise 5 can be found here.
10/30 - Homework 3 is due at 7pm, Sunday.
10/29 - Homework 3 Part II has been updated. Use the same link below.
10/26 - Midterm solutions are available here.
10/23 - Homework 3 is now available. This is to be done individually!!! Not in groups!!!
10/16 - Section for next week (10/20-10/21) is cancelled.
10/14 - The exam rooms may be booked until 6pm, so we may not start until somewhat after. You will receive 2 hours to finish the exam.
10/14 - Eben Haber will hold extra office hours today, from 1:30pm - 2:30pm. There will be no office hours on Thursday.
Slides from the midterm review session are available here.
In-Class Exercises: if you want the solutions to the in-class exercises on Relational Algebra or Calculus, you can find the answers in the on-line lecture notes for lectures 4 and 6. The key for the ER in class exercise can be found here.
10/10 - The midterm will be held Tuesday, 10/14, 6pm - 8:30pm, in 2040 and 2060 VLSB.

Distribution between the two rooms will be done by the last digit of your student id number. If it is even, go to 2040. If it is odd, go to 2060.

Some sample midterms from past classes can be found at: http://hkn.eecs.berkeley.edu/cgi-bin/exam-query.cgi?cs186
The TAs will hold a midterm review session on Sunday, 10/12 in 306 Soda from 1pm to 3pm.
Some additional midterms from past classes can be found here.

10/7 - Solutions to the written portions of hw1 are available here.
9/30 - The screenshots for hw2 are now up. You can find them here.
9/30 - The answer key for the in-class SQL exercise is here, as is a version of the Sailors database that you can load into postgres.
9/23 - The assignment for Homework 2 is now available.
9/23 - The midterm exam will be held Tuesday, October 14th, 6pm - 8pm.
9/14 - The deadline for the first part of Homework 1 has been pushed back to midnight tonight.
9/11 - You need to register your project group before submitting the homework assignment. You must be in a group of 3.
9/11 - Office hours for Eben Haber will be Thursdays, 1:30-2:30pm, and other times by appointment.
9/10 - Please note that the original Homework 1 assignment had some typos in the MRU example section. They have been corrected.
9/6 - Homework 1 is now available. It is due in two parts. The first part will be due Sunday, September 14 at 7pm PDT. The second part will be due Thursday, September 18, at 7pm PDT.
8/24 - Homework 0 is now available. It will be due 5pm on September 4th. Also, discussion sections will be held on 8/25 and 8/26 to hand out instructional account forms and discuss the homework.
8/21 - This website under construction, much information will appear in the next few days.