CMSC 424 Section 0101 Spring 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 1121
Professor: Nick Roussopoulos Email:
Office hours: Mo 12:30-1:30 Thu 1:45-2:30 or by appointment
Office AVW 3235, Tel. 405-2687

TA:Walid Gomaa Email:
Office hours: Wed & Fri 3-4pm
TA office AVW 1151 (3204) Phone: 405-7388
* TA's Announcements and System Material
* Lecture Notes slides 1-90 (pdf file) * Black & White
Lecture Notes slides 91-183 (pdf file) * Black & White
Lecture Notes slides 184-216 (pdf file) * Black & White
Lecture Notes slides 213-244 (pdf file) * Black & White
* Project Description
* Database Design Methodology with a simplified example
* Paper of the Database design methodology and a sample project in the CS library
*Oracle Information
*Oracle Online

* Assignment 1: Due 2/10/2004

Exersizes 1.1,1.2,1.3,2.1-2.6 (Required but will not be graded)
* Query Processing Assignemnt DUE April 29, 2004

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.

Midterm: 1,2,3 (except of 3.4 & 3.5), 4, 6, 7-7.7, 11 (except 11.3 and 11.9), Lecture notes
*Midterm for practice
Final: above plus 12, 13, 14, 15-15.5.1, 15.6-15.9, 16.1-16.1.4,, 17.4, 17.7, Lecture notes
*Final for practice

Exersizes for practice:
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!

    Web Accessibility