CMSC 424 Section 0301 Spring 2003

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, physical and logical database design, query languages and other database services including concurrency control, crash recovery, database integrity and security. Distributed databases and transaction management will also be discussed.
To find your grade for the course, the final, last homework and project, hash on your SS#: h(SS#) = MOD(SS# * 1000003,1000001)
If at this point you do not know how to hash, send me e-mail and I will automatically convert your grade to an F-.
The order of the hashed values is randomized and thus the post order implies no order on names, SS#, or anything else.
Good Luck. Drop a line from time to time.
Class meets TuTh 12:30-01:45,   Room CSI 3120
Professor: Nick Roussopoulos Email:
Office hours: Mo 4-4:30 pm Th 1:45-2:15 pm or by appointment.
Office AVW 3235, Tel. 405-2687
* TA's Announcements
TA:Walid Gomaa Email:
Office hours: Tu 11-12, Th 3:30-4:30 TA office AVW 1151 (3204) Phone: 405-7388
Check your mideterm grade Disabled
* Lecture Notes slides 1-89 (pdf file) * Slides 1-89 (4pp)
Lecture Notes slides 90-192 (pdf file) * Slides 90-192 (4pp)
Lecture Notes slides 192-242 (pdf file) * Slides 192-242 (4pp)

Database Design Methodology with a simplified example
* Paper of the Database design methodology and a sample project in the CS library
* Project Description (pdf)
* Book, Article, Technical Report Data (zip)
* Project Demo Requirements
*Oracle Information

* Assignment 1: Due 2/12/2003
Exersizes 1.1,1.2,1.3,2.1-2.6 (Required but will not be graded)
* Solutions to Homework1
* SQL Assignments Check the TA's corner
* Query Processing Assignemnt DUE April 29, 2003
* Solutions to Query Processing Assignment
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.8, 11 (except 11.3 and 11.9), Lecture notes
Solutions of Midterm
Previous Questions in Midterms
Final: above plus 12, 13, 14, 15-15.4, 15.9, 16.1, 17.4, Lecture notes
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

    A student's grading will be determined from 3 or 4 homeworks (10%), two SQL assignments (10%), a midterm (20%), a final exam (30%) 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!

    Last modified: Jan 15, 2003