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.
- Explore impact of Database Management System.
- Outline background and theory behind database design.
- Describe database structures and terminology.
Goal 2: Develop databases using relational design.
- Design database queries.
- Simple, compound, calculated fields, grouping and sorting.
- Table joins, update, delete, make-table.
- Function of the QBE method, determination of statistics.
- Construct queries using appropriate relational algebra.
- Employ the use of integrity rules.
- Entity, referential, legal-values.
- Define the data base structure.
Goal 3: Create databases using defined design methodology.
- Optimize database design using normalization.
- Identify design in first through fourth normal form.
- Define functional dependency.
- Apply appropriate primary key definitions.
- Construct entity-relationship diagrams.
- Create appropriate data indexes.
Goal 4: Create database reports.
- Design reports based on tables or queries.
- Apply multi-table methods for report design.
- Customize reports to include calculated controls.
- Construct reports which incorporate graphics.
Goal 5: Develop database forms.
- Create forms using single and multi-table/query designs.
- Apply custom controls to a form design.
- Use graphics to enhance form appearance.
- Design forms with embedded subforms.
Goal 6: Develop procedures for database vulnerability.
- Identify security issues within the database design.
- Illustrate data recovery procedures.
Add to Portfolio (opens a new window)