Standard

 

CIS 124 - Microcomputer Database Programming

Course Description

Provides a study of database programming using microcomputer database management systems (DBMS) software packages. Topics include: development of systems, structured programming techniques, data editing, and output design.

 

Competency Areas

Hours

 

Development of Systems

Class

4

Structured Programming Techniques

D. Lab

6

Data Editing

P. Lab/O.B.I.

0

Output Design

Credit

7

 

Prerequisite/ Corequisite:

CIS 105, CIS 128

 

Course Guide

 

Competency

After completing this section, the student will:

Hours

Class

D.Lab

P.Lab/

O.B.I.

DEVELOPMENT OF SYSTEMS

7

10

0

Steps

Explain the steps, phases, and tasks necessary in the systems development life cycle.

 

 

 

STRUCTURED PROGRAMMING TECHNIQUES

19

20

0

Control structures

Identify the control structures allowed in structured programming.

 

 

 

 

Implement control structures using the DBMS package.

 

 

 

 

Design, code, test, and document database programs requiring menu selection; data entry; data editing; reports; and database update.

 

 

 

 

Use advanced debugging features available with the DBMS to debug programs.

 

 

 

DATA EDITING

7

10

0

 

Use techniques such as picture clauses to edit input data.

 

 

 

Verifying

Create DBMS programs which use data verification techniques.

 

 

 

OUTPUT DESIGN

7

20

0

Screen design

Design screens using the DBMS screen design tool.

 

 

 

Standard reports

Use the DBMS report generating function to produce various business reports.

 

 

 

Customized reports

Write programs or command files to print customized reports using one database file.

 

 

 

 

Write programs or command files to print customized reports using multiple database files.

 

 

 

 

Organize a database file by indexing or sorting in order to create output in desired formats.

 

 

 

 

Suggested Resources

 

Suggested Resources include textbooks shown below or most current edition.

 

Books

 

Carlton, T. W., & Stewart, C. O. (1986). dBase III plus applications library. Carmel, IN: Que Corporation.

Carrabis, J. D. (1987). dBase III plus networking and multi-user systems. Carmel, IN: Que Corporation.

Chou, G. T. (1987). dBase III plus tips, tricks, and traps. Carmel, IN: Que Corporation.

Hergert, D. (1987). dBase III Plus. Redmond, WA: Microsoft Press.