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

Database Systems Principles
CSE132A Winter 2020

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

Mar. 14: Solutions to Gradiance practice homework on concurrency control (HW9) are posted
Mar. 3 A practice problem set on concurrency control is posted
Mar. 3: A Gradiance practice homework on concurrency control is posted (HW9)
Mar. 2: Solutions to Homework 2 are posted on Piazza
Mar. 2: Solutions to Gradiance practice homeworks HW7 and HW8 are now posted
Feb. 28: Homework 3 is posted and due Mar. 9, 11:59pm (see instructions)
Feb. 27 A practice problem set on schema design is posted
Feb. 27 A Gradiance practice homework on normal forms is posted (HW8)
Feb. 25: A Gradiance practice homework on functional dependencies is posted (HW7)
Feb. 20: Homework 2 is posted and due Feb. 28, 11:59pm (see instructions)
Feb. 21: A practice problem set on join minimization is posted
Feb. 12: The JDBC assignment is posted and due Feb. 21 (11:59pm)
Feb. 12: A practice problem set on relational algebra is posted
Feb. 12: Solutions to Gradiance practice homeworks HW5 and HW6 are posted
Feb. 12: A practice problem set on recursive queries is posted
Feb. 5: There will be a midterm review session on Wed. Feb. 5, 8-9pm in CENTR 212
Jan. 31: Solutions to Gradiance practice homework HW4 are posted
Jan. 30: Gradiance practice homeworks on triggers (HW5) and recursive queries (HW6) are posted
Jan. 28: A Gradiance practice homework on null values is posted (HW4)
Jan. 23: Homework 1 is posted and due Jan. 31, 11:59pm (see instructions)
Jan. 23: A practice problem set on relational calculus and core SQL is posted
Jan. 23: Solutions to Gradiance practice HW3 are posted
Jan. 22: Solutions to the second Gradiance Lab are posted
Jan. 21: The SQL assignment is posted and due Feb. 3 (11:59pm)
Jan. 20: Solutions to Gradiance HW0,HW1,HW2 and the first Gradiance Lab are posted
Jan. 16: The second Gradiance SQL Lab is posted (closes Jan. 21, 11:59pm)
Jan. 16: A Gradiance practice homework on nested SQL queries is posted (HW3)
Jan. 14: The first Gradiance SQL Lab is posted (closes Jan. 17, 11:59pm)
Jan. 14: Two Gradiance practice homeworks on SQL are posted (HW1 and HW2)
Jan. 9: 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
MANDE B-210
. 5:00pm - 6:20pm
MANDE B-210
.
Discussion . . .
.
1:00pm-1:50pm
PCYNH 106
Professor Office Hours . 6:45pm-7:45pm
CSE 4238
. 6:45pm-7:45pm
CSE 4238
.
TA/tutor Office Hours 12pm-1pm
B270
3pm-4pm
B270A
12pm-1pm
B270
10:30am-11:30am
B270A
2pm-3pm
B250A

Tentative Timeline

. Assigned Due
Gradiance Lab 1 Jan 14 Jan 17
Gradiance Lab 2 Jan 16 Jan 21
SQL Assignment Jan 21 Feb 3
Written Homework 1 Jan 23 Jan 31
Midterm Feb 6 .
JDBC Assignment Feb 12 Feb 21
Written Homework 2 Feb 20 Feb 28
Written Homework 3 Feb 28 Mar 2
Final Exam Mar 19 .

Grading

Requirements and tentative weights:

  • Two Gradiance SQL Labs, each counting for 3% of your final grade (6% total)
  • Three written problem sets, counting for 5%, 2%, and 3% 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 17% 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 is not graded but is strongly encouraged

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.