CISC 437 - Database Systems - Spring 2008

T 7:00pm-10:00pm, PUR 233B

Instructor: Michael Haggerty	TA: Pujan Kafle
Office: SMI 101D	Office: Smith 102B
Hours: T (after class) R 12:30-1:30 and by appt.	Hours: M 10:00-12:00 and by appt.
Phone: 598-9844 (use only in Emergency)	Phone: N/A
Email: haggerty@cis.udel.edu	Email: kafle@cis.udel.edu

Textbook

Database System Concepts, fifth edition, by Silberschatz, Korth, and Sudarshan. McGraw-Hill, 2006.

Course Description

Physical and logical organization of databases. Data retrieval languages, relational database languages, security and integrity, concurrency, distributed databases.

Course Objectives

In this course, the student will learn how to create and manipulate a database system using MySQL. He or she will also learn how to design a database using the E-R model and will design and implement a complete database system. He or she will understand basic implementation techniques that make databases systems more efficient and some important issues that must be addressed when more than one user uses a database system at the same time or when the database system is distributed over several locations.

Topics (tentative)

Chapter 1: Introduction
Chapter 2: Relational Model
Chapter 3: SQL (and MySQL)
Chapter 4: Advanced SQL (sections 4.1 through 4.5 only)
Chapter 6: Entity-Relationship Model
Chapter 7: Relational Database Design
Chapter 8: Application Design and Development (sections 8.6, 8.7)
Chapter 10: XML (sections 10-10.2, 10.3.2, 10.4-10.4.2)
Chapter 12: Indexing and Hashing
Chapter 13: Query Processing
Chapter 14: Query Optimization
Chapter 15: Transactions
Chapter 16: Concurrency Control
Chapter 17: Recovery System
Chapter 22: Distributed Databases (if time permits)
Chapter 18: Data Analysis and Mining (if time permits)

Grading

Grades will be based on (with equal weight) [tentative]:

project
homework assignments (and programming exercises)
midterm
final exam

Letter grades will be determined by the following scale, which may be altered (in your favor) at the discretion of the instructor, depending on the final grade distribution.

grade >= 93.0	A	73.0<= grade < 76.9	C
90.0 <= grade < 92.9	A-	70.0<= grade < 72.9	C-
87.0 <= grade < 89.9	B+	67.0 <= grade < 69.9	D+
83.0<= grade < 86.9	B	63.0<= grade < 66.9	D
80.0<= grade < 82.9	B-	60.0<= grade < 62.9	D-
77.0 <= grade < 79.9	C+	grade < 60	F

NOTE: Roll will be taken from time to time without warning. If you are absent a substantial number of times when these rolls are taken, your grade for the course could be lowered by as much as one letter grade. No make-ups allowed.

Policies

All assignments and projects due dates and times will be posted on MyCourses. A hardcopy is to be turned in at the class period immediately following the posted due date/time.
Homework will be accepted at the beginning of the class period, but the score will be reduced by 2^n points per day where n is the number of days past the due date. The homework will not be accepted when the number of points lost exceeds the assigned value (i.e. a homework is worth 50 points - it will not be accepted if it is more than 5 days late) except in extreme and verifiable circumstances.
All work on assignments and projects must be your own. Do not collaborate with other students or copy their work. Do not copy from a book or other source. You may consult with each other about conceptual problems, but see the TA or me for help with details or debugging.
If you can't come to scheduled office hours, please send me email (please put CISC437 at the beginning of the Subject line); I'll be happy to schedule a meeting at some other mutually-agreed upon time.

Current Date and Time:

haggerty@cis.udel.edu

CIS Department Instructor

Last Updated: