Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Output Record Structure (Student Report Record) The output record will be a structured on a single line as described below. You must use the ORGANIZATION

image text in transcribed
Output Record Structure (Student Report Record) The output record will be a structured on a single line as described below. You must use the ORGANIZATION clause as LINE SEQUENTIAL in the SELECT ASSIGN statement. STUDENT NAME filler (2 spaces) STUDENT AVERAGE (This field must be rounded to a whole integer) filler (4 spaces) PROGRAM NAME ( retrieved from the table) filler 4 spaces TUITION OWED (this field must be edited with inserted decimal point, commas as suppression of leading zeros) Output Record Structure (Column Header) You must have a Column Header Record at the top of the report with the words NAME, AVERAGE, PROGRAM, TIUTION OWED in line with the beginning of each field. Processing Notes The Student Average to be computed is the average mark from all 5 courses. Assume that all course averages contain valid values including zero. The Tuition Owed value on output must be edited as noted above. The Student Average is to be rounded to be an integer The records from the Program of Studies file are to be loaded into a table for use in the Student Report Records

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Constitutional Law Cases And Materials

Authors: Jonathan Varat, Vikram Amar, Evan Caminker

16th Edition

1647083613, 978-1647083618

More Books

Students also viewed these Law questions

Question

Explain the goal of behavior therapy.

Answered: 1 week ago

Question

2. Develop a good and lasting relationship

Answered: 1 week ago

Question

1. Avoid conflicts in the relationship

Answered: 1 week ago