This course includes a review of database history, access methods, and data structures. Traditional databases are studied with an emphasis on relational database management system, architecture, operations, SQL, optimization, concurrency and conceptual entity-relationship model.
Implementation involves using a commercial relational database management system.
This course is designed for undergraduate and graduate students with minimal background in database processing. The course reviews database history with a comparison to file organization and presents hierarchical, network, and relational databases with concentration on relational, Structured Query Language at Data Definition Language as well as Data Manipulation Language. Issues of redundancy, higher normal forms, optimization, and concurrency control are studied. Entity relationship diagrams and design process are introduced. Some of the projects are implemented as team work with presentations.