LIBR 242-10
Database Management Spring 2005
Spring 2005

Instructor: Steve Perry
E-mail
Fullerton Computer Lab
Phone: (760) 744-1150 ext. 2990
Office Hours:
Virtually by e-mail
In person by appointment

GREENSHEET

| Course Format | Required Texts | Evaluation |

Course Description

Design and implementation of fully interactive database-driven Web applications. Includes ODBC and SQL compliant database systems such as Oracle.

Prerequisites
LIBR200 -- Information and Society;
LIBR202 -- Information Retrieval;
LIBR204 -- Information Organization and Management;
LIBR240 -- Information Technology Tools and Applications;
(LIBR246 is recommended but not required.)

Goals

This course is an introduction to database concepts, database design, database implementation, and database management. Although three major database models will be introduced in this course, the emphasis will be on the relational database model. Students will learn how to design and implement a relational database and gain hands-on experience with the Oracle database management system. SQL and Web-based database access will also be covered.

In the lab sessions, we will concentrate on using Oracle based tools to design and build relational databases.

• Understand the basic concepts of database models, database design, and database management systems;
• Know how to design and implement a properly-normalized relational database;
• Acquire an introductory level of skill in using the Oracle DBMS;
• Be aware of management and social issues such as database security and privacy.

This course supports the following SLIS objectives:

• The student will know and be able to:
  1. identify the major theories and important principles, as well as to demonstrate current practice in information management,
  2. apply diverse technologies to information management, including the selection, organization, storage, retrieval, dissemination, and utilization of information resources, and
  3. develop systems and tools for information processing and management.

Course Format

This class is in a hybrid format, with most of the class taken online via the Class Web Site. There are two scheduled lab sessions at the Fullerton Computer Lab. The dates are 1/29 from 10:00am-1:00pm (Room PLS49) and 3/19 from 10:00am-Noon, 1:00-5:00pm (Room PLS69).

Reasonable Accommodation of Disabilities
Students who need accommodation due to a disability must register with SJSU's Disability Resource Center (DRC) during the first three weeks of the semester. The Center will work with the students to determine the disability, document it, and determine the services and accommodations necessary for student success. Then, the DRC will contact the faculty member to determine the types of consideration necessary.

Students attending the Fullerton campus should first contact the Disability Resource Center in San Jose since they are SJSU students. The DRC will then direct the students to supporting resources on the Fullerton campus.

The DRC Web site: http://www.drc.sjsu.edu/

Top of Page

Required Texts

Rob, Peter & Coronel, Carlos. Database Systems: Design, Implementation, and Management. 5th ed. Cambridge, MA: Course Technology; 2001. ISBN: 061906269X.

Oracle 9I: SQL With an Introduction to PL/SQL by Lannes L., Ph.D. Morris-Murphy Publisher: Course Technology; Book and CD-ROM edition (August 2003) ISBN: 0619212845.

Top of Page

Evaluation

Students’ performance in this class will be evaluated by completing 9 assignments and a final exam. Accumulated points toward the final grade are calculated according to the following ratios:

Read the SJSU Academic Integrity Policy
http://www2.sjsu.edu/senate/S04-12.pdf

Grading Scale

Top of Page