Prerequisite: CS 211
This course introduces the basics of database systems, as well as the modeling, desgin and manipulation of relational databases. At the end of this course, a student will be able to understand and apply the fundamental concepts required for the use and design of database systems. Topics include basic concepts and terminology of the database approach, data modeling (the entity relationship model, relational data model), database design theory (entity relationship to relational mappings, normalization using functional dependencies), data definition and manipulation languages (relational algebra, SQL). The course will enable the students to create and manipulate databases on the Oracle database management system.
