CISP 247 - Database Design

3 Credits
This course will examine the major types or data models of Database Management Systems (DBMS): hierarchical, network, relational, and object-oriented. The principles and problems of database design, operation, and maintenance for data models will be discussed and compared. Topics include design theory, query language, relational expressions, SQL, stored procedures, client-server interfaces, entity relationship diagrams, normalization, and database security.

Recommended Prerequisite(s): CISP 111
Course Learning Outcomes:
1. Create SQL queries for business needs.
2. Implement entity-relationship models for databases.
3. Compare the characteristics of different types of data design.
4. Apply various modeling, normalization, and design techniques.
5. Explain the data structures, including security related to business needs.