LIBR 242-01
Database Management
Spring 2009 Greensheet

Dr. Geoffrey Z. Liu
Phone: (408) 924-2467
Office Location: Clark Hall 418L, SJSU Campus
Office Hours: Email & by appointment

Course Links
Course Calendar
Group Project
Individual Assignment
ANGEL Tutorials
SLIS e-Bookstore
LIBR 242 Resources
Online Resources
Sample Codes

Textbooks and Readings | Course Requirements

Course Description

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.

Class activities will be carried out in both the ANGEL and Elluminate systems. Enrollment in the ANGEL class is mandatory.

Course Prerequisites: 200, 202, 204, 240; Demonstrated computer literacy; 246 is recommended but not required.

Student Learning Outcomes

  • Students will understand the basic concepts of database models, database design, and database management systems;
  • Students will know how to design and implement a properly-normalized relational database;
  • Students will acquire an introductory level of skill in using the Oracle DBMS;
  • Students will be aware of management and social issues such as database security and privacy.

LIBR 242 supports the following MLIS Core Competencies:

  • Design, query and evaluate information retrieval systems
  • Understand the system of standards and methods used to control and create information structures and apply basic principles involved in the organization and representation of knowledge;

These additional MLIS Core Competencies are also supported by the course:

  • Use service concepts, principles and techniques that facilitate information access, relevance, and accuracy for individuals or groups of users;
  • Demonstrate proficiency in the use of current information and communication technologies, and other related technologies, as they affect the resources and uses of libraries and other types of information providing entities;

Course Requirements

Students' performance in this class will be evaluated by either of the following two options,

All written work should be word processed and should be free of grammatical and spelling errors.

If help is needed to improve your academic writing, free tutoring is available at the Learning Assistance Resource Center (924-2587, in the Student Services Center Room 600, by appointment or walk-in during regular business hours).

Late work will not be accepted unless the student has previously made arrangement with the instructor or has a legitimate reason with proper documentation in the case of unexpected urgent situation. PLEASE NOTE that it is the students' responsibility to submit and maintain the electronic version of their works until the final grades are issued.

Students' work will be evaluated according to the following specific criteria.

  • Basic content as required (70%);
  • Originality and creativity (10%);
  • Clarity of description (10%);
  • Writing/presentation (10%).

Letter grades may be assigned to assignments and exercises and later converted to points. At the end of semester, all earned points will be summated proportionally to yield the final grade.

The Standard SJSU SLIS Grading Scale will be used to translate letter grades to points and vice visa:

  • When letter grades are awarded for students' work, they are converted to points on the 100% scale using this table:

    *** A B C D F
      . 92.0 83.0 74.0 .
    . 98.5 89.0 80.0 71.0 0.0
    - 95.0 86.0 77.0 68.0 .
  • At the end of a semester, all of the points earned by a student are added up proportionally according to the ratios specified in the course syllabus. The total of points is rounded up to integer and then converted to a letter grade using the following table. The resulting letter grade is the final grade for the class.

Textbooks and Readings

Required Textbooks:

  • Loney, K. (2004). Oracle 10g: The Complete Reference. McGraw–Hill Osborne. Available through Amazon: 0072253517. arrow gif indicating link outside sjsu domain
  • Rob, P., & Coronel, C. (2007). Database Systems: Design, Implementation, and Management, (Eighth Edition). Course Technology. Available through Amazon: 1423902017. arrow gif indicating link outside sjsu domain

Grading Scale

The standard SJSU School of Information Grading Scale is utilized for all iSchool courses:

97 to 100 A
94 to 96 A minus
91 to 93 B plus
88 to 90 B
85 to 87 B minus
82 to 84 C plus
79 to 81 C
76 to 78 C minus
73 to 75 D plus
70 to 72 D
67 to 69 D minus
Below 67 F


In order to provide consistent guidelines for assessment for graduate level work in the School, these terms are applied to letter grades:

  • C represents Adequate work; a grade of "C" counts for credit for the course;
  • B represents Good work; a grade of "B" clearly meets the standards for graduate level work;
    For core courses in the MLIS program (not MARA) — INFO 200, INFO 202, INFO 204 — the iSchool requires that students earn a B in the course. If the grade is less than B (B- or lower) after the first attempt you will be placed on administrative probation.  You must repeat the class the following semester. If -on the second attempt- you do not pass the class with a grade of B or better (not B- but B) you will be disqualified.
  • A represents Exceptional work; a grade of "A" will be assigned for outstanding work only.

Students are advised that it is their responsibility to maintain a 3.0 Grade Point Average (GPA).

University Policies

General Expectations, Rights and Responsibilities of the Student

As members of the academic community, students accept both the rights and responsibilities incumbent upon all members of the institution. Students are encouraged to familiarize themselves with SJSU's policies and practices pertaining to the procedures to follow if and when questions or concerns about a class arises. See University Policy S90-5 at More detailed information on a variety of related topics is available in the SJSU catalog at In general, it is recommended that students begin by seeking clarification or discussing concerns with their instructor. If such conversation is not possible, or if it does not serve to address the issue, it is recommended that the student contact the Department Chair as a next step.

Dropping and Adding

Students are responsible for understanding the policies and procedures about add/drop, grade forgiveness, etc. Refer to the current semester's Catalog Policies section at Add/drop deadlines can be found on the current academic year calendars document on the Academic Calendars webpage at The Late Drop Policy is available at Students should be aware of the current deadlines and penalties for dropping classes.

Information about the latest changes and news is available at the Advising Hub at

Consent for Recording of Class and Public Sharing of Instructor Material

University Policy S12-7,, requires students to obtain instructor's permission to record the course and the following items to be included in the syllabus:

  • "Common courtesy and professional behavior dictate that you notify someone when you are recording him/her. You must obtain the instructor's permission to make audio or video recordings in this class. Such permission allows the recordings to be used for your private, study purposes only. The recordings are the intellectual property of the instructor; you have not been given any rights to reproduce or distribute the material."
    • It is suggested that the syllabus include the instructor's process for granting permission, whether in writing or orally and whether for the whole semester or on a class by class basis.
    • In classes where active participation of students or guests may be on the recording, permission of those students or guests should be obtained as well.
  • "Course material developed by the instructor is the intellectual property of the instructor and cannot be shared publicly without his/her approval. You may not publicly share or upload instructor generated material for this course such as exam questions, lecture notes, or homework solutions without instructor consent."

Academic integrity

Your commitment, as a student, to learning is evidenced by your enrollment at San Jose State University. The University Academic Integrity Policy F15-7 at requires you to be honest in all your academic course work. Faculty members are required to report all infractions to the office of Student Conduct and Ethical Development. The Student Conduct and Ethical Development website is available at

Campus Policy in Compliance with the American Disabilities Act

If you need course adaptations or accommodations because of a disability, or if you need to make special arrangements in case the building must be evacuated, please make an appointment with me as soon as possible, or see me during office hours. Presidential Directive 97-03 at requires that students with disabilities requesting accommodations must register with the Accessible Education Center (AEC) at to establish a record of their disability.

icon showing link leads to the PDF file viewer known as Acrobat Reader Download Adobe Acrobat Reader to access PDF files.

More accessibility resources.