CSI 156 - Introduction to Database Theory and Design

Credits 7
This course offers an introduction to relational database design theory. Students learn about components of database system as well as an entity-relationship model, tables, form normalization, indexes, primary keys, queries and Structured Query Language (SQL). We discuss the use and application of relational databases versus flat file database structures.
Prerequisite(s): CSI 102.
Course Outcomes

Demonstrate competency in the application of the rules of Relational Database Design in designing and building relational databases, which organize, store, retrieve, and display data in a manner that would be useful in business to support strategic decision making.
Demonstrate competency in using Database Management tools to manipulate various data types, to achieve consistency of data, for support of accurate output reporting for business.
Demonstrate competency in using Database Management tools (Querying and Reporting) to correctly summarize business data, for support of accurate output reporting for business, to support strategic decision making.
Demonstrate basic competency in using Database Design Tools (Forms and Controls) to create a Graphical User Interface (GUI) for a business Database.
Demonstrate competency in utilizing Structured Query Language (SQL) to query and manipulate data.