PACE UNIVERSITY - DISTANCE COURSE
SCHOOL OF COMPUTER SCIENCE AND INFORMATION SYSTEMS
IS613: Database Mgmt. Systems (Fall, 2005) Dr. Stuart A. Varden
Email: svarden@pace.edu Off.Hrs:Contact me via
Web Page: csis.pace.edu/~varden email for assistance
SHORT COURSE OUTLINE
Week
Starting Topic Readings/Asmts
-------- -------------------------------------------- -----------------
01-9/8 Course Orientation and Overview of Database Text:Ch.1
Concepts Take Quiz 1
02-9/15 Data Models and Abstraction Text:Ch.2
Take Quiz 2
03-9/22 The Relational Database Model Text:Ch.3
Take Quiz 3
04-9/29 The Entity Relationship Model Text:Ch.4
Take Quiz 4
05-10/6 Normalization of Database Tables Text:Ch.5
Take Quiz 5
06-10/13 Intro Structured Query Language (SQL): Text:Ch.6
Definition and Simple Queries Take Quiz 6
07-10/20 Structured Query Language (SQL): Advanced Text:Ch.7
Queries, Views and Control Features Take Quiz 7
08-10/27 SQL Lab Using Microsoft Access MS-Access document
Asmt: Do queries
using Access-2000
09-11/3 *** Online Mid-Term Quiz *** Take Mid-Term
(Note: Midterm covers Chapters 1-7)
10-11/10 Logical Database Design Text:Ch.8
Take Quiz 8
11-11/17 Transaction Management and Concurrency Text:Ch.9
Control Take Quiz 9
12-11/24 Distributed Database Systems Text:Ch.10
Take Quiz 10
13-12/1 Data Warehousing Text:Ch.12
Take Quiz 11
14-12/8 Database Administration and Text:Ch.15
Review Exam Review Take Quiz 12
15-12/15 Final Examination: Database Project Due
(Friday, December 16th)
------------------------------------------------------------------------
Required Text:
Rob, Peter & Coronel, Carlos. Database Systems: Design, Implementation
and Management, 6th Edition. Course Technology: Cambridge, MA, 2004
[ISBN: 0-619-21323-X].