Database systems concepts. (6th ed.)
Time: Tuesday,Thursday 11-12:15
Location: CSIC
1121
Instructor: Mihai
Pop (mpop at umiacs) x5-7245
Office hours: Tuesdays
3:00-4:00pm
Office address: AVW 3223
Alternate
office (by appointment):3120F Biomolecular
Sciences Building (bldg #296).
Building is usually locked.
Call me from the intercom and I'll buzz you in.
TA: Kanthi
Sarpatwar
TA office hours: Wednesdays
2:00-3:00pm, Fridays 12:00-1:00pm
TA office: AVW
1112
TA: Chanhyun Kang
TA office hours: Mondays
2:30-3:30pm
TA office: AVW 1112
Important! Your accounts only contain a limited version of the Mondial database. Use the following for assignments:
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. The class project requires a complete analysis, design, and implementation of a database application.
A grade of C or better in CMSC 330 and CMSC 351.
Database
systems concepts. (6th ed.)
Silberschatz, Korth, Sudarshan
McGraw Hill, ISBN 0-07-352332-1
Models for data representation
SQL language
Schema normalization
Data storage
Query processing and optimization
Transactions, concurrency, and recovery
Parallel/distributed databases
Databases and the Internet
Regular homework assignments will consist of a combination of one
or more of the following: (i) exercises from the textbook; (ii) small
programming assignments (e.g. SQL exercises). In addition, all
students must complete a programming project.
The final grades
will be a combination of the grades for the homework, project,
midterms and final exams. In addition, participation in the class
will be taken into account for extra credit. The breakdown of you
final grade is shown below.
Homework - 10 %
Project - 30
%
Midterms - 25% (12.5% each)
Final - 35%
Assignments
submitted late will be graded as follows: up to 1 day late - 10
points will be deducted from the grade, up to 2 days late - 20 points
will be deducted. Your assignment will not be graded beyond the
second day past the deadline. If for reasons outside your control you
will not be able to submit an assignment on time, see me as soon
as possible to discuss an alternate deadline.
This course follows the University's attendance policy. In short, if you will miss class for any reason you should let me know in advance, unless this is not possible (e.g. sudden illness). In any case, please let me know as soon as you are aware that you will not be able to attend a class (e-mail is OK). I will work with you to help you catch up on homework or exams if you have to miss any of the lectures.
I expect that the students taking this class fully adhere to the Code of Academic Integrity. Please read this document in full if you have not already done so. 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)."