Instructor:

Amol Deshpande
Email: amol at cs dot umd dot edu
Office hours: TBA, or by appointment.
Office AVW 3221, Tel. 301-405-2703

Teaching Assistants:

Walaa Eldin Moustafa (Email: walaa at cs dot umd dot edu)
Office hours: Monday 2pm-3pm, Thursday 1pm-2pm
Office: TA Room

Prerequisite:

Minimum grade of C- in CMSC351 and CMSC330; and permission of CMNS-Computer Science department. Or Must be in the (Computer Science (Doctoral), Computer Science (Master's)) program. The goal of this course is to introduce students to database systems and motivate the database approach as a mechanism for modeling the real world. The course will cover in depth the relational model, logical database design, query languages, and other database concepts including query optimization, concurrency control, transaction management, and log based crash recovery. Distributed and Web architecture databases will also be discussed.

Class forum:

This semester, we are using Piazza for class discussion (link at top). The system is highly catered to getting you help fast and efficiently from classmates, TAs, and instructors. Rather than emailing questions to the teaching staff, we encourage you to post your questions on Piazza. You and other students can answer a question and edit the answer, with the teaching staff chiming in as appropriate. Use Piazza to ask anything, from questions about assignments to when the next quiz is.

Textbook:

"Database System Concepts"; Silberschatz, Korth & Sudarshan; 5th/6th Edition, McGraw Hill.

The book website (http://db-book.com/) has a lot of supplemental material that you may find useful.

Course Grading:

6 Homeworks: 15%, In-class Quizzes (more below): 20%, Final: 30%
Programming assignment: 10%, SQL Assignment: 10%, Application Development Project: 15%

There are a total of 11 deliverables. In-class Quizzes: Instead of a single midterm, this semester we will have a number of small 15 min quizes, done at the beginning of the lecture. The calendar has the specific dates that we are currently planning to have these quizes. I will take the best 5 scores out of the 7 scores -- no make-up quizzes will be administered.

Web project and the programming project are to be done in teams of 2. The other assignments and homeworks are individual.

Late Submission Policy:

You may delay submission of 3 of your deliverables by at most 2 days each. You don't need to notify us -- we will keep track of what you are submitting late. Be careful and don't use these up in the first set of assignments.

Excused Absenses Due To Illness:

A student claiming a excused absence must apply in writing and furnish documentary support (such as from a health care professional who treated the student) for any assertion that the absence qualifies as an excused absence. The support should explicitly indicate the dates or times the student was incapacitated due to illness. Self-documentation of illness is not itself sufficient support to excuse the absence. This instructor is not under obligation to offer a substitute assignment or to give a student a make-up assessment unless the failure to perform was due to an excused absence.

Academic Integrity:

The University of Maryland, College Park has a nationally recognized Code of Academic Integrity, administered by the Student Honor Council. This Code sets standards for academic integrity at Maryland for all undergraduate and graduate students. As a student you are responsible for upholding these standards for this course. It is very important for you to be aware of the consequences of cheating, fabrication, facilitation, and plagiarism. For more information on the Code of Academic Integrity or the Student Honor Council, please visit http://www.shc.umd.edu. To further exhibit your commitment to academic integrity, remember to sign the Honor Pledge on all examinations and assignments: "I pledge on my honor that I have not given or received any unauthorized assistance on this examination (assignment).

Web Accessibility