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