CSE 132A: Database Systems Principles

What this course is about

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. Students become familiar with SQL and JDBC. Working knowledge of Java is assumed.

Requirements and tentative weights

Two SQL Labs, each counting for 3% of the final grade (6% total)
Three written problem sets, counting for 5%, 2%, and 3% of the final grade (10% total)
An SQL programming assignment, which counts for 17% of the final grade
A JDBC programming assignment, which counts for 17% of the final grade
One midterm, which counts for 25% of the final grade
A final exam, which counts for 25% of the final grade

All assignments are individual.

Remote logistics

The class website will be hosted on Canvas. Lectures will be delivered sychronously via zoom and recoded for asynchronous viewing. Attendance is optional but strongly encouraged. The lecture recordings will be made available and lecture slides will be posted at least one day before each lecture. Office hours and the discussion session will also take place via zoom.