Home Schedule Office Hours Textbooks Grading Assignments Course Outline Slides Programming Documentation Additional Materials Related URLs Archived Mail

CS 275 Introduction to Databases Fall 2009 Instructor: Toshimi Minoura (minoura@cs.orst.edu) Course Content Data Management Fundamentals: Integrated data management DSL = DDL + DML Conceptual schema, internal schema, and external schemas. Relational Database Systems: Creating a relational database Formulating SQL queries Creating indices to improve performance Data Modeling: Entity-relationship model Converting an E-R schema into a relational schema Web-Based Database Access: HTTP protocol and CGI Server-side scripting in PHP Relational Algebra Relational operators and query formulation Simple query optimization The pictures of Oregon sceneries are from Oregon Picture Album, copyrighted 1994, 1995 by Bernd Mohr, used with permission.