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, 203
IST
Staff
- Instructor:
Dongwon
Lee, Email:
,
AIM: dongwon210
- Boot
Camp Instructor: Robert Luo,
Email:
,
AIM: ist210bluo
- TA:
Louis-Marie Ngamassi Tchouakeu,
Email:
,
AIM: tchouakeu
- TI:
Jeremiah Hiam, AIM:VanguardJ, DeJian Fang, AIM: dqf5000
- Helpdesk:
IST 201, x38803
Office Hour
- TA: Mon, 02:00P - 04:00P,
IST 321D
- Instructor: Wed, 11:00A -
01:00P,
IST 313A, Weekly
Schedule
Grading is based on the Hybrid Curved policy (subject to change)
- 80-100 (or 25%): A-/A
- 60-80 (or 35%): B-/B/B+
- 40-60 (or 30%): C/C+
- 0-40 (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
|