CIS 232 Database Programming

Data Modeling and Relational Database Design (DMRDD), including the use of Entity Relationship (ER) modeling is discussed in detail using practical business examples. Normalized, stable, maintainable, and well-defined relational databases are analyzed. Rules and constructs of Structured Query Language (SQL) and SQL*Plus, including various elements of the SELECT statement will be used to create, store, retrieve, and manipulate data in an Oracle database. This course has a computer lab fee. Prerequisite: For information technology students, CIS130. For business administration students, CIS206. Lecture Hours: 35; Lab Hours: 20.

Credits

4.5

Prerequisite

(( CIS130 D- O CIS130 TC O CIS130 CR ) O ( CIS206 D- O CIS206 TC O CIS206 CR ))