CSE132A: Database System Principles
Fall 2015
Tue, 09/24/15: The lecture slides will be posted right before each lecture on the "Lecture Notes" page. You can now find the slides of today's lecture.

General Course Info
The goal of this course is to introduce students to the basics of database management systems (DBMSs) with an emphasis on the relational model. The course covers many major concepts of relational databases: relational queries, query processing, data dependencies and their use in schema design. More advanced topics are covered as time allows and include novel data models for big data processing, such as object-oriented, semi-structured and XML. Students will get hands-on experience with a DBMS.

Announcements will be posted on the course web-page and/on the Piazza forum. Therefore please check both of them on a daily basis.
Instructor: Alin Deutsch
E-mail: deutsch [at] cs [dot] ucsd [dot] edu
Office: CSE 3238

TAs: Michael Brevard, Dmitriy Kunitsky, Rahul Ramath
E-mail: {mbrevard | dkunitsk | rramath} [at] eng [dot] ucsd [dot] edu

Tutors: Yuxiang Di, Qing Huang, Jiashen Wang
E-mail: {ydi | qih008 | jiw066} [at] ucsd [dot] edu

  Mon Tue Wed Thu Fri
Lectures 12:30-1:50pm Warren 2005 12:30-1:50pm Warren 2005
Discussion 7:00-7:50pm Peterson 108
Instructor Office Hours 9:00-10:00 CSE 3228 (and by email appointment)
TA Office Hours 1:00-2:00 CSE B275 (Rahul) 10:00-11:00 CSE B275 (Michael) 9:00-10:00 CSE B275 (Dmitriy)
Tutor Office Hours 4:00-5:00pm CSE B275 (Qing) 5:00-6:00pm CSE B275 (Yuxiang) 5:30-6:30pm
CSE basement hallway (Jiashen)
Grade Computation
Tentative requirements and weights in final grade (may be adjusted based on time allowance):

Homeworks: 15%
Programming assignments: 30%
Midterm (in class): 25%
Final: 30%
Main textbook (recommended but not required):

"Database System Concepts" by Silberschatz, Korth and Sudarshan, 6th Edition
A custom edition, containing just the material needed in this class (and 132B), is available at the bookstore. Please check the book web site for slides, practice exercises, and other supplementary material. The material posted on the web site is self-sufficient for this course.

Another recommended text:

"Database Systems: The Complete Book" by H. Garcia-Molina, J.Ullman and J. Widom, Prentice Hall

Those interested in delving deeper into database theory might consult this book:

"Foundations of Databases" by S.Abiteboul, R.Hull and V.Vianu, Addison-Wesley, 1995
Course Policies
Academic Integrity:
Plagiarism will not be tolerated. Incidents of plagiarism will be taken seriously, and could result in your expulsion from the University. Other penalties include, but are not limited to, receiving a grade of 0 for the assignment or test in question and receiving an 'F' for the course. The course policies regarding Integrity of Scholarship are described here. You are assumed to be familiar with the UCSD Policy on Integrity of Scholarship and the course policy as described in this document. If you have any questions about these policies, be sure to discuss them with the instructor.

Re-grade requests have to be made to the TA and will be accepted for one week only, starting from the day the assignment or exam is returned. If disagreements persist after the re-grade, please contact the instructor.

Late Assignments:
Makeups or extensions will not be granted except in true hardship cases, such as personal emergencies. In those cases makeups or extensions should be requested from the instructor as soon as possible and they may be granted only if you can provide adequate (and possibly documented) justification.

In the interest of managing a class of this size, please try to keep e-mail use to a minimum (and when you do, please try to be as brief and concise and possible). It is preferable to meet and discuss with the instructor or the TA during office hours instead. You should also take advantage of the Piazza forum (you can find the link on the left), which is an excellent way to discuss questions with the instructor, TA and your peers.