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
Staff
- Instructor: Dongwon Lee, Email: dongwon@psu.edu,
AIM: dongwon210
- Boot Camp Instructor: Cong Chen,
Email: cchen@ist.psu.edu, AIM: cong210Camp
- TA: Robert Luo, Email: bluo@ist.psu.edu,
AIM: ist210bluo
- TA: Kun Bai, Email: kbai@ist.psu.edu,
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%
ID/PWD
- Web page password: to be announced
in the first class
|