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

Jan. 18: A Gradiance practice homework on nested SQL queries is posted (HW3)
Jan. 18: The first Gradiance SQL Lab is posted (closes Jan. 25, 11:59pm)
Jan. 16: Two Gradiance practice homeworks on SQL are posted (HW1 and HW2)
Jan. 11: A Gradiance practice homework on constraints is posted (HW0)
Jan. 11: The first discussion section will be on Friday Jan. 19

Staff


Schedule

. Mon Tue Wed Thu Fri
Lecture . 5:00pm - 6:20pm
CENTER 115
. 5:00pm - 6:20pm
CENTER 115
.
Discussion . . .
.
4:00pm-4:50pm
PCYNH 106
Professor Office Hours . 6:30pm-7:30pm
CSE 4238
. 6:30pm-7:30pm
CSE 4238
.
TA/tutor Office Hours 11am-12pm
B215
2pm-3pm
B215
11am-12pm
B250A

5pm-6pm
B270A
3pm-4pm
B275
11:30am-12:30pm
B275

Tentative Timeline

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