CMSC 424 Section 0101 Fall 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,  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.
Hash your SS# with h(ss#)= mod(ss#*1000003,1000001) and get your PID for getting your Final Course Grade.
The posting order of the PIDs is randomized and 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 1121
Professor: Nick Roussopoulos Email:
Office hours: Wed 12:30-1:30 Thu 1:45-2:30 Or by appointment
Office AVW 3235, Tel. 405-2687

TA:Walid Gomaa Email:
Office hours: Mon: 11:30 - 12:30, Thu 11 - 12
TA office AVW 1151 (3204) Phone: 405-7388
* TA's Announcements and System Material
* Lecture Notes slides 1-56 (pdf file) * Tree friendly version (4pp)
Lecture Notes slides 57-89 (pdf file) * Tree friendly version (4pp)
Lecture Notes slides 90-192 (pdf file) * Tree friendly version (4pp)
Lecture Notes slides 193-216 (pdf file) * Tree friendly version (4pp)
Lecture Notes slides 217-240 (pdf file) * Tree friendly version (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)
* Last semester's best project CSPL
*Oracle Information
*Oracle Online

* Assignment 1: Due 10/7/2003 in class
Exersizes 1.1,1.2,1.3,2.1-2.6 (Required but will not be graded)
* Answers to Assignmemt 1- Page 1, Page 2, Page 3
* Solutions to Midterm
* SQL Assignments Check the TA's corner
Query Processing Assignemnt DUE December 2, 2003
* Solutions to the Query Processing Homework

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 Answers
Final: above plus 12, 13, 14, 15-15.5.1, 15.6-15.9, 16.1-16.1.5,, 17.4, Lecture notes
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!