2019 - 2020 Catalog 
    
    Mar 29, 2024  
2019 - 2020 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CMIS 255 - Microcomputer Database Applications

4 Credit: (4 lecture, 0 lab, 0 clinical) 4 Contact Hours: [CMIS 115 ]


This comprehensive course addresses concepts of database management and the application of a typical database system in various business applications using Microsoft Access. A strong component in database theory will be presented, as well as substantial hands-on database development.
OFFERED: spring semesters

Course Goals/ Objectives/ Competencies:
Goal 1:  Differentiate between various database models.

  1. Explore impact of Database Management System.
  2. Outline background and theory behind database design.
  3. Describe database structures and terminology.

Goal 2:  Develop databases using relational design.

  1. Design database queries.
  1. Simple, compound, calculated fields, grouping and sorting.
  2. Table joins, update, delete, make-table.
  3. Function of the QBE method, determination of statistics.
  1. Construct queries using appropriate relational algebra.
  2. Employ the use of integrity rules.
  1. Entity, referential, legal-values.
  1. Define the data base structure.

Goal 3:  Create databases using defined design methodology.

  1. Optimize database design using normalization.
  2. Identify design in first through fourth normal form.
  3. Define functional dependency.
  4. Apply appropriate primary key definitions.
  5. Construct entity-relationship diagrams.
  6. Create appropriate data indexes.

Goal 4:  Create database reports.

  1. Design reports based on tables or queries.
  2. Apply multi-table methods for report design.
  3. Customize reports to include calculated controls.
  4. Construct reports which incorporate graphics.

Goal 5:  Develop database forms.

  1. Create forms using single and multi-table/query designs.
  2. Apply custom controls to a form design.
  3. Use graphics to enhance form appearance.
  4. Design forms with embedded subforms.

Goal 6: Develop procedures for database vulnerability.

  1. Identify security issues within the database design.
  2. Illustrate data recovery procedures.



Add to Portfolio (opens a new window)