ITIS 160: Introduction to Database Concepts

Citrus College Course Outline of Record

Citrus College Course Outline of Record
Heading Value
Effective Term: Fall 2022
Credits: 3
Total Contact Hours: 54
Lecture Hours : 54
Lab Hours: 0
Hours Arranged: 0
Outside of Class Hours: 108
Strongly Recommended: ENGL 101.
Transferable to CSU: No
Transferable to UC: No
Grading Method: Standard Letter, Pass/No Pass

Catalog Course Description

This beginning course on database design focuses on the skills needed to define, create, and maintain a fully programmed database system using Microsoft Access in a Windows environment. The course covers database concepts, design, tables, queries, reports, and menus. 54 lecture hours.

Course Objectives

  • analyze data management needs
  • create appropriate tables and define appropriate relationships to meet specific database requirements
  • design, create, and modify appropriate forms for data entry and editing
  • design, create, and modify appropriate reports for data output
  • properly utilize appropriate techniques for sorting and filtering data
  • properly use queries to extract data from one or more linked tables according to a variety of criteria
  • import and export data to and from other data formats
  • determine database needs through interviews with prospective database users.
  • define needed fields for data capture and will construct objects for successful data extraction according to varying criteria.

Major Course Content

  1. Database Tables
    1. Identifying field data
    2. Field definition/properties
    3. Normalization
    4. Relationships
      1. Establish relationships
      2. Enforce referential integrity
      3. Cascades
  2. Queries
    1. SQL
    2. Inner/outer joins
    3. Field selection
    4. Sorting/filtering
    5. Criteria
      1. Single
      2. Multiple – AND/OR
  3. Forms
    1. Single/multi-table
    2. Active controls
      1. List box
      2. Check box
      3. Option button
    3. Form with sub form
  4. Reports
    1. Single/multi-table
    2. Calculated fields
    3. Subtotals
  5. Import/export data
    1. Excel
    2. Access
    3. Text delimited

Suggested Reading Other Than Required Textbook

None required

Examples of Required Writing Assignments

Students will outline data structures noting various fields with requisite properties prior to actual database creation.

Examples of Outside Assignments

Students will be required to create, modify, query, and report from various sample databases through selected case problems.

Instruction Type(s)

Lecture, Online Education Lecture