Rutgers The State University of New Jersey
|
| 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 |
| : atluri at rutgers dot edu | |
| Homepage | : http://cimic.rutgers.edu/~atluri |
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%
Sept 1
Sept 8
Sept 15
Sept 22
Sept 29
Oct 6
Oct 13
Oct 20
Oct 27
Nov 3
Nov 10
Nov 17
Nov 22
Dec 1
Dec 8