CMSC 424 Fall 2013

CMSC 424 Section 0101 Fall 2013

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 11-12:15pm,   Room CSI 1122  
Professor: Nick Roussopoulos
Office hours: Wed 1-2 pm or by appointment
Office AVW 3235, Tel. 405-2687

TAs: Udayan Khurana Email:
Abdul Quamar Email:
Office hours: Abdul: Monday 10-11 AM
Udayan: Thursday 3-4 PM
Office: AVW 1112
The class size has been extended already by 25% and therefore it is very unlikely that anyone can be oversubscribed or allowed to sit in.
Course Syllabus (details on the requirements will be discussed in the first day's lecture).
* Homework 1 (Due 9/17/2013)
* Solutions of Homework 1
* Homework 2 (Due 2:00 pm Friday 10/4/2013)
* Solutions of Homework 2
* Homework 3 (Due 2:00 pm Tuesday 11/19/2013)
* Solutions of Homework 3
* Homework 4 (Due 2:00 pm Tuesday 12/3/2013)
--Deadline EXTENDED TO 12/5/2013 2:00pm

* Solutions of Homework 4 '
* SQL Assignment Part 1 (Due 9/24/2013 12:30pm)
* SQL Assignment Part 1 Solutions
* SQL Assignment Part B (Due 10/31/2013 12:30pm)
* SQL Assignment Part 2 Solutions
Lecture Slides 1-30
Lecture Slides 31-97
Overlap in slide 45 Overlap in slide 45 Overlap in slide 46 Overlap in slide 46
Lecture Slides 115-147
Lecture Slides 148-186
Lecture Slides 187-232
Lecture Slides 233-284
Lecture Slides 285-312
Lecture Slides 313-346
Lecture Slides 347-384 '

SQL Material
Oracle SQLPlus
Oracle SQL Developer Video
Oracle Online Documentation
For SQL Starters
* Instructions how to run Oracle on glue and a tennis database
Oracle SQL Developer Video
Text Book Chapters 1,2,3,4,6,7,8-8.5 and Lecture notes
Midterm Exam Solutions

All the midterm readings and the following (ranges X-Y include both endpoints X and Y) '
Chapters 10,11, [12-] and [12.6], [13-13.5] [14-14.8] [15-15.3] [16-16.6], [17-], '
[20-20.8 except], [22-22.2], and Lecture notes '
The project will be discussed in class.
Project Description
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 easily install on Windows 7. It is a really nice tool but, unfortunately, we cannot support its installation. If you manage to install it, it will help you a lot.

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%), 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!
    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
    free invisible web counter