| Home What's New Staff Course Policies Syllabus Text Transparencies Reading List Homework Sets Projects Exams & Practice Problems Grades Computation Statistics |
Database Systems Principles
CSE132A Fall 2009
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 on this class web page. A substantial part of the site will be in HTML, PDF and PS formats. Please configure your browsers accordingly. Please check the web page often, especially before the exams. You can download Adobe Acrobat Reader by clicking on the icon below.
What's New
Nov 19: The second homework is posted and due Thursday, December 3, 11:59pm (pdf file using turnin)Nov 5: The second project is posted and due Wednesday Nov 25
Nov 5: Midterm solutions are posted
Oct 30: A midterm review session will take place on Wednesday Nov. 4, 6:30pm-7:30pm in CSE 2154. Please bring your questions!
Oct 30: Solutions to Homework 1 are posted
Oct 21: Solutions to the SQL assignment are posted
Oct. 20: The midterm is set for Thursday Nov 5. It will cover query languages (SQL, QBE, relational calculus and algebra)
Oct 20: A homework set on queries has been posted and is due Thursday, Oct 29
Oct 20: A set of practice problems and solutions on queries has been posted
Oct 20: Anu will have extended office hours on Wed Oct 21 from 1pm to 3pm
Oct 6: The SQL assignment is posted and due October 21 (11:59pm)
Oct 6: As announced earlier, class is canceled on Thursday Oct. 8
Oct 6: The discussion session is scheduled on Wednesdays 12pm-12:50pm in CSE 004
Oct 1: Lecture is moved to CSE (EBU3B) 2154
Staff
- Professor: Victor Vianu, vianu@cs.ucsd.edu, Office: CSE 4238, Phone: 858-534-6227
- TA: Anupallavi Mupparthi (aka Anu): cs132a1@ieng6.ucsd.edu
Schedule
| . | Mon | Tue | Wed | Thu | Fri |
|---|---|---|---|---|---|
| Lecture | . | 6:30pm - 7:50pm CSE 2154 |
. | 6:30pm - 7:50pm CSE 2154 |
. |
| Discussion | . | . | 12:00pm-12:50pm CSB 004 |
. | . |
| TA Office Hours | 12pm-1pm CSE B250A |
. | 1pm-2pm CSE B250A |
. | . |
| Professor Office Hours | . | 4:30pm-5:30pm CSE 4238 |
. | 4:30pm-5:30pm CSE 4238 |
. |
