CMSC 424 Section 0101 Spring 2009

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. The class project requires a complete analysis, design, and implementation of a database application.

CLASS & OFFICE HOURS
Class meets TuTh 12:30-1:45pm, Room CSI 1122

Professor: Nick Roussopoulos
Email:
Office hours: Mo 1-2 pm or by appointment
Office AVW 3235, Tel. 301-405-2687

TA: Fatih Kaya
Email: Email: fatih@cs.umd.edu
Office hours: Wed: 10-11.30 am Thu: 2-3.30 pm
Office: AVW 1112
Tel: 301-405-2724

TA's Announcements and Course Material

Check the class forum

ANNOUNCEMENTS

HOMEWORKS

3-4 Homeworks and 2 SQL Query assignments will be given

Homework 1: Due 2/17/2009

Solutions to the Homework 1

SQL Assignment Part I: Due 3/3/2009 Part II: Due 3/5/2009 SQL Database Loading

Answers to SQL Assignment

Homework on Query Processing: Due 4-28-2009

Solutions to the Query Processing Homework

READING & PREPARING FOR THE COURSE

Course Syllabus revised to adjust to the snow day (dates are always approximate)

Lecture Slides 1-40

Lecture Slides 1-40 (6 on a page)

Lecture Slides 41-107 (2 on a page)

Lecture Slides 41-107 (6 on a page)

Lecture Slides 108-137 (2 on a page)

Lecture Slides 108-137 (6 on a page)

Lecture Slides 138-169 (2 on a page)

Lecture Slides 138-169 (6 on a page)

Lecture Slides 170-232 (2 on a page)

Lecture Slides 170-232 (6 on a page)

Lecture Slides 233-257 (2 on a page)

Lecture Slides 233-257 (6 on a page)

Lecture Slides 258-289 (2 on a page)

Lecture Slides 258-289 (6 on a page)

Lecture Slides 290-334 (2 on a page)

Lecture Slides slides290-334 (6 on a page)

READING & PREPARING FOR THE MIDTERM

Chapters: 1,2,3,4-4.3, 5-5.2, 6, 7-7.5 (except 7.4.3), and Lecture notes

Midterm's Solutions

READING & PREPARING FOR THE FINAL (comprehensive)

FINAL EXAM: CSI 1122 Tue, May 19 1:30 pm - 3:30 pm

Reading & Practicing for the Final:

All the midterm readings and the following (ranges X-Y include both endpoints X and Y)
chapters 4-4.5, 11, 12, 13 (except of hybrid hash join), 14-14.4.3, 15-15.5.2, 15.8-15.9, 16-16.1.4, 16.6-16.6.3.2, 16.8, 17.4, 17.7,
9-9.3, 18-18.4.1, 20-20.3, and Lecture notes

Sample Final

PROJECT INFO

Project Description

The DB Methodology Slides with the OlympicChronicle Example - Phases I-III

A complete Project (Sample)

Another Example of the DB Methodology in slides - The Merryland Motor Vehicle Administration

The Database Methodology Tool & a Handbook

Tool Setup Video

Environment Analysis Video

System & Specification Analysis Video

Conceptual Modeling Video

Oracle 10 Online Documentation

TEXT BOOK

Required text: Korth & Silberschatz "Database System Concepts," 5th Edition, McGraw Hill 2005. Note the CD version of the book is NOT required.

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 of the book.

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

Students 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. An 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. An excused absence for an individual typically does not translate into an extension for team deliverables on a project.

DISABILITY

Any student eligible for and requesting reasonable academic accommodations due to a disability is requested to provide, to the instructor in office hours, a letter of accommodation from the Office of Disability Support Services (DSS) within the first two weeks of the semester.

Web Accessibility