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

Database Systems Principles
CSE132A Winter 2017

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. 15: There will be a Q&A final review session on Friday 3/17 at 6pm in CENTR 115
I will also have office hours on Monday 3/20 3-4 pm and TA office hours will be posted on Piazza
Mar. 14: Solutions to Homework 2 are posted
Mar. 13 A practice problem set on concurrency control is posted
Mar. 13: A Gradiance practice homework on concurrency control is posted (HW9)
Mar. 8 A practice problem set on schema design is posted
Mar. 8: A Gradiance practice homework on normal forms is posted (HW8)
Mar. 2: A Gradiance practice homework on functional dependencies is posted (HW7)
Mar. 2: Homework 2 is posted and due Mar. 13, 11:59pm (see instructions)
Feb. 28: A practice problem set on join minimization is posted
Feb. 16: The JDBC assignment is posted and due Mar. 3 (11:59pm)
Feb. 16: Solutions to the midterm are posted
Feb. 14: Solutions to Gradiance homeworks HW5 and HW6 are posted
Feb. 14: A Q&A midterm review session will be held today 7pm in CENTR 115. Please bring your questions
Feb. 14: Solutions to Homework 1 are posted
Feb. 14: Happy Valentine's Day !!
Feb. 13: Solutions to the queries and updates of the SQL assigment are posted
Feb. 9: A practice problem set on relational algebra is posted
Feb. 6: A practice problem set on recursive queries is posted
Feb. 6: Gradiance practice homeworks on views and triggers (HW5) and recursive queries (HW6) are posted
Feb. 6: There will be a Q&A midterm review session held by Prof. Vianu on Feb 14 7-8pm in CENTR 115
Also, Prof. Vianu will have extra office hours Wednesday 3-4pm right before the midterm.
Feb. 3: Homework 1 is posted and due Feb. 13, 11:59pm (see instructions)
Feb. 2: Solutions to the second Gradiance Lab are posted
Feb. 1: The SQL assignment is posted and due Feb. 10 (11:59pm)
Jan. 30: A Gradiance practice homework on null values is posted (HW4, solutions here)
Jan. 30: A practice problem set on relational calculus and core SQL is posted
Jan. 26: The second Gradiance SQL Lab is posted (closes Feb. 1, 11:59pm)
Jan. 26: Solutions to the first Gradiance Lab are posted
Jan. 19: A Gradiance practice homework on nested SQL queries is posted (HW3, solutions here)
Jan. 12: Two Gradiance practice homeworks on SQL are posted (HW1 and HW2, solutions here)
Jan. 11: The first Gradiance SQL Lab is posted (closes Jan. 25, 11:59pm)
Jan. 11: A Gradiance practice homework on constraints is posted (HW0)
Jan. 9: The first discussion section will be on Friday Jan. 13

The Friday and following Monday discussions will cover the same material (the previous week's lectures).
Please attend one of the two weekly discussion sections.


Staff


Schedule

. Mon Tue Wed Thu Fri
Lecture 5:00pm - 6:20pm
LEDDEN
. 5:00pm - 6:20pm
LEDDEN
. .
Discussion 3-3:50pm
CENTR 109
. . .
.
12-12:50pm
YORK 2622
Professor Office Hours 6:30pm-7:30pm
CSE 4238
. 6:30pm-7:30pm
CSE 4238
. .
TA/tutor Office Hours 4-5pm
B260A
10:30am-11:30am
B260A
4-5pm
B260A
9-10am
B260A
5-6pm
CSE3217

Tentative Timeline

. Assigned Due
Gradiance Lab 1 Jan 11 Jan 25
Gradiance Lab 2 Jan 26 Feb 1
SQL Assignment Feb 1 Feb 10
Written Homework 1 Feb 3 Feb 13
Midterm Feb 15 .
JDBC Assignment Feb 16 Mar 3
Written Homework 2 Mar 2 Mar 13
Final Exam Mar 20 .