IST 462: Databases Modeling and Application (3 credits)

   		      Spring 2007

		       Syllabus
____________________________________________________________

Instructor : Prof. Dongwon Lee (dongwon -at- psu.edu)
Time       : T R 09:45A - 11:00A
Location   : 205 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) application building.

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:

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

Tentative implementation projects include:

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

Two required textbooks* are:

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

- Google Hacks, Third Edition
  http://www.oreilly.com/catalog/googlehks3/

*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

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

Proportion:

- Attendance: 10%
- Class participation and discussion: 10%
- Presentation: 20%
- Projects: 60%
  - 1-2 Individual projects
  - 1-2 Team projects