Home

Instructor: Tuan Pham (pham@eecs.oregonstate.edu)

Class Time: MTWRF 2:00-2:50 PM - Location: COVL 218 (map)

Office Hours: MW 3:00 - 5:00 PM or by appointment - Location: BAT 349 (map)

Course Content and Objectives

• 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 (tables)
     
• Web-Based Database Access:
  • HTTP protocol and CGI
  • Server-side scripting in PHP
     
• Relational Algebra
  • Relational operators and query formulation
  • Simple query optimization

Learning Outcomes: 

As a result of the learning experiences from this course, the students should be able to:

• Acquire the fundamental knowledge of database systems as well as web-based applications.
   
• Design normalized databases from users' requirements using E-R diagram. Know the rules to convert an E-R Diagram to Relational schema (tables).
   
• Employ SQL queries effectively to define and manipulate the databases.
   
• Employ PHP language effectively to access and present the data from the database.
   
• Implement a significant web-based application in PHP and MySQL. This application can be built from scratch or from an open-source framework.