Rutgers The State University of New Jersey
GSM

Database Systems
22:198:603

Fall 2010
Wednesdays 6:00 - 9:00pm, Newark, 1 Washington Park, Room 312

Room Change: The class will meet in Room 312 instead of 532


Instructor : Prof. Vijay Atluri

Office

: 1 Washington Park, Room 1082 (Newark)
Office Hours : Wednesdays 4:00 - 5:45pm and by appointment
Telephone: 973-353-1642
Fax: 973-353-5003
E-mail: atluri at rutgers dot edu
Homepage: http://cimic.rutgers.edu/~atluri

Call 973-353-1766 or 732-932-1766 for Official University/Campus closings

Course Description: This course examines the principles of design and functions of the Relational Database Management System (DBMS), and it as an office productivity tool. Specific topics include: Evolution of Database Management systems, Entity Relationships Modeling and Design of a Relational Model, Database Integrity Rules, Normalization of Database Tables, and Database Administration. This course utilizes Microsoft Access to provide a hands-on experience with a DBMS. Students will learn how to: Create an entity-relationship data model, translate that model into relational schema, build and use a relational database that implements the schema. Create Queries, Forms and Reports, Create a Switchboard utilizing built macros to simplify activation of different objects in the database, Create Data Access Pages providing Internet access to databases. Export data from the database to another Office application and Import data into Access.

Text Book: Peter Rob and Carlos Coronel, Database Systems: Design, Implementation, and Management, Seventh Edition, Thomson Course Technology, 2009

Reference Book: Microsoft Office Access 2003: Comprehensive Concepts and Techniques, CourseCard Edition, Gary B. Shelly, Thomas J. Cashman, Philip J. Pratt, Mary Z. Last ISBN: 1-4188-4363-6 2006 ISBN-13: 978-1-4188-4363-2 Publish date: March 30, 2005 688 pages Softcover

Expected Work:
Homework Assignments 25%
Project 20%
Class Participation 5%
Mid-term Examinations 25%
Final Examinations 25%

Tentative Schedule:

The schedule is subject to change any time. The reading assignment for each session is assigned at least one week in advance, and the notes is posted at least one day in advance.

Sept 1

Sept 8

No Class

Sept 15

Sept 22

Sept 29

Oct 6

Oct 13

Oct 20

  • Mid-term Examination
  • Topics covered until Oct 13

Oct 27

Nov 3

Nov 10

Nov 17

Nov 22

Dec 1

  • Access Lab III
  • Review

Dec 8

  • Final Examination
  • Topics covered from Sept 1 to Dec 1