CMSC 424 Fall 2011
CMSC 424 Section 0101 Fall 2011
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 & OFFICE HOURS
Class meets TuTh 11:00-12:15pm, Room
Office hours: Wed 1-2 pm or by appointment
Office AVW 3235, Tel. 405-2687
Walaa Eldin Moustafa
Office hours: Wednesday 9:30-10:30 and Thursday 1-2
Office: AVW 1112
TA's Announcements and Course Material
SQL Assignment A is posted in the above URL.
Posted in the class forum:
SQL Assignment B is due on October 20th in class. Please submit the paper version in class, and the script by email. Paper versions sent by email are not accepted.
Class forum where you can post questions and receive answers.
The demo of your project will be held during the days of 13th and 14th of December.
Use the following link to select your time slot:
Select Demo Slot
Note that only one member of the team can select the slot. Slots are given on a first-come first-serve basis.
3-4 Homeworks and 2 SQL Query assignments will be given
Homework 1: Due 9-20-2011
Homework 1 Solutions
Query Processing Homework: Due 11-29-2011
Solutions to Query Processing Homework
READING & PREPARING FOR THE COURSE
Lecture Slides 1-46
Lecture Slides 47-64
Lecture Slides 65-119 (minor changes from the previous version)
Lecture Slides 141-176
Lecture Slides 177-220
Lecture Slides 221-308
Lecture Slides 309-324
Lecture Slides 325-339- Material covered in these slides not be tested in the final exam
Lecture Slides 340-363
Lecture Slides 364-395
Lecture Slides 396-416
READING & PREPARING FOR THE MIDTERM
Chapters: 1,2,3,4,6,7,8-8.5 and Lecture notes
SAMPLE MIDTERM SOLUTIONS
READING & PREPARING FOR THE FINAL (comprehensive)
All the midterm readings and the following (ranges 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] [15-15.1.4] [16-16.6], [17-188.8.131.52],
[20-20.8 except 184.108.40.206-20.4.4], [22-22.2], and Lecture notes
Practice Final Solutions
The project will be discussed in class.
The DB Methodology Slides with the OlympicChronicle Example - Phases I
A complete Project (Sample)
Another Database Design example
A tool for the Database Methodology.
It should install easily on XP but may have some issues on Windows 7. The problem has to to do with the correct
version of mySQL. Use it at your own risk.
I am working with the University of Vienna in making a Windows 7 and a Mac version. I will keep you posted.
Oracle 10 Online Documentation
TEXT BOOK Required text: Korth & Silberschatz "Database System
Concepts," 6th Edition, McGraw Hill 2011. Note the CD version of the book is NOT
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
GRADINGA 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
Delayed work: No delayed work will be accepted, unless accompanied by a
Cheating: If caught in a cheating situation your database transactions will
EXCUSED ABSENSES DUE TO ILLNESS
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.
free invisible web counter