|
|
New Jersey Institute of
Technology
|
|
A Public Research University |
Quick Links:
[Materials]
[WebCT access/info]
To apply the concepts and skills we're learning in class to a larger case.
See Syllabus
Work in more detail to design 4 reports, which could be printed out, for the employees in your semester project domain (mail order store). You should include some from your brainstorming (assignment P1) or make up new ones instead.
Each report should display the records from one or more data files, with some calculations or other manipulations. (This could include printing subtotals, totals, counts, percentages, etc.) You can look over the sample report layouts in Stern & Stern chapter 10 for some examples. Yours, of course, will be completely different.
Two of your reports should list out (some or all) records from a single data file, including some calculations or other manipulations. Include some sub-totals or sub-counts for records grouped by some characteristic (for example, number of people per ride per day and total for all rides; total items per order and total for all orders).
Two of your reports should combine records from 2-3 data files. For example, if you were to print out a class list, it could combine information from the registration file (class and student IDs), class file (course name), section file (professor ID, meeting information), student file (student names), professor file (professor name), etc. Of course you don't need to be this complex.
Try to limit yourself to 2-3 data files in total.
Turn in the rough design of each report with a few lines of sample data and the calculations/manipulations for each. Neatly hand-written is fine, but be sure to keep a copy for yourselves.
Review Semester Assignments P3 and P4 before designing your reports!
Work in more detail to design the data files used in the four reports from Part 1.
Try not to have more than 8 fields in each file, and aim for fewer if practical. Make sure each data file has a unique ID or a set of fields that together uniquely identifies the records.
Turn in your file declaration as it would appear in the FILE SECTION of the DATA DIVISION. This includes the FD and the record layout (01, 05, etc.)
MUST BE TYPED will need to save to disk.
Staple everything together. Put the name of everyone in your group on the front. Be sure to include your name. Only one submission per group, please.
This page: p2.htm
To comment on this Web site, please email bieber
@ oak.njit.edu
