CS145 - Introduction to Databases Autumn Quarter 96-97
Course Content
This course provides the student with an introduction to the design of
databases and the use of database management systems for applications.
We will cover object-oriented (O/O) and entity-relationship (E/R)
approaches to database design. We will cover the relational data
model, mappings from O/O and E/R designs to relations, relational
design issues, and how one uses a relational database management
system to implement a database. Abstract query languages such as
relational algebra will be discussed, along with extensive coverage of
SQL---the standard language for creating, querying, and modifying
relational databases. We will cover a variety of other issues
important to database designers and users, including views, integrity
constraints, triggers, transactions, and security. Finally, time
permitting, we will consider advanced database management features
such as logic-based query languages, object-oriented query languages,
and object-relational systems.
This course is aimed at database design and use, and the
implementation of database applications. It does not cover the
implementation of database management systems. This topic is covered
in the follow-on courses CS 245A and 245B.
