INFO 242-01
INFO 242-10
Database Design and Management
Spring 2016 Greensheet

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


Greensheet Links
Textbooks
CLOs
Competencies
Prerequisites
Course Links
Online Resources
Resources
iSchool eBookstore

Canvas Information: Courses will be available beginning January 28th, 6 am PT 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 into the Canvas site automatically.

Class activities will be carried out in both the Canvas and Blackboard Collaborate (previously known as Elluminate) systems.

Course Description

Design and implementation of relational databases with web access for database-driven Web applications. Learn about database management systems (such as Oracle), database administration, and database querying with SQL.

Course Requirements

Assignments
Students will complete the following tasks for performance evaluation:

  • Individual assignment 10% -- CLO#1
  • Group project 60% (10% per stage) -- CLO#2 & CLO#3
  • Final exam (online) 30% -- CLO#1 & CLO#4

The individual assignment is an analytical review of database-driven web application (portal site), to gain appreciation of how it functions from the user's perspective, with speculation of potential data organization behind. The group project is to design and implement a relational database based on a chosen case scenario, and to implement a demo web access to the database using xSQL. The project is divided into six 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 SLIS Writing Resources for Students for numerous resources and free tutoring program.

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 final grades are issued.

Course Calendar

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

Unit Topic Tasks (all due by 11:30pm)
*
1/31
Orientation (9:00-11:45am)   
 1
2/1 
Introduction   
 2
2/8
Relational Database Model, Design & Implementation   Assignment DUE 2/14
3
2/15 
Entity-Relationship (E-R) modeling GP-1 Initial draft 2/18 
*
2/20-21 
Lab Session 1: Analysis of E-R Diagrams (hourly session per group during 9:00-4:00pm) GP-1 2nd draft 2/24

4
2/22

(Additional week to refine E-R design)  
5
2/29 
Database Management Systems  GP-1 DUE 2/28 
6
3/7
Normalization of Database Design  GP-2 DUE 3/6
7
3/14 
SQL for Database Implementation in Oracle   
*
3/20 
Lab Session 2: Database Implementation (all groups 9:00-11:45am)  GP-3 DUE 3/20 
8
3/21
(Additional week to complete database implementation)  
  Spring Recess (3/28-4/1)  
9
4/4 
SQL for Database Querying in Oracle GP-4 DUE 4/3
10
4/11
Web-Based Access to Relational Databases  
*
4/17
Lab Session 3: Server Access for xSQL (all groups 9:00-11:45am) GP-5 DUE 4/17 
11
4/18 
xSQL-Based Web Access to Oracle Databases   
12
4/25 
Database Administration and Advanced Topics GP-6 DUE 5/1
 13
5/2
Mock Test (5/2-5/8)  
 * Student Presentation of Group Project (Optional) Blackboard Recording
 14
5/9
Final Exam (5/9-16) DUE 5/16

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

  • Basic content as required (70%);
  • Originality and creativity (10%);
  • Clarity of description (10%);
  • Content 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.

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.

Textbooks

Required Textbooks:

  • Coronel, C., & Morris, S. (2014). Database systems: Design, implementation, & management (11th ed.). Cengage. Available through Amazon: 1285196147arrow 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;
    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 http://www.sjsu.edu/senate/docs/S90-5.pdf. More detailed information on a variety of related topics is available in the SJSU catalog at http://info.sjsu.edu/web-dbgen/catalog/departments/LIS.html. 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 http://info.sjsu.edu/static/catalog/policies.html. Add/drop deadlines can be found on the current academic year calendars document on the Academic Calendars webpage at http://www.sjsu.edu/provost/services/academic_calendars/. The Late Drop Policy is available at http://www.sjsu.edu/aars/policies/latedrops/policy/. 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 http://www.sjsu.edu/advising/.

Consent for Recording of Class and Public Sharing of Instructor Material

University Policy S12-7, http://www.sjsu.edu/senate/docs/S12-7.pdf, 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 http://www.sjsu.edu/senate/docs/F15-7.pdf 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 http://www.sjsu.edu/studentconduct/.

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 http://www.sjsu.edu/president/docs/directives/PD_1997-03.pdf requires that students with disabilities requesting accommodations must register with the Accessible Education Center (AEC) at http://www.sjsu.edu/aec 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.