CMSC 424 Section 0101 Spring 2004
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.
Class meets TuTh 11:00-12:15,
Room CSI 1121
Professor: Nick Roussopoulos
Email: nick@cs.umd.edu
Office hours: Mo 12:30-1:30 Thu 1:45-2:30 or by appointment
Office AVW 3235, Tel. 405-2687
TA:Walid Gomaa Email: walid@cs.umd.edu
Office hours: Wed & Fri 3-4pm
TA office AVW 1151 (3204) Phone: 405-7388
TA's Announcements and System Material
READING & PREPARING FOR THE COURSE
Lecture Notes slides 1-90 (pdf file)
Black & White
Lecture Notes slides 91-183 (pdf file)
Black & White
Lecture Notes slides 184-216 (pdf file)
Black & White
Lecture Notes slides 213-244 (pdf file)
Black & White
Project Description
Database Design Methodology with a simplified example
Paper of the Database design methodology
and a sample project in the CS library
Oracle
Information
Oracle
Online
ASSIGNMENTS
Assignment 1: Due 2/10/2004
Exersizes
1.1,1.2,1.3,2.1-2.6 (Required but will not be graded)
READING AND PREPARING FOR THE EXAMS
Required text: Korth & Silberschatz "Database System Concepts,"
Fourth Edition, McGraw Hill 2001.
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 below for the course and the exams.
Midterm: 1,2,3 (except of 3.4 & 3.5), 4, 6, 7-7.7, 11 (except 11.3 and 11.9),
Lecture notes
Midterm for practice
Final: above plus
12, 13, 14, 15-15.5.1, 15.6-15.9, 16.1-16.1.4, 16.6.3.1-2, 17.4, 17.7, Lecture notes
Final for practice
Exersizes for practice:
-
1.1,1.2,1.3,2.1-2.6,
-
3.2,3.3,3.5,3.6-3.9,3.16
-
4.1,4.2,4.4-4.8
-
7.2, 7.4, 7.5, 7.11, 7.12, 7.15, 7.16, 7.21 (optional), 7.23
-
11.6, 11.10
-
12.1-12.4, 12.10, 12.16
-
13.5, 13.6, 13.8,
14.2, 14.3,
15.7, 15.8 (a,b), 15.10
16.2
GRADING
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!