CGS 1545 - Database Techniques

College of Computer & Information Technology

Credit(s): 3
Contact Hours: 47
Effective Term Fall 2017 (535)

Requisites

Prerequisite COP 1000 with a minimum grade of C or
Prerequisite CGS 1100 with a minimum grade of C

Course Description

This course will provide students with hands-on experience in creating and maintaining a relational database application. Students will learn the various functions and commands of the database as well as how to plan, normalize, create, use, and program fully relational databases for common business applications. Students will learn relational database theory and design, formal naming conventions, and database programming techniques.

Learning Outcomes and Objectives

  1. The student will design a complex database to achieve business standards by:
    1. Planning the structure and format.
    2. Constructing a relational database with tables, field structure, types and properties.
    3. Creating an E-R (entity – relationship) diagram.
    4. Importing and exporting data from and to external programs.
  2. The student will create forms, queries and reports by:
    1. Designing, editing and formatting simple and complex forms, queries and reports.
    2. Setting up calculated fields.
    3. Employing the use of Structured Query Language (SQL).
  3. The student will maintain database integrity by:
    1. Performing backup procedures to ensure safety of data.
    2. Applying methods for ensuring security in a multi-user environment.

Criteria Performance Standard

Upon successful completion of the course the student will, with a minimum of 70% accuracy, demonstrate mastery of each of the above stated objectives through classroom measures developed by individual course instructors.

History of Changes

DBT 11/21/89 Effective Session 19901 DBT 5/17/94 Effective Session 19941 C&I 6/5/96, DBT 6/18/96 Effective Session 19961 Online, effective 2000 1. 2000 3-year review revised at C&I 10/23/01, BOT 11/20/01 Effective yrtr 20012 (Sess II, 2001). 2009 3-Year Review minor changes. C&I Approval: 05/31/2013, BOT Approval: 06/17/2014, Effective Term: Fall 2014 (490).
C&I Approval: 02/09/2017, BOT Approval: 03/21/2017, Effective Term: Fall 2017 (535)

Related Programs

  1. Applied Information Technology PCS (AITHS-AR) (620) (Active)
  2. Computer Information Technology (CIT-AS) (640) (Active)
  3. Help Desk Support Specialist (HDSK-CT) (530) (Active)
  4. Microsoft Office Specialist – Microsoft Office Access (to CIT-AS) (MOSACIC-AR) (640) (Active)
  5. Microsoft Office Specialist – Microsoft Office Access (to HDSK-CT) (MOSAC2IC-AR) (640) (Active)
  6. Microsoft Office Specialist – Microsoft Office Access 2016 or later (MOSAIC-AR) (630) (Draft)
  7. Technology Development & Management (TMGT-TR) (670) (Active)
  8. USF Tampa - Cybersecurity (FTCYSEC-TR) (670) (Active)
  9. USF Tampa - Information Technology (FTINFO-TR) (670) (Active)