IST 210

Sections 3 and 4, Spring, 2003

[ Last modified: Wed Apr 23 10:48:47 EDT 2003 ]

Table of Contents


This is an introductory course used 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


Instructor Dongwon Lee 4E Thomas Bldg. Office Hour: Mon 1:30-2:30, Wed 4:00-5:00
TA Harshal Haridas 4.5 Thomas Bldg. Office Hour: usually Fri Lab time


Required A First Course in Database Systems (2nd Edition)
by J. Ullman, J. Widom (ISBN 0-13-035300-0)
Optional Database Management with Web Site Development Applications
by G. Riccardi (ISBN 0-201-74387-6)

Time and Place

  • Section 3: M W F 02:30P - 03:45P, 111 BOUCKE
  • Section 4: M W F 11:15A - 12:30P, 112 BOUCKE


  • Assignments (5-7): 30%
  • Projects (2-3): 20%
  • Midterm (1): 20%
  • Final (1): 30%


Project Teams


1. Downloads are password-protected.
2. Subject to change -- reload frequently.

Date Topic Book Slide Homework Project Note
1/13 Introduction Ch 1 Introduction HW #1 Password is given in class.
1/15 ER Ch 2 Joaquin's version (2/page)
New version (3/page)
1/17 Lab Web and HTML Basics web There is a lecture
1/20 ER
1/22 ER Jeopardy Problems and answers In-class team competition
1/24 Lab ER Lab
(from IST Solutions Institute)
HW #1 Due Project team formation Due
(upto 4 people)
1/27 Relational Ch 3 Relational Model / FD HW #2
1/29 Relational Proj #1
1/31 Lab Unix/SSH/DB2 tutorial Unix
2/3 Relational Normalization / MVD (NEW VERSION) HW #2 Due Solution
2/5 Relational HW #3
2/7 Lab DB2 tutorial Connect, Script,
2/10 Normalization Review Ch 3 Internet Bookstore Case We will review and play with problems
2/12 Lab Self-study or project time There is a NO lecture, but is a LAB
2/14 Relational Algebra Ch 5 rel-algebra.pdf NOTE: There IS a lecture
Make-up Officehour (1:30-2:30)
2/17 Relational Algebra Ch 5 CANCELED: Snow Day
2/19 Relational Algebra
2/21 Lab Self-study or Project time
2/24 SQL Ch 6 SQL 1 HW #3 Due Solution Proj #1 Due
2/26 SQL SQL 2 HW #4 Proj #2
2/28 Lab Self-study or Project time
3/3 SQL SQL 3
3/5 In-class Midterm Midterm Solution Open Book, Open Note Exam
3/7 Lab Self-study or Project time HW #4 Due Solution
3/10-14 Spring Break
3/17 Midterm Review Proj #2, Part 1 Due (midnight)
3/19 SQL ppt, pdf
3/21 Lab Self-study or Project time
3/24 SQL
3/26 SQL Grades: Section 3 and Section 4 Proj #2, Part 2 and 3 Due
3/28 Lab HW #5
3/31 SQL View, Derived Relations, Null Proj #3
4/2 Lab PHP I php1.ppt HW #5 Due
Solution: dul13.sql, dul13_out.txt
DB2 connection using PHP
4/4 Lab PHP II Section 3 PHP Tutorial, Section 4 PHP Tutorial PHP Language Basics
4/7 Integrity, Triggers Avi-Check.ppt
4/9 Triggers Avi-Triggers.ppt
4/11 Lab PHP III Grades so far
Sec 3 PHP Tutorial 2, Sec 4 PHP Tutorial 2
HW #6 PHP Language Basics (cont.)
4/14 Security ppt
4/16 Review: Relational Algebra ppt
4/18 Lab HW #6 Due, Solution
4/21 Review: Normalization ppt
4/23 Review: Normalization ppt
4/25 Lab CANCELLED Proj #3 Due
4/28-5/2 Project Presentation
5/6 Final: T 06:50 PM 111 WARTIK: Exam Coverage


University Policies

Academic Integrity: According to the Penn State Principles and University Code of Conduct: Academic integrity is a basic guiding principle for all academic activity at Penn State University, allowing the pursuit of scholarly activity in an open, honest, and responsible manner. In according with the University's Code of Conduct, you must not engage in or tolerate academic dishonesty. This includes, but is not limited to cheating, plagiarism, fabrication of information or citations, facilitating acts of academic dishonesty by others, unauthorized possession of examinations, submitting work of another person, or work previously used without informing the instructor, or tampering with the academic work of other students. Any violation of academic integrity will be investigated, and where warranted, punitive action will be taken. For every incident when a penalty of any kind is assessed, a report must be filed. This form is used for both undergraduate and graduate courses. This report must be signed by both the instructor and the student, and then submitted to the Senior Associate Dean.

Affirmative Action & Sexual Harassment: The Pennsylvania State University is committed to a policy that all persons shall have equal access to programs, facilities, admission, and employment without regard to personal characteristics not related to ability, performance, or qualifications as determined by University policy or by Commonwealth or Federal authorities. Penn State does not discriminate against any person because of age, ancestry, color, disability or handicap, national origin, race, religious creed, gender, sexual orientation, or veteran status. Direct all inquiries to the Affirmative Action Office, 211 Willard Building.

Americans with Disabilities Act: IST welcomes persons with disabilities to all of its classes, programs, and events. If you need accommodations, or have questions about access to buildings where IST activities are held, please contact us in advance of your participation or visit. If you need assistance during a class, program, or event, please contact the member of our staff or faculty in charge. Access to IST courses should be arranged by contacting the Office of the Senior Associate Dean, 002D Thomas Building: (814) 865-4457

An Invitation to Students with Learning Disabilities: It is Penn State's policy to not discriminate against qualified students with documented disabilities in its educational programs. If you have a disability-related need for modifications in your testing or learning situation, your instructor should be notified during the first week of classes so that your needs can be accommodated. You will be asked to present documentation from the Office of Disability Services (located in 116 Boucke Building, 863-1807) that describes the nature of your disability and the recommended remedy. You may refer to the Nondiscrimination Policy in the Student Guide to University Policies and Rules.

The NIKE Group