LIBR 242-10
Database Management
Spring 2006 Greensheet
Steve Perry
E-mail
Phone: Fullerton Computer Lab, (760) 744-1150 ext. 2990
Office Hours:
Virtually by e-mail;
In person by appointment
| Greensheet Links Required Texts Course Requirements |
Course Links Class Web Site Instructor Information |
Course Description
Design and implementation of fully interactive database-driven Web applications. Includes ODBC and SQL compliant database systems such as Oracle.
Prerequisites: LIBR 200,
LIBR 202,
LIBR 204,
LIBR 240
NOTE: LIBR 246 is recommended but not required.
Course Goals and Objectives
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
- identify the major theories and important principles, as well as to demonstrate current practice in information management,
- apply diverse technologies to information management, including the selection, organization, storage, retrieval, dissemination, and utilization of information resources, and
- develop systems and tools for information processing and management.
Required Texts
Rob, Peter & Coronel, Carlos. Database Systems: Design, Implementation, and Management. 6th edition (January 30, 2004). Cambridge, MA: Course Technology; 2001. ISBN: 061921323X.
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
Course Requirements
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
- January 28 from 10:00am-1:00pm (Room PLS 61) and
- March 11 from 10:00am-Noon, 1:00-4:00pm (Room PLS 61)
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 (9) | 90% |
| Final exam | 10% |
Grading Scale
The following grading scale will be used:
| 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+ |
| 72-74 | D |
Academic Integrity
Read the SJSU Academic Integrity Policy
http://www2.sjsu.edu/senate/S04-12.pdf
Reasonable Accommodation of Disabilities
If you need course adaptations or accommodations because of a disability,
please e-mail me as soon as possible. Presidential Directive 97-03 requires
that students with disabilities register with the Disability Resource Center
(DRC) to establish record of their disability.
No matter where students reside, they should contact the SJSU DRC to register. The DRC Web site: http://www.drc.sjsu.edu/
School of Library & Information Science
One Washington Square - San José, California USA, 95192-0029
Phone: 408-924-2490
Contact the webmaster
