INSTRUCTOR: Dr. Mary Ann Robbert, CIS Department

OFFICE: Morison 126

PHONE: (617) 891- 2175

EMAIL: MROBBERT@BENTLEY.EDU

HOMEPAGE: HTTP://CIS.BENTLEY.EDU/MROBBERT

OFFICE HOURS:

Other times by appointment.

COURSE DESCRIPTION: A hands on, technology course utilizing Oracle, a commercially oriented, multi-user database management system, to teach data management. SQL will be used as a data manipulation and a data definition language. The use of a database for data storage, data protection and information retrieval will be presented. This first component will focus on the use and maintenance of data stored in a database management system. The second will focus on the creation of a database and the generation of required reports.

COURSE OBJECTIVES: Upon successful completion of the course, students will:

• Be able to access data stored in Oracle databases
• Enter and delete data in Oracle databases
• Compose integrity constraints to protect data
• Read and modify SQL queries through a Graphical User Interface
• Create views
• Generate reports to meet specified needs
• Use and understand a data dictionary

TEACHING METHODOLOGY: Lectures and demonstrations plus interactive instruction using Oracle to demonstrate concepts. Hands on exercises will be used to ensure students understand SQL and can solve business problems.

COMPUTER: Computers linked to the VAX through either the LAN or a modem, will be used to access course databases through Oracle. If possible bring a laptop computer to class for hands on experience.

REQUIRED TEXT:

A Guide to SQL featuring Oracle, Philip Pratt, published by Course Technology, 1997.

EVALUATION: The final course grade will be determined by the following: