LIBR 242
Information Technology Tools & Applications
Spring 2004

Steve Perry
steveperrymail@yahoo.com
Fullerton Computer Lab
Phone: (760) 744-1150 ext. 2990

Office Hours:
Virtually by e-mail
In person by appointment

GREENSHEET

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.)

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/31 from 10:00am-1:00pm (Room PLS49) and 3/13 from 10:00am-Noon, 1:00-5:00pm (Room PLS49))

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.

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

Evaluation

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

 
• Assignments        90%
• Final exam           10%