PCC/ CCOG / CIS

Course Content and Outcome Guide for CIS 125D

Course Number:
CIS 125D
Course Title:
Database Application Dev I
Credit Hours:
4
Lecture Hours:
30
Lecture/Lab Hours:
0
Lab Hours:
30
Special Fee:
 

Course Description

Concepts of a client-based relational database management system (RDBMS) and application of such systems to the business environment. Topics include database management issues, database design, creating and maintaining databases, creating forms, queries and reports. Design, create and maintain a database system. Recommended: CIS 121 or instructor permission. Audit available.

Intended Outcomes for the course

  • Demonstrate the process of designing, creating and maintaining a database, including normalization to third normal form.
  • Develop complex tables, forms, queries and reports in a client-based database system (DBMS).
  • Develop elementary SQL statements.

Outcome Assessment Strategies

Completion of 1 or more projects that demonstrate ability to do each of the following, without using wizards:
  • Translate complex user requirements into a design that requires one-to-many (1:M) and many-to-many (M:N) relationships.
  • Translate a database design into database tables.
  • Create database tables.
  • Diagram entity relationships, including 1:1, 1:M and N:M ordinality and cardinality.
  • Use data validation at the field level including input masks, validation rules and IS NOT NULL with text, numeric and date data types.
  • Manage and customize the working environment within the DBMS.
  • Demonstrate the use of routine maintenance functions on a database to improve performance.
  • Create select, aggregate, parameter and action queries involving multiple tables, calculated fields, inner and outer joins and complex record selection criteria.
  • Create complex forms for input and display of data, including single record forms, form/subform and summary calculations.
  • Use of a variety of controls on a form, including combo boxes for selecting data and searching the underlying form recordset.
  • Design and create complex reports to display data, including grouped data with subtotals and grand totals.
  • Integrate objects created by other applications into forms or reports.
  • Create simple switchboard navigation system between forms and reports.
  • Create a Mail Merge using a database and a word processing application.
  • Demonstrate the use of Elementary SQL statements: SELECT, UPDATE, INSERT, DELETE.

Course Content (Themes, Concepts, Issues and Skills)

(Themes, Concepts, Issues, Competencies and Skills)
  • Analyzing user requirements
  • Database design
  • Normalization
  • Relationships
  • Concepts and capabilities of a database management system (DBMS)
  • Database terminology
  • Database maintenance
  • Forms
  • Queries
  • Reports
  • Validation
  • Elementary SQL statements