Catalog Course Search Details

 Department:    IMDS

 Course #:    130

 Credits:    5

 Variable:     No

 IUs:    5

 CIP:    30.7101

 EPC:    573

 REV:    2021

 Course Description  

Introduction to relational database concepts and management systems. Topics include database design, data normalization, user interface, testing, and data manipulation using query by example and Structured Query Language (SQL).

 Prerequisite  

Prerequisite: IMDS 101 with a grade of C or higher.

Contact Hours (based on 11 week quarter)

Lecture: 55

Lab: 0

Other: 0

Systems: 0

Clinical: 0

Intent: Distribution Requirement(s) Status:  

Vocational Preparatory Required for ATA degree  

Equivalencies At Other Institutions

Learning Outcomes

After completing this course, the student will be able to:

1. Design a relational database, using appropriate procedures.
2. Create and normalize data relationships.
3. Manipulate data using query by example and Structured Query Language.

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

Course Contents

1. Relational Database Model comprehension.
2. Database design objective.
3. Database terminology.
4. Database design procedure.
5. Normalization and relationships.
6. Data manipulation using query by example and Structured Query Language.