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.

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. 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: Pankhuri Choudhary, Saurabh Goyal, Vikram Sirupurapu, Marisya Tran
E-mail: {pachoudh, s2goyal, vsirupur, t2tran} [at] ucsd [dot] edu

Tutors: none

	Mon	Tue	Wed	Thu	Fri
Lectures	2:00-2:50pm Pepper Canyon Hall 109		2:00-2:50pm Pepper Canyon Hall 109		2:00-2:50pm Pepper Canyon Hall 109
Discussion					12:00-12:50pm Pepper Canyon Hall 106
Instructor Office Hours			12:30pm-1:30pm CSE 3238 (other times by email appointment)
TA Office Hours	9:30-10:30am CSE B240A (Marisya)	10:00-11:00am CSE B270A (Pankhuri)	8:00-9:00am TBD (Saurabh)	9:00-10:00am CSE B250A (Vikram)

Tentative requirements and weights in final grade (may be adjusted based on time allowance):

Homeworks (2): 25%
Programming assignments (2): 30%
Midterm (in class): 15%
Final: 30%

Main textbook (recommended but not required):

"Database System Concepts" by Silberschatz, Korth and Sudarshan, 6th Edition
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

Academic Integrity:
Plagiarism will not be tolerated. Incidents of plagiarism will be taken seriously and reported to the Academic Integrity Office. They could result in 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:
Re-grade requests have to be made to the TAs 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.

E-mail:
In the interest of managing a class of this size, please try to keep e-mail use to a minimum. 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, which is an excellent way to discuss questions with the instructor, TA and your peers.