Class Notes
and
Example Source Code

Stern and Stern
Power Point

CIS126 Home

Content Outline

Course Description

Evaluation
Criteria

Project 1

Project 2

Project 3

Project 4

Business Programming II Assignment 3

Date Due:  

Learning Objective: 

   Learn how COBOL can be used to create various data structures from common business transactions.  Design and write a structured program to organize and search data into keyed records.  

Definition of Problem:  "S3C World Wide" has many happy customers who are ordering many products.  A recent analysis of incoming orders shows that some customers are ordering multiple products.
  To better track sales, “S3C World Wide” will use a relational database, and needs a COBOL program to set up the following relational tables.

Customer Table:                                            Order Table:

Cust-Num 

Cust-Name, Address

Cust-Num 

Order-num 

Product-Num, Product-description, Date-ordered, Quantity, Unit-price, Tax, Total-price

 

 

 

  
Your assignment is the following

1)  Either write a new interactive program or modify assignment 2 to perform the following functions:
 a) Display and Accept the order screen. 20%
 b) Use the SEARCH command to look up the product-number on the product table, if not found, display error on screen, and have user re-enter. 20%
 c) Write the Cust-Num, Cust-name and address to a separate file that will be used to create the customer database table. 20%
 d) Write the Cust-Num, Order-num, and product info (shown in above Order Table) to a separate file to be used for the order database table. 20%
 e) Create a detail listing of  Cust-Name, Cust-Num, Order-Num, Order-Date, Total-Price.  Be sure to include a Grand-total at the end of the report. 20%

2) Create a unique Order-num for each product transaction entered for each customer. 5%.


Total Credits = 105%
 

Hand in; the working program on diskette, the program listing and output files.