CMSC 424 Spring 2012

CMSC 424 Section 0201 Spring 2012

Prerequisite: A grade of C or better in CMSC 330 and 351. 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 meets TuTh 12:30-1:45pm,   Room CSI 1122  
Professor: Nick Roussopoulos
Office hours: Wed 1-2 pm or by appointment
Office AVW 3235, Tel. 405-2687

TA: Ethar Elsaka (Alternate TA Walaa Mustafa)
Office hours: Wed 1-2pm Ethar, Monday 3-4pm alternating every week between Ethar and Walaa), Thu 10-11am Walaa.
Office: AVW 1112
Homework 1 Due Feb 14.
Homework 1 Solutions
SQL Assignment Part 1 & 2, and solutions.
Homework 2 Due March 8.
Homework 2 Solutions (No more submissions are accepted)
Project Description
Project Phase 1 Submission Instructions with deadline.
Homework 3.
Homework 3 Solutions
Programming Assignment Due April 24, 2012 Homework 4.
Homework 4 Solutions
Sign up for project demo.
Coordinate with your partner and sign up. Each group can sign up to just one slot. This is on a first come first serve basis. For each group, the demo requires 15 minutes of your time and it will be held on Wed and Thu (May 2 & 3).
Last semester's project. Curiocity killed the cat!
And the Olympic Games database prior to the games in Athens.

Course Syllabus
Lecture Slides 1-32
Lecture Slides 1-88
Lecture Slides 88-140
Lecture Slides 141-177 (minor updates and an extra slide)
Lecture Slides 178-222
Lecture Slides 223-256
Lecture Slides 257-274
Lecture Slides 275-336
Lecture Slides 337-374
Book Readings:Ranges [X-Y] include both endpoints both X,Y.
Chapters: 1,2,3,4,6,7,8-8.5 and Lecture notes
Midterm Solutions
Final exam May 15, time 4-6pm in room 1122.
All the midterm readings and the following: Rranges [X-Y] include both endpoints X and Y.
Chapters 10,11, [12-12.7.1 (except of hybrid hash join)], [13-13.5] [14-14.8 except 14.5]
[15-15.4] [16-16.6] and Lecture notes.
Required text: Korth & Silberschatz "Database System Concepts," 6th Edition, McGraw Hill 2011. 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.
A student's grading will be determined from homeworks (10%), SQL assignments (10%), Programming assignments (10%), a project consisting of an Application Development (20%), a midterm exam (20%), and a final exam (30%).
  • 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!
    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.
    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

    free web counter
    free web counter

    Web Accessibility