IST 462: Databases Modeling and Application (3 credits)

   		      Spring 2008

		       Syllabus
____________________________________________________________

Instructor  : Prof. Dongwon Lee (dongwon -at- psu.edu)
Time        : M W 01:00P - 02:15P
Office Hour : W 11:00A - 01:00P (313A IST)
Location    : 110 IST

  Overview
  --------

The course is intended for junior/senior or entering graduate students
who took "Introductory Databases" course already, and want to learn
more about the design and implementation of advanced database
applications. The course will cover various technologies and
applications that use Databases technology (behind the scenes). Major
focus of the class is on the team-based projects.

Prerequisites:

- Basic understanding of Relational Databases
- Some level of proficiency in at least one programming language (e.g.,
  Java, C/C++, Perl, Python, Ruby)

Tentative topics include:

- DB basic (ER, Normalization, RDBMS, Triggers, and SQL)
- PHP + MySQL/SQL-Server application
- XML technology
- Web database application
- Semantic Web Services (using DB) application

Tentative implementation projects include:

- Bookstore management system
- Event monitoring system
- Google and Amazon web services application
- Information Mesh-up application

A required textbook* is:

- Web Database Applications with PHP and MySQL
  http://www.oreilly.com/catalog/webdbapps2/

*Feel free to buy used books for bargain

NOTE: If you have questions or are having problems in registering,
please contact the instructor.


Grading: Hybrid Curved grading

- 85-100: A/A- (25%) 
- 65-85 : B+/B/B- (35%) 
- 50-65 : C+/C (30%) 
- 0-50  : D/F (10%) 

Proportion:

- Attendance: 10%
- Class participation and discussion: 10%
- In-class quiz: 10%
- Presentation: 10%
- 3 Projects: 60%
- NO EXAM