Database Systems, CISC437/637

Fall, 2012

Instructor: Dr. Hagit Shatkay

Office: Smith 416      Office hours: Tuesdays and Thursdays: 3:30-4:30pm (or by appt.)

Meeting times:


TA: Rekha Sundaramoorthy, rekha AT udel.edu
TA hours: Mondays: 6:30-7:30PM; Wednesdays: 5:30-6:30PM. Smith 103.


PROJECT

Overview

Databases and database management systems form one of the most successful and widely used computer applications, even predating the internet revolution. They are the primary means through which large quantities of data are structured, stored, and accessed. We interact with database management systems so often to access information in banks, universities, movie theaters, train stations, airports, bookstores and many other places, that we do not often think about what they are, how they are implemented or managed, and what exactly would make the difference between a "good" and a "bad" system.
This course aims to introduce the basic concepts, components and principles underlying the design, implementation, and use of database management systems.
By the end of the course students will be familiar with the fundamental data models used for representing and designing databases (primarily, the relational model), the main properties that database management systems must satisfy in order to be useable and reliable, and query languages (focusing on SQL) for managing and accessing information in databases.


Course Syllabus and Grading Policies

Tentative Schedule


Prerequisites

CISC220 (Data Structures); CISC304 (Logic and Programming); Programming ability is assumed.


Textbook

Database System Concepts, by A. Silberschatz, H. Korth and S. Sudarshan . McGraw Hill, 6th Ed. 2011.
See Errata .



Last update: August 27, 2012