CMSC 424 Fall 2018

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 MW 3:30pm - 4:45pm , Room ESJ 0224
Professor: Nick Roussopoulos Email:

Office hours: Tue 1-2 pm or by appointment
Office AVW 3235, Tel. 405-2687

TA: Zhenpeng Zhao Email: zhaoz@umd.edu Office: AVW 4103 Office hours: Mo 1-3
TA: Aliasghar Hussain Email: aliasghar.hussain@rhsmith.umd.edu Office: AVW 4103 Office hours: Tu Th 4:30-5:30
UTA: Affan Husain Email: affan98@terpmail.umd.edu Office: AVW 4103 Office hours: Th 12:30-1:30
UTA: Jared Tan Email: jaredtan1221@gmail.com Office: AVW 4103 Office hours: Fr 2-3
UTA:Alex Yang Email: alex.yangdeqian@gmail.com Office: AVW 4103 Office hours: We 1-2

ANNOUNCEMENTS

All classes announcements will be posted on this site. Make sure you visit this page often to check for postings including assignments, notes, and lecture slides.

Course Syllabus

READING & PREPARING FOR THE COURSE

Lecture Slides 1-32 Reading: Chapters 1,2, and 6

Lecture Slides 33-99 Reading: Chapters 3 and 4

Lecture Slides 117-147 Reading: Chapter 7

Lecture Slides 148-188 Reading: Chapter 8 .6

Lecture Slides 189-240 Reading: Chapters 10

Lecture Slides 241-294 Reading: Chapters 11

Lecture Slides 295-323 Reading: Chapters 12

Lecture Slides 324-350 Reading: Chapters 13

Lecture Slides 351-366 Reading: Chapters [14-14.8]

Lecture Slides 367-384 Reading: Chapters [15-15.3]

Lecture Slides 385-393 Reading: Chapters [16-16.6]

Lecture Slides 394-426 Reading: Chapters 20, [22-22.4]

Lecture Slides 4s7-497 Reading: Chapters 17, 18, 21, 23

PREPARING FOR QUIZ 1

Text Book Chapters 1,2,3,4,6, Lecture slides

Sample Quiz
This is a real quiz from last year. You will get a hard copy to write on your answers. Each quiz is taken at the last 20-minute of the class.

Quiz 1 Solutions

READING & PREPARING FOR QUIZ 2

Text Book Chapters 1,2,3,4,6,7,8-8.6, Lecture slides, Quiz 1.

Sample Quiz The quiz will be taken at the last 20-minute of the class.

Quiz 2 Solutions

READING & PREPARING FOR QUIZ 3

Text Book Chapters 1,2,3,4,6,7,8-8.6,7, 8-8.6,10,11, Lecture slides, Quiz 1 and 2. The quiz will be taken at the last 20-minute of the class.

Sample Questions from Chapters 10 and 11. For the earlier material, you have Quizzes 1 and 2.

Quiz 3 Solutions

READING & PREPARING FOR QUIZ 4

Text Book Chapters 1,2,3,4,6,7,8-8.6,7, 8-8.6,10,11, 12-12.5, 13, Lecture slides, Quiz 1, 2 and 3.

Technology

Quiz 4 Solutions

READING & PREPARING FOR QUIZ 5

Text Book Chapters 1,2,3,4,6,7,8-8.6,7, 8-8.6,10,11, 12-12.5, 13, [14-14.8], [15-15.3], [16-16.6] Lecture slides, Quizzes 1, 2, 3 and 4.

Quiz 5 Solutions

READING & PREPARING FOR FINAL (comprehensive)

In the following ranges [X-Y] include both endpoints X and Y.
Text Book Chapters 1,2,3,4,[6-6.1.3.4],7,[8-8.5],10,11, [12-12.6], [13-13.4] [14-14.8] [15-15.3] [16-16.6], [17-17.3.3.4] Lecture slides, and Quizzes 1, 2, 3, 4, and 5.

Sample-Practice Final

YOUR OVERALL GRADE CAN BE FOUND HERE

LETTER GRADES

About one third of the grades fell within less than a point from the next grade cut off. All of these were upgraded to the next grade level.
To figure out your grade, hash on your Student ID using the following function: HashValue=mod(SID*100001317,23577).

SQL MATERIAL AND ASSIGNMENTS

The SQL assignments are to be done and submitted individually.

Assignment 0: You have to download and setup the Oracle SQL Developer on your laptop or desktop. You will use this to develop and execute your SQL queries.
See below the instructions how to do it. DEADLINE for this is September 7. Soon you will be told how to submit a report saying that is done on ELMS.

SQL Assignment

SQL A Solutions

SQL B Solutions

SQL script to create and load the DBLP database in Oracle.
-- You need to download the script and store it to a directory under a name say, DBLP_populate.sql.
Then in the SQL Developer run the script in the query section prefixed with @. Make sure you specify the whole path to the script file for the program to find it,
e.g. @D:\Data\Class\_424_F17\SQL\STATES_Assgnmnts\DBLP_populate.sql

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

Oracle SQLPlus - If for some reason you cannot install SQL Developer and you need to run Oracle on Glue at the command line, the script to do it is here. To run sqlplus on glue.umd.edu you will have to use the Oracle account you will be provided.

Oracle Online Documentation

PRACTICE DATABASE: SQL script to create and load a Senate database in Oracle SQLPlus
-- You need to download the script and store it to a directory under a name say, state_populate.sql. Then in the SQL Developer run the script in the query section prefixed with @. Make sure you specify the whole path to the script file for the program to find it, e.g. @D:\Data\Class\_424_S17\SQL\STATES_Assgnmnts\state_populate.sql

PRACTICE DATABASE: Queriess on the State Database
- YOU DO NOT NEED TO SUBMIT THE QUERIES BUT TO REPORT THAT YOU PRACTICED WITH THIS DATABASE AND READY FOR THE REAL SQL ASSIFNMENTS.

PROJECT INFO

DEMO INSTRUCTIONS

Project Description.

Software architecture, programming platforms and APIs are described here.

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 e ergency 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 ABSENCES 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 (DSS) within the first two weeks of the semester.

hidden hit counter

Web Accessibility