CS 540 Database Management Systems

Spring 2002

Instructor: Toshimi Minoura (minoura@cs.orst.edu)

Course 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
    • Embedded SQL
    • Relational model, relational integrity, etc.
  • Data Modeling:
    • Entity-relationship model
    • Converting an E-R schema into a relational schema
  • Web-Based Database Access:
    • HTTP protocol and CGI programming
    • Server-side scripting with ASP.NET
    • Web Services
  • Recovery and Concurrency Control

The pictures of Oregon sceneries are from Oregon Picture Album, copyrighted 1994, 1995 by Bernd Mohr, used with permission.

Schedule

Office Hours

Textbooks

Grading

Assignments

Course Outline

Viewgraphs

Demonstrations

Sample Code

Documentation

Additional Materials

Related URLs

Archived Mail

Home