New Jersey Institute of Technology College of Computing Sciences CIS365: File Structures and Management Rich Egan
A Public Research University

Quick Links: [365 Home] [Schedule] [Syllabus] [Materials] [WebCT access/info] [Homeworks]

Homework #H9: Indexes

Due Date:

See Syllabus

*** Submit all assignments here stapled together in a single package at the start of class, with your name on each page.

Part 1: Uckan Index Exercises

Read Uckan Chapter 13 starting with the section "Structure of VSAM/KSDS Implementation". (Note that in Figure 12, the values "Blake" and "Betty" are reversed.)

Cover the Short Essay Questions 22-43 on your own. Do not submit anything for these.

Submit Programming Exercises 3-5. (Not programming problems!) Use the STUDENT-FILE on the previous page in the text.

Part 2: Stern & Stern Index Exercises

Read all the sections in Stern and Stern chapter 15 on indexed files (but not on relative files).

1. Cover the review questions (true-false questions concerning indexed files, and general questions) on your own. Do not submit anything for these.
2. Submit the Debugging Exercises (also posted on the course Web site). 

Part 3: Index Program

Rewrite the two programs on the course Web site to create and use an indexed file - the book master file (instead of the product file). Use the following record layout for a book master file:

01 books.

05 book-id PIC X(5).
05 book-title PIC X(30).
05 book-type-author.

10 book-type PIC X(10).
10 book-author PIC X(20).

05 book-year PIC 9999.
05 book-price PIC 999V99.
05 inventory-level PIC 9999.

The book type is its category, such as "sci fi" or "cooking" or "travel".

Notes

• You will need to change the file and record layouts in both programs for the book master file.
  • The book ID is the main index. Make all seven other fields into alternate indexes.
• The first menu will add a new book to the master file.
  • You can optionally change the input routine so it uses a screen section.
  • Note: when you create test data, be sure to insert more than one record for the same author (i.e., records for several books by the same author)
• The second menu will display all the records in the file.
• The third menu item should retrieve the book for a given book ID.
• Be sure to change all screen, display and error messages so that they are much friendlier.

Extension

Once you have everything else working add the following functions (and add them to your menu too):

• add a routine to list all books by the same author to the computer screen
• create a report that lists all the books in the system, sorted by book-id to an output report file.

Submission

Staple everything together from all three parts.

Turn in:

• a printout of your COBOL code (.cob file) - use the Fujitsu editor to print your program
• a printout of your book data file - use the Fujitsu file utility to print your file
• a printout of your report file - use a word processor to print it

This page: hw9.htm