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 Fall 2018

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

Nov. 7: A practice problem set on relational algebra is posted
Nov. 5: Solutions to Gradiance homework on recursive queries (HW6) are posted
Nov. 2: The JDBC assignment is posted and due Nov. 15 (11:59pm)
Oct. 29: A practice problem set on recursive queries is posted
Oct. 29: A Gradiance practice homework on recursive queries is posted (HW6). Solutions will be posted in a week.
Oct. 27: Solutions to the SQL assignment are posted
Oct. 26: A short Gradiance practice homework on views and triggers is posted (HW5). Solutions are posted here
Oct. 25: Solutions to Homework 1 are posted
Oct. 24: There will be a Q&A midterm review session held by Prof. Vianu on Tuesday Oct. 30, 6:30-7:30pm in WLH 2005
Also, Prof. Vianu will have extra office hours Wednesday 3-4pm right before the midterm.
Oct. 22: A Gradiance practice homework on null values is posted (HW4). Solutions are posted here
Oct. 19: Solutions to the second Gradiance Lab are posted
Oct 17. Homework 1 is posted and due Oct. 24, 11:59pm (see instructions)
Oct. 17: Solutions to Gradiance practice homework HW3 are posted
Oct. 17: A practice problem set on relational calculus and core SQL is posted
Oct. 15: The SQL assignment is posted and due Oct. 26 (11:59pm)
Oct. 15: Solutions to the first Gradiance Lab are posted
Oct. 12: Solutions to the Gradiance practice homeworks HW1 and HW2 are posted
Oct. 10: The second Gradiance SQL Lab is posted (closes Oct. 17, 11:59pm) extended to Oct. 18, 11:59pm
Oct. 10: A Gradiance practice homework on nested SQL queries is posted (HW3)
Oct. 8: The first Gradiance SQL Lab is posted (closes Oct. 12, 11:59pm)
Oct 8: Two Gradiance practice homeworks are posted (HW1 and HW2)
Oct. 4: A Gradiance practice homework on constraints is posted (HW0)

Staff


Schedule

. Mon Tue Wed Thu Fri
Lecture 5:00pm - 6:20pm
WLH 2005
. 5:00pm - 6:20pm
WLH 2005
. .
Discussion . . . . 10-10:50pm
LEDDN AUD
Professor Office Hours 6:30pm-7:30pm
CSE 4238
. 6:30pm-7:30pm
CSE 4238
. .
TA/tutor Office Hours 11:30am-12:30pm
Geisel Cubicle 4
1pm-2pm
CSE4254
2pm-3pm
B240A
10am-11am
B215
9:30am - 10:30am
B250A
12pm - 1pm
B275

Tentative Timeline

. Assigned Due
Gradiance Lab 1 Oct 8 Oct 12
Gradiance Lab 2 Oct 10 Oct 17
SQL Assignment Oct 15 Oct 26
Written Homework 1 Oct 17 Oct 24
Midterm Oct 31 .
JDBC Assignment Nov 2 Nov 15
Written Homework 2 Nov 19 Nov 28
Final Exam Dec 13 .