Information (info)

Midterm Exam: March 6, 2013, in class

Class: MWF 9:30 AM - 10:20 AM
Date Range: Jan 07, 2013 - Apr 27, 2013
Location: University Hall 101 Forney Hall of Chemical Engr B124

Instructor Info
Name: Eduard C. Dragut
Email: edragut@purdue.edu
Office: YOUNG 1017
Office Hours: by email appointment

Teaching Assistants
Mingjie Tang [tang49@purdue.edu
Office Hours: Mondays 1:30 to 2:30PM Wednesday 2:30 to 3:30PM
PSO: Mondays 11:30-1:20PM
Chinmay V Deshmukh [cdeshmuk@purdue.edu]
Office Hours: Mondays 3:30-4:30PM
PSO: Mondays 1:30-3:20PM
PSO: No PSOs in the first week of class

Course Descriptions

CS44800 provides an introduction to relational database management system (DBMS) implementation (under-the-hood stuff). You will learn what it takes to build a relational database management system. There is a significant component of Java development. There will also be hands-on exercises using the Oracle DBMS. We will cover the following topics:
- Relational modeling
- Relational modeling
- Query Languages
- Storage and Indexing
- Query Evaluation and Optimization Transaction Management
- Schema Refinement, Database Tuning
- Other topics: Security, Distributed, Parallel Databases

Textbook

Recommended: Database Management Systems, (Third Edition), by Raghu Ramakrishnan and Johannes Gehrke. McGraw Hill, 2003 book website

Workload

There will be around four project assignments. In each assignment, you will be asked to implement one component of a simple database management system. There will be several SQL programming assignments using Oracle. There will be around four homeworks, a midterm and final examinations. The final exam will be cumulative, but the emphasis will be on the material covered after the midterm examination.

Grading

The final grade will be based upon the following:
- Programming and Homework Assignments 50%
- Mid-term Exam 20%
- Final 30%
- Extra-credit points may be given, up to 5%, based on the activity in class.

Course Policy

Late submission will result in a 10% penalty for each day late. After three days, late submissions will not be accepted. Students are strongly advised that any act of cheating will result in a score of 0 for the entire assignment and repeat offences will be reported to the Office of the Dean of Students and will result in an automatic F grade. You are encouraged to discuss problems and ideas but the final solution or code must be your own.