
This is a Related Course of the MOT program.
This course is
concerned with the use of Database Management Systems (DBMS) to solve
a wide range of information
storage, management, and retrieval problems, in organizations ranging
from large corporations to personal applications, such as research
data management. The course combines the practical aspects of DBMS use
with
more theoretical discussions of database design methodologies and
the "internals" of
database systems.
A significant
part of the course will require students to design their own database and
implement it on different DBMS that run on different computer systems. We
will use both ACCESS and ORACLE.
In the theoretical portion of the course, we will examine the major types
or data models of DBMS (hierarchical, network, relational, and object-oriented).
We will discuss the principles and problems of database design, operation,
and maintenance for each data model. We will also examine implementation
options for database-driven Web applications, and students will have the
option of implementing their database project as a Web application.
