CMSC 424 Section 0101 Fall 2004

Prerequisite: A grade of C or better in CMSC 420; and permission of department. 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 meets TuTh 11:00-12:15, Room CSI 1122

Professor: Nick Roussopoulos Email: nick@cs.umd.edu
Office hours: Mo 12:30-1:30 Tue 12:45-1:30 or by appointment
Office AVW 3235, Tel. 405-2687

TA:Walid Gomaa Email: walid@cs.umd.edu
Office hours: Wed: 12:30 - 1:30, Thur: 4-5
TA office AVW 1151 (3204) Phone: 405-7388

TA's Announcements and System Material

READING & PREPARING FOR THE COURSE

Lecture slides 1-70 (pdf file)

Lecture slides 71-187 (pdf file)

Lecture slides 1-187 with slides 71, 84, and 112 modified to match how we did them in class (pdf file)

Lecture slides 188-225

Lecture slides 226-248

Project Description

Database Design Methodology with a simplified example

Paper of the Database design methodology and a sample project in the CS library

ASSIGNMENTS

Assignment 1: Due 9/21/2004
Exersizes 1.1,1.2,1.3,2.1-2.6

Query Processing Assignment: Due 11/30/2004

Solutions to Query Processing Assignment to be posted Tuesday 12/7/2004

READING AND PREPARING FOR THE EXAMS

Required text: Korth & Silberschatz "Database System Concepts," Fourth Edition, McGraw Hill 2001.

I HIGHLY recommend reading ahead from the text and the notes even if you don't understand most of the concepts. This gives you a big advantage in understanding the material while covered in class and it saves enormously when you read the material and do the practice exersizes below for the course and the exams.

Preparing for the Midterm- chapters:

1,2,3 (except of 3.5), 4, 6, 7-7.7, 11 (except 11.3 and 11.9),
Lecture notes
Midterm for practice
Midterm Solutions

Exersizes for practice:

1.1,1.2,1.3,2.1-2.6,
3.2,3.3,3.5,3.6-3.9,3.16
4.1,4.2,4.4-4.8
7.2, 7.4, 7.5, 7.11, 7.12, 7.15, 7.16, 7.21 (optional), 7.23
11.6, 11.10
12.1-12.4, 12.10, 12.16
13.5, 13.6, 13.8, 14.2, 14.3, 15.7, 15.8 (a,b), 15.10 16.2

GRADING

A student's grading will be determined from homeworks (5%), two SQL assignments (10%), a midterm (22%), a final exam (33%) and a project (30%). The project requires analysis, design, development, implementation, and documentation in three phases. Phase I: Requirement Analysis and System Analysis; Phase II: Schema and Application Program design; and Phase III: Implementation followed by a demo.

Make-up policy: No make-up exam will be given except for medical and emergency reasons.

Delayed work: No delayed work will be accepted, unless accompanied by a doctor's note.

Cheating: If caught in a cheating situation your database transactions will be aborted!

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.