Overview

Students are introduced to database systems and motivates the database approach as a mechanism for modeling the real world. An in-depth coverage of 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 database architectures are also discussed.

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.

Instructor

Amol Deshpande, Email: amol at cs dot umd dot edu,
Office hours: Monday 4-5pm, Wednesday 12-1pm, or by appointment;
Office: IRB 5154

Teaching Assistants and Office Hours (Open Area outside IRB 5138)

Shruti Bidwalkar (Tuesday, Thursday: 3:30pm-4:30pm)
Richard Johnson (Monday, Wednesday: 3:30pm-4:30pm)
Abhilasha Sancheti (Monday, Wednesday: 12:30pm-1:30pm)
Wichayaporn Wongkamjan (Tuesday, Thursday: 12:30pm - 1:30pm)

Grading

See CampusWire Posts for up-to-date grading and syllabus information.

Class forum

This semester, we will use CampusWire for class discussion (https://campuswire.com/p/GE77FFBD3). You can sign up using the code: 0494. This is similar to other forums used in the past for discussions, questions, etc., but with a more modern look and feel.

Textbook

"Database System Concepts"; Silberschatz, Korth & Sudarshan; 6th Edition, McGraw Hill. Note that: the readings for the course will refer to the 6th edition. You should be able to get by having an earlier edition, but you will have to figure out the mapping. The book website (http://db-book.com/) has a lot of supplemental material that you may find useful.

Excused Absences 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.

Accommodations for disabilities

You must notify me within 2 weeks from the beginning of class if you require special accommodations due to disabilities. All such requests must be accompanied by documentation from DSS. Requests received after this deadline will not be accommodated.

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).

CMSC424-0101: Database Design-Spring 2020 amol