Question: otshop%20Program.pdf CSDP-222 Campus Bookshop Program Introduction Two months before the beginning of each semester, the Campus Bookshop produces a Purchase Requirements Report. This report details

 otshop%20Program.pdf CSDP-222 Campus Bookshop Program Introduction Two months before the beginning
of each semester, the Campus Bookshop produces a Purchase Requirements Report. This

otshop%20Program.pdf CSDP-222 Campus Bookshop Program Introduction Two months before the beginning of each semester, the Campus Bookshop produces a Purchase Requirements Report. This report details the books that have to be purchased for the coming semester, In the past this was done manually but now management have decided to computerise the operation. Accordingly, lecturers' requirements have been captured and the results used to update a Purchase Requirements File. This is a permanent file that contains details of the lecturers' book requirements for both semesters You are required to write a program to produce a Purchase Requirements Report from the Publisher, Book and Purchase Requirements files. The report should be sequenced on ascending Publisher Name and should only detail the parchase requirements for the semester under scrutiny. The semester number (I or 2) should be accepted from the user at the start of the program using a simple ACCEPT and DISPLAY File Descriptions Purchase Requirements File (Indexed) There is a record for each book title required by a lecturer. Note that a book may be required by more than one lecturer Field KeyTypeType Lemgth Value -9999 -9999 1-999 R-Number Primary Name Alt with duplicates X20 Book-Number Alt with duplicates94 Module-Code Copies-Required Semesier Book File (Indexed) KeyType Type Length Value Primary9 Field 1-9999 ook-Number Publisher-Number Alt with duplicates 94 Book Title X30 otshop%20Program.pdf CSDP-222 Campus Bookshop Program Introduction Two months before the beginning of each semester, the Campus Bookshop produces a Purchase Requirements Report. This report details the books that have to be purchased for the coming semester, In the past this was done manually but now management have decided to computerise the operation. Accordingly, lecturers' requirements have been captured and the results used to update a Purchase Requirements File. This is a permanent file that contains details of the lecturers' book requirements for both semesters You are required to write a program to produce a Purchase Requirements Report from the Publisher, Book and Purchase Requirements files. The report should be sequenced on ascending Publisher Name and should only detail the parchase requirements for the semester under scrutiny. The semester number (I or 2) should be accepted from the user at the start of the program using a simple ACCEPT and DISPLAY File Descriptions Purchase Requirements File (Indexed) There is a record for each book title required by a lecturer. Note that a book may be required by more than one lecturer Field KeyTypeType Lemgth Value -9999 -9999 1-999 R-Number Primary Name Alt with duplicates X20 Book-Number Alt with duplicates94 Module-Code Copies-Required Semesier Book File (Indexed) KeyType Type Length Value Primary9 Field 1-9999 ook-Number Publisher-Number Alt with duplicates 94 Book Title X30

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!