IST 210 / Fall 2005 (by Dongwon Lee)
:: S Y L L A B U S ::
Overview: This is an introductory course to teach the fundamentals and basic principles of databases and their related technologies. Throughout this course, students will explore those areas, which are fundamental to the design, development, and implementation of enterprise wide information systems. In this course, we will cover the following major topics:
  • Introduction to Databases and Database Technologies
  • Conceptualization of Database Designs
  • Database Design Refinement
  • Database Design Implementation
  • Database Management and Administration
  • The Future of Databases

Textbook: Fundamentals of Database Management Systems by Mark L. Gillenson (ISBN:0471262978) is the required textbook. PSU Bookstore should have new copies ready, but "feel free to buy used books for bargain."

DBMS: This semester, we are switching to the Microsoft SQL Server as the DBMS to use in classrooms (we used IBM DB2 in 2003 and MySQL in 2004). If you are within PSU IP domain, you can read related books from O'Reilly's Safari for free. Our choice of the DBMS has nothing to do with the superiority of the product. Therefore, by all means, if you are already familiar with one, you are free to use other DBMS for your projects (i.e., MySQL, PostgreSQL, mSQL, DB2, Oracle, etc).

Time & Location

  • Section 1: M W 09:45A - 11:00A, 208 IST
  • Section 2: M W 01:00P - 02:15P, 208 IST


  • Instructor: Dongwon Lee, Email:, AIM: dongwon210
  • Boot Camp Instructor: Cong Chen, Email:, AIM: cong210Camp
  • TA: Robert Luo, Email:, AIM: ist210bluo
  • TA: Kun Bai, Email:, AIM: TA210kun
  • Helpdesk: IST 201, x38803

Office Hour

  • Mon: 11:00A - 1:00P, Dongwon Lee, IST 313A, Weekly Schedule
  • Tue: 1:00P - 2:00P, Kun Bai, IST 305B
  • Wed: 3:00P - 4:00P, Robert Luo, IST 321D

Grading is based on the Hybrid Curved policy

  • 80-100 (and/or 25%): A-/A
  • 60-80 (and/or 35%): B-/B/B+
  • 40-60 (and/or 30%): C/C+
  • 0-40 (and/or 10%): F/D

Grading Proportion (Subject to change)

  • Homework: 10%
  • Un-announced Quizzes: 10% (students can miss up to 1 quiz)
  • Projects: 25%
  • Open Book Midterm: 20%
  • Open Book Final: 30%
  • Miscellaneous (e.g., attendance, class participation): 5%


  • Web page password: to be announced in the first class
c o n t e n t s
  • News
  • Syllabus <<
  • Schedule
  • Project
  • Boot Camp
  • Course Conduct
  • PSU Policy
  • Powered by OSWD and NIKE research group