Database Design and Implementation.

Catalog description

This course is designed to teach data modeling and SQL skills. Students will be able to define a well-structured relational database; use database design concepts to apply business rules and normalization models while creating Entity Relationship Diagrams (ERDs) and data dictionaries. Students will also write and run scripts; create select queries (using 'where' and 'order by' clauses, aggregate functions, inner and outer joins, and 'having' and 'group by' clauses), as well as action queries to update, delete, and append data. Students will also work with SQL to create a two-layer application. Spring. Prerequisites: CIS 150 or CIS 118 (or corequisites).