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 Gradiance SQL Labs, each counting for 2% of the final grade (4% total)
Three written problem sets, counting for 4%, 2%, and 3% of the final grade (9% total)
An SQL programming assignment, which counts for 14% of the final grade
A JDBC programming assignment, which counts for 13% of the final grade
One midterm, which counts for 30% of the final grade
A final exam, which counts for 30% of the final grade
All assignments are individual.
Logistics
The class website is hosted on Canvas. Lectures and discussions and will be podcast.
Attendance is optional but strongly encouraged. Lecture slides will be posted at least one day before each lecture.
Office hours will be offered daily. The exams will take place in person.
Contact
For questions please contact the instructor, Victor Vianu, at vianu@ucsd.edu
