Database System Design & Mgmt. 3 credits, 3 contact hours

Catalog description

Prerequisites: CS 114 or CS 116 or IT 114 or equivalent with a grade C or better. This course provides an introduction to modern database systems, covering database system architecture, data models, the Entity-Relationship model, the Relational model, a formal query language (Relational Algebra) and the standard database language SQL, database design theory (functional dependencies and normal forms), database storage, and transaction processing. Students will learn how to design, create, query and update a database through a small project using SQL.