Introduction to Database Management
Section A Fall Tue, Thu 14:30-16:00
Section M Winter Tue, Thu 8:30-10:00
Concepts, approaches and techniques in database
management systems (DBMS). Logical models of
databases: relational, network and hierarchical DBMSs.
An introduction to relational database design. Other
topics such as query processing, crash recovery and
The purpose of this course is to introduce students to
the fundamental concepts of database systems. The four
major database models: the relational model, the entity-
relationship model, the network and the hierarchical
model are treated. However, the relational model and
the design of relational databases are emphasized, due to
their increasing importance in database research and
practical industrial application. Other important aspects
of database systems Ð query processing, crash recovery
and concurrency control may be also discussed. At the
end of this course, a student will be able to understand
and apply database system concepts in the use or design
of database management systems.
Topics covered may include the following.
- Intro. to database management systems
- Entity-Relationship Model
- Hierarchical Model
- Network Model
- Relational Model (SQL, dependencies,
- Query processing
- Crash recovery; Concurrency control.
- George Koch and Kevin Loney, Oracle: The Complete Reference, 3rd
edition, Oracle Press, Osborne McGraw-Hill, 1995
- plus one of the following Suggested Readings.
- H.F. Korth and A. Silberschatz, Database System
Concepts, 2nd edition, McGraw-Hill, 1991.
- R. Elmasri and S. B. Navathe, Fundamentals of
Database Systems, 2nd edition, Benjamin
- Patrick O'Neil, DataBase: Principles Programming, Performance,
Morgan Kaufmann, 1994