INFO 242-01
INFO 242-10
Database Design and Management
Spring 2022 Syllabus

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

Syllabus Links
Course Links
Online Resources
iSchool eBookstore

Canvas Information: Courses will be available beginning on January 26, 2021, at 6 am PST, unless you are taking an intensive or a one-unit or two-unit class that starts on a different day. In that case, the class will open on the first day that the class meets.

You will be enrolled in the Canvas site automatically. Class activities will be carried out in both the Canvas and Zoom systems.

Course Description

Design and implementation of relational databases. Learn about database management systems (such as Oracle), database administration, and database querying with SQL.

Course Requirements

Students will complete the following tasks for performance evaluation:

  • Individual exercises 20% (5 points each) -- CLO#1
  • Group project 60% (12 points per stage) -- CLO#2 & CLO#3
  • Final exam 20% -- CLO#1 & CLO#4

The individual exercises are designed to practice concrete skills in preparation for each stage of the group project. The group project is to design and implement a relational database based on a chosen case scenario. The project is divided into five stages each building on the product of the previous stage. The final exam is for assessing theoretical understanding of basic concepts, and a mock version will be provided one week in advance for studying and practicing.

All written work should be word-processed and free of grammatical and spelling errors. If help is needed to improve your academic writing, see the Writing Resources for Students for numerous resources and free tutoring programs.

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

Course Calendar

(Tentative. Final version to be provided in the Canvas class site)

Unit Topic Tasks Due (all by 11:30 pm)
Orientation in Zoom (Sat. 1:00-3:30 pm, mandatory)   Self-intro in forum
Relational Database Model Ex-1
Database Design & Implementation (overview) Ex-2 
Entity-Relationship (E-R) Modeling GP-1 initial draft 2/25
Lab Session 1: Analysis of E-R Diagrams (hourly session per group during 9:00-5: 00 pm) .

Analysis & revision of E-R diagram
(Additional week to improve E-R modeling)

GP-1 2nd draft 3/3

 Database Management Systems 

GP-1 final
Database Design - Normalization: Concepts GP-2

SQL for Database Implementation in Oracle

Lab Session 2: Database Implementation (pre-recorded)



Spring Recess (campus closed)  

SQL for Database Querying in Oracle

Lab Session 3: Building SQL queries to answer info Qs (pre-recorded)

Concurrency Control & Phase Lock Ex-4
Web-Based Access to Relational Database (xSQL) GP-4
Database Administration & Advanced Topics .
Mock Test (online, available 5/2-8 11:00pm) GP-5
Final Exam (online, open 5/9-16, one attempt only of each Q) DUE 5/16

Students' individual/group works will be evaluated according to the following criteria:

  • Basic content as required (80%);
  • Originality and creativity (10%);
  • Documentation and content presentation (10%);

Letter grades may be assigned to assignments and automatically converted to proportionate points. At the end of the semester, all earned points are summated to yield a total which in turn is converted to the final grade. All conversions from letter to points and vice versa are done using the iSchool's standard conversion table as implanted in Canvas.

Course Workload Expectations

Success in this course is based on the expectation that students will spend, for each unit of credit, a minimum of forty-five hours over the length of the course (normally 3 hours per unit per week with 1 of the hours used for lecture) for instruction or preparation/studying or course related activities including but not limited to internships, labs, clinical practica. Other course structures will have equivalent workload expectations as described in the syllabus.

Instructional time may include but is not limited to:
Working on posted modules or lessons prepared by the instructor; discussion forum interactions with the instructor and/or other students; making presentations and getting feedback from the instructor; attending office hours or other synchronous sessions with the instructor.

Student time outside of class:
In any seven-day period, a student is expected to be academically engaged through submitting an academic assignment; taking an exam or an interactive tutorial, or computer-assisted instruction; building websites, blogs, databases, social media presentations; attending a study group;contributing to an academic online discussion; writing papers; reading articles; conducting research; engaging in small group work.

Course Prerequisites

INFO 200, INFO 202, INFO 204, Recommended: INFO 240

Course Learning Outcomes

Upon successful completion of the course, students will be able to:

  1. Demonstrate an understanding of the basic concepts of database models, database design, and database management systems (DBMS).
  2. Design and implement a properly normalized relational database.
  3. Use the Oracle DBMS with an introductory level of skill.
  4. Identify management and social issues such as database security and privacy.

Core Competencies (Program Learning Outcomes)

INFO 242 supports the following core competencies:

  1. E Design, query, and evaluate information retrieval systems.
  2. G Demonstrate understanding of basic principles and standards involved in organizing information such as classification and controlled vocabulary systems, cataloging systems, metadata schemas or other systems for making information accessible to a particular clientele.


Required Textbooks:

  • Allen, G., Hansen, G., & Jackson, R. (2022). Database management and design (1st ed.). MyEducator. Available Online From Publisher. arrow gif indicating link outside sjsu domain

Recommended Textbooks:

  • Loney, K. (2009). Oracle Database 11g: The complete reference. McGraw-Hill Osborne Media. Available through Amazon: 0071598758 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 or undergraduate (for BS-ISDA);
    For core courses in the MLIS program (not MARA, Informatics, BS-ISDA) — 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 if you wish to stay in the program. 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.

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

University Policies

Per University Policy S16-9, university-wide policy information relevant to all courses, such as academic integrity, accommodations, etc. will be available on Office of Graduate and Undergraduate Programs' Syllabus Information web page at: Make sure to visit this page, review and be familiar with these university policies and resources.

In order to request an accommodation in a class please contact the Accessible Education Center and register via the MyAEC portal.

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

More accessibility resources.