CS380 Database Design

This course covers data modeling with the Entity-Relationship model and introduces the relations algebra and its operators. The student will learn about the integrity constraints, how to translate an Entity-Relationship model into a relational model, functional dependencies, normal forms and normalization algorithms. The SQL language is introduced as a data definition language and a data query language. (Prerequisites: CS103 or 203)