CSCI 351 Database Fundamentals and Design (Not offered 1997-98)

Recent years have seen an explosion in the amount of information available electronically. The storage of and retrieval from these volumes of data is generally the concern of a database. Maintaining and efficiently finding information in large databases, especially when many people are using a database concurrently, presents especially difficult and interesting problems. This course will consider the fundamental principles of database design. Included will be such topics as data independence, data dictionaries, the relational data model, the entity-relationship model, the object-oriented model, concurrency control, and distributed databases. The course will focus on both design and implementation issues. Query languages, query processing, and query optimization will be discussed as well as the relationship to the user-interface, database security and integrity, and social implications. Evaluation will be based on assigned problems, exams, and programming projects. Prerequisite: Computer Science 136.