Course Links
Class Web Site
|
|
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 four scheduled lab sessions at the Fullerton Computer Lab.
The dates are 2/1, 3/1, 4/5, and 5/10. These are all on a Saturday
from 10:00am-1:00pm.
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.
At the conclusion of the course the students are expected to:
-
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.
Loney, K. & Koch, G. (2002). Oracle9i: The Complete Reference. Book and
CD ed. McGraw-Hill Osborne Media; ISBN: 0-072-22521-1.
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:
-
Assignments 90%
-
Final exam 10%
|
Grading Scale
97-100 = A
94-96 = A-
91-93 = B+
88-90 = B
85-87 = B-
82-84 = C+
79-81 = C
76-78 = C-
73-75 = D+
|
Policies and Procedures
Additional policies and procedures are listed on the Class Syllabus available
on the Class Web Site.
|
|