CMSC 424 Section 0201 Fall 2005

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 Student ID# with h(SID#)= mod(SID#*1000003,1000001) and get your PID for getting your grades.
The posting order of the PIDs is randomized and implies no order on names, Student IDs, or anything else.
Good Luck to all of you who are graduating this semester. Drop me a line or a joke from time to time. Better yet, drop by and tell me your latest endeavors.
Class meets TuTh 11:00-12:15,   Room CSI 1122
Professor: Nick Roussopoulos Email:
Office hours: Mo 12:30-1:30 Tue 12:45-1:30 or by appointment

EXTRA Office hours for the FINAL: Wed Dec 14th, 2-4pm

Office AVW 3235, Tel. 405-2687

TA:Walid Gomaa Email:
Office hours: Mo 11:30-12:30, Th: 12:30-1:30
TA office hours in AVW 1112
* TA's Announcements and System Material
Important Notice on Class Accounts
Homework 1 Due Oct 4th
SQL Assignments
Query Processing Homework Due Nov 29th
Query Processing Homework Solutions
Oracle 10 & 9 Online Documentation (You need to register but its free)
Course Syllabus (dates are approximate)
Lecture slides 1-81 (pdf file)
Lecture slides 82-98 (pdf file)
Lecture slides 99-135 (pdf file)
Lecture slides 136-166 (pdf file)
Lecture slides ALL 1-166 in White background (pdf file)
Lecture slides 167-228 (pdf file)
Lecture slides 229-262 (pdf file)
Lecture slides 263-285 (pdf file)
Lecture slides 286-end (pdf file)

Reading & Practicing for the Midterm:
Read chapters: 1,2,3, 4-4.6.1, 5-5.2, 6, 7-7.5 (except 7.4.3), 11 and Lecture notes
Reading & Practicing for the Final: All the midterm reading and
chapters 12, 13 (except of hybrid hash join), 14 (up to 14.4.4), 15-15.5.1, 15.8-15.9, 16.1-16.1.4, 16.6-16.8, 17.4, 17.7,
9-9.4, 18-18.2.2, 18.3, 20-20.3, and Lecture notes
Midterm for practice
Midterm Solutions
Final for practice

Project Description
Database Design Methodology with a simplified example
Project & Computer Resources
Paper of the Database design methodology and a sample project in the CS library

Required text: Korth & Silberschatz "Database System Concepts," 5th Edition, McGraw Hill 2005.
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.
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!
    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.