ICS 113: Database Fundamentals (3 credits)

Catalog 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. (Offered spring semester only.) (3 hrs. lect.)

Prerequisite: Credit for ICS 100 or ICS 101; placement into ENG 100 and MATH 24 and completion of OAT 20B, OAT 21B or BUSN 20B; or equivalent.

Student Learning Outcomes

• 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.

Degrees and Certificates at WCC the Course Applies To

• none listed yet

Resources

• Databases

Current Offerings

• none

Past Offerings

• None