| Home What's New Staff Course Policies Resources Text Slides Gradiance Reading List Homework Sets Projects Exams & Practice Problems Grades Computation Statistics |
Database Systems Principles
CSE132A Winter 2012
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. 16: The final review session will take place on Wednesday Mar 21 at 5pm in CENTER 222. Please bring your questions.Mar. 13: Practice problems on concurrency control are posted
Mar. 13: Solutions to Homework 2 are posted
Mar. 9: The scores for the JDBC project are now posted on gradesource. Here is a note on the scoring policy
Mar. 6: Homework 2 on SQL minimization and schema design is posted and due Mar 13 at 5pm (in class and also electronically using the turnin program).
Feb. 16: Midterm solutions are posted
Feb. 14: The Manga way to databases
Feb. 14: Solutions to Homework 1 are posted
Feb. 9: A midterm review session will take place Wednesday Feb 15, 7pm-8pm in CENTER 113. Please bring your questions!
Feb. 8: A set of practice problems on relational calculus and algebra is posted
Feb. 7: Homework 1 on tuple calculus and relational algebra is posted and due Feb 14 (in class)
Feb. 7: Solutions to the SQL assignment are posted
Feb. 1: The midterm is set for Thursday, Feb. 16
Feb. 1: Solutions to the SQL Labs are posted
Jan. 24: The SQL assignment is posted and due Feb 6, 11:59pm
Jan. 24: Second Gradiance SQL Lab is assigned and due Jan 31, 11:59pm
Jan. 19: First Gradiance SQL Lab is assigned and due Jan 26, 11:59pm
Jan. 17: Gradiance class token has been emailed. Please contact the instructor if you have not received it
Jan. 12: The first discussion section will take place on Friday January 20 (time and place TBA)
Staff
- Professor: Victor Vianu, vianu@cs.ucsd.edu, Office: CSE 4238, Phone: 858-534-6227
- TAs: Gen Liu: gel016@eng.ucsd.edu and Chen Xie: chen@cs.ucsd.edu
Schedule
| . | Mon | Tue | Wed | Thu | Fri |
|---|---|---|---|---|---|
| Lecture | . | 5:00pm - 6:20pm CSB 001 |
. | 5:00pm - 6:20pm CSB 001 |
. |
| Discussion | 11am-12pm PCYNH 122 |
. | . . |
. | 11am-12pm CENTR 105 |
| TA Office Hours | 10-11am B250A |
. | . | . | 10-11am B250A |
| Professor Office Hours | . | 3:30pm-4:30pm CSE 4238 |
. | 3:30pm-4:30pm CSE 4238 |
. |
