|
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.
|