Home
    What's New
    Staff
Course Policies
Resources
    Text
    Slides
    Gradiance
    Piazza
    Reading List
Homework Sets
Projects
Practice Problems

Database Systems Principles
CSE132A Winter 2019

The course presents the basic concepts of database systems, emphasizing the relational model. Several major issues of relational database theory are covered: relational queries (algebra and calculus), query processing, data dependencies and their use in schema design and query optimization, basic concurrency control. More advanced topics are covered as time allows and include object-oriented databases and data on the Web. Students become familiar with at least one commercial database system.

Homework assignments, projects, solutions, and many announcements will be posted on this class web page. A substantial part of the site will be in PDF format. Please configure your browsers accordingly. Please check the web page often, especially before the exams.


What's New

Feb. 22: A practice problem set on join minimization is posted
Feb. 12: A practice problem set on relational algebra is posted
Feb. 12: The JDBC assignment is posted and due Feb. 22 (11:59pm)
Feb. 6: A practice problem set on recursive queries is posted
Feb. 6: A Gradiance practice homework on recursive queries (HW6) is posted
Feb. 5: Solutions to Homework 1 and the SQL assignment are posted
Feb. 4: Solutions to Gradiance practice homeworks HW4 and HW5 are posted
Jan. 31: A short Gradiance practice homework on views and triggers is posted (HW5)
Jan. 31: A Gradiance practice homework on null values is posted (HW4)
Jan. 24: Homework 1 is posted and due Feb. 1, 11:59pm (see instructions)
Jan. 24: A practice problem set on relational calculus and core SQL is posted
Jan. 24: Solutions to Gradiance practice HW3 are posted
Jan. 23: Solutions to the second Gradiance Lab are posted
Jan. 22: The SQL assignment is posted and due Feb. 4 (11:59pm)
Jan. 22: Solutions to Gradiance HW0,HW1,HW2 and the first Gradiance Lab are posted
Jan. 17: The second Gradiance SQL Lab is posted (closes Jan. 22, 11:59pm)
Jan. 17: A Gradiance practice homework on nested SQL queries is posted (HW3)
Jan. 15: The first Gradiance SQL Lab is posted (closes Jan. 18, 11:59pm)
Jan. 15: Two Gradiance practice homeworks on SQL are posted (HW1 and HW2)
Jan. 11: A Gradiance practice homework on constraints is posted (HW0). Solutions will be posted in a week

Staff


Schedule

. Mon Tue Wed Thu Fri
Lecture . 5:00pm - 6:20pm
YORK 2622
. 5:00pm - 6:20pm
YORK 2622
.
Discussion . . .
.
5:00pm-5:50pm
WLH 2005
Professor Office Hours . 6:45pm-7:45pm
CSE 4238
. 6:45pm-7:45pm
CSE 4238
.
TA/tutor Office Hours 1pm-2pm
B215
9am-10am
B275
2pm-3pm
Geisel 2nd East
TA Cubicle 4
2:30pm-3:30pm
B270A
4pm-5pm
B240A

Tentative Timeline

. Assigned Due
Gradiance Lab 1 Jan 15 Jan 18
Gradiance Lab 2 Jan 17 Jan 22
SQL Assignment Jan 22 Feb 4
Written Homework 1 Jan 24 Feb 1
Midterm Feb 7 .
JDBC Assignment Feb 12 Feb 22
Written Homework 2 Feb 27 Mar 8
Final Exam Mar 21 .

Grading

Requirements and tentative weights:

  • Two Gradiance SQL Labs, each counting for 3% of your final grade (6% total)
  • Two written problem sets, each counting for 5% of your final grade (10% total)
  • An SQL programming assignment, which counts for 17% of your final grade
  • A JDBC programming assignment, which counts for 16% of your final grade
  • One midterm, which counts for 25% of your final grade
  • A final exam, which counts for 25% of your final grade
  • Class participation via clickers, 1% of the final grade proportional to participation

Cutoffs:

Cutoff (>= x) Grade
96 A+
90 A
86 A-
82 B+
80 B
76 B-
72 C+
70 C
65 C-
55 D
<55 F

These cutoffs on the total score are a minimum guarantee on the grade.
The thresholds might be decreased later depending on the distribution, but not increased.