CMSC 424 Spring 2016

Goals: Students are introduced to database systems and motivates the database approach as a mechanism for modeling the real world. An in-depth coverage of 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 database architectures are also discussed. The class project requires a complete analysis, design, and implementation of a database application.

Prerequisite: Minimum grade of C- in CMSC351 and CMSC330; and permission of CMNS-Computer Science department. Or must be in the (Computer Science (Doctoral), Computer Science (Master's)) program.

CLASS & OFFICE HOURS
Class meets TuTh 9:30-10:45am, Room CSI 3117

Professor: Nick Roussopoulos
Email:
Office hours: Wed 1-2 pm or by appointment
Office AVW 3235, Tel. 405-2687

TAs: Ruichi Yu Email: yrcbsg@gmail.com
Office hours: TuTh 12:45pm-1:45pm -- Office: AVW 4103
and
Sachin Malhotra Email: smalhot1@terpmail.umd.edu>
Office hours: Mo 10:30-11:30 AM --- Office: AVW 4103

ANNOUNCEMENTS

The class size has been extended already by 125% and therefore it is very unlikely that anyone can be oversubscribed or allowed to sit in.

Course Syllabus adjusted to account for the missed snow days. Note the quiz 4 and 5 dates.

READING & PREPARING FOR THE COURSE

Lecture Slides 1-29

Lecture Slides 30-97

Lecture Slides 115-145

Lecture Slides 146-185

Lecture Slides 186-232

Lecture Slides 233-268

Lecture Slides 269-285

Lecture Slides 286-348

Lecture Slides 349-389

Lecture Slides 390-444

READING & PREPARING FOR QUIZ 1

Text Book Chapters 1,2,3, and Lecture slides

QUIZ 1 Solutions

READING & PREPARING FOR QUIZ 2

Text Book Chapters 1,2,3,7,8-8.5 and Lecture slides

QUIZ 2 Solutions

READING & PREPARING FOR QUIZ 3

Text Book Chapters 1,2,3,7,8-8.5, 10-10.5, Lecture slides AND the two previous quizzes.

QUIZ 3 Solutions

READING & PREPARING FOR QUIZ 4

Text Book Chapters 1,2,3,7,8-8.5, 10, 11, 12-12.3. Lecture slides AND previous quizzes. Practice exersizes are recommended. Try to answer all those which are similar to the material I emphasized in class. These exclude, for example, details on B+Tree insertion & deletion algorithms. Reading the solutions from http://codex.cs.yale.edu/avi/db-book/db6/practice-exer-dir/ before trying to do them on your own will not be as useful.

QUIZ 4 Solutions

READING & PREPARING FOR QUIZ 5

Text Book Chapters 1,2,3,7,8-8.5,10,11,12-12.5.5.4 and 12.6,13.1,13.3,13.5,14-14.8,15-15.3,16-16.6. Lecture slides AND previous quizzes. Practice exersizes are recommended. Try to answer all those which are similar to the material I emphasized in class. Reading the solutions from http://codex.cs.yale.edu/avi/db-book/db6/practice-exer-dir/ before trying to do them on your own will not be as useful.

QUIZ 5 Solutions

READING & PREPARING FOR THE FINAL (COMPREHENSIVE)

Text Book Chapters 1,2,3,7,8-8.5,10,11,12-12.5.5.4 and 12.6,13.1,13.3,13.5,14-14.8,15-15.3,16-16.6. Lecture slides, Quizzes 1-5, and the final sample below:

Practice Final Exam

'
Practice exersizes are recommended. Their solutions can be found on http://codex.cs.yale.edu/avi/db-book/db6/practice-exer-dir/ but you should first try to solve the exersizes on your own before looking them up.

SQL MATERIAL

SQL A Assignment

SQL A Assignment Solution - NO MORE SUBMISSIONS

SQL B Assignment

SQL B Assignment Solution - NO MORE SUBMISSIONS

SQL script to populate the database for the SQL Assignments A & B
-- You need to download the script to the directory you will be running SQLPlus and name it DBLP_populate.sql.
-- You only need to run @DBLP_populate.sql ONCE. After that the database will always be there.

Oracle SQLPlus - To run sqlplus on glue.umd.edu use the Oracle account you will be provided.

Oracle SQL Developer- A better interface to develop and execute SQL queries

Oracle Online Documentation

PRACTICE DATABASE: SQL script to create and load a Senate database in Oracle SQLPlus
-- Again, you need to download the script to the directory you will be running SQLPlus and name it state_populate.sql.

PRACTICE DATABASE: Queriess on the State Database - YOU DO NOT NEED TO SUBMIT

PROJECT INFO

There will be a semester long project for the class. Details will be discussed in class.

Project Description

The DB Methodology Slides with the OlympicChronicle Example - Phases I-III

A complete Project (Sample)

Another Database Design example

The Original Adaptable Database Design Methodology

A tool for the Database Methodology.
An implementation of the DB Methodology on a modern platform. Available for free for download.
It installs easily on Windows. A really nice tool that makes the design and the documentation easy.

TEXT BOOK

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.

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!

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.

DISABILITY

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 (USS) within the first two weeks of the semester.

Web Accessibility

free counter

Web Accessibility