ICS 113: Database Fundamentals (3 credits)

Course Description

This course examines file organization and the use of computer databases. It also examines the handling of information through its organization, management and control. A substantial part of the course develops an understanding of the data processing building blocks: files, records and fields. Techniques to report and maintain data are also covered. (3 hours lecture)

Pre-Requisite(s): Credit in ICS 100 or ICS 101 and placement in MATH 24, 25, 26, 28, 29, 82 or higher.


Student Learning Outcomes

Upon completion of the course, the student will be able to:

  • Show conversion of computer files into a database system by creating a simple database.
  • Compare a relational database to a flat database.
  • Dissect a database into tables, records, fields, keys, views and relationships.
  • Demonstrate the normalization process.
  • Find records using Structured Query Language (SQL) in a database.
  • Create reports with specific records.

For transfer information within the UH system, visit the System Transfer page


Resources


Classes Offered