Time:         Tue, Thu 2-3:15

Location:   Wales 224

Text:         Fundamentals of Database Systems, El Masri & Navathe, Addison-Wesley, 5th Edition, 2007.

Course Description:
This course gives students an introduction to database management systems.  The material in the course covers the underlying structures necessary for building databases, several database models and languages, database design strategy, and management of queries and transactions.

Students are expected to attend class.  Please inform me if you will be unable to attend a class so that you can find out what will be covered.

Course Topics & Tentative Schedule:
 

Topics	Chapters	Dates
Introduction to database systems	1 2	9/4 9/9
Data Modeling	3 4	9/11 9/16
Relational Data Model	5 6 7	9/18, 9/23 9/25 9/30
SQL	8 9	10/2 10/7
Database Design Theory	10 11-12	10/9 10/14
Midterm	1-12	10/16
Object-oriented databases	20 21-22	10/21 10/23
Web databases, PHP, XML	26 27	10/28 10/30
Disk storage and indexing structures	13 14	11/6 11/12
Query optimization	15	11/13 11/18
Transaction management ** Please note schedule changes **	17 18 19	11/20 12/2 12/4
Distributed Databases	25	12/9

Assignments:
Students are expected to read assigned chapters before class meetings. Homework problems will be assigned each week.  They will be due the following class meeting.  There will be three assigned projects and an individual paper or project.

Exams:
There will be a midterm and a final exam.  Each will cover half of the material presented in class.

Grading Policy:
All assignments are to be handed in on time.  Unexcused late assignments will lose 5% per day late, up to one week.   After that no credit will be given.
 
 

	Homework	10%
	Assigned Projects	30%
	Midterm	20%
	Independent Paper/Project	20%
	Final Exam	20%