Exercise 9.3 - Library Application

Objectives:

(i)To consolidate the aspects of database application progressing that

you have learnt so far in this module;

(ii)To develop an application based on the Library Database that utilises

existing frames/reports/forms together with new frames, to provide SOME of the functionality that would be required b y a functioning Library. You are to create a new application that will allow the user to access the various elements of the Library Database that you have developed. In this application you will develop a MENU SYSTEM for the Library Database, along with a new frame that w ill be used to maintain details in the RESERVATION table.

1)Create a new application called library.

2)Define a frame that will allow the user to maitain RESERVATION details. The

requirements for this Frame are:-

(a)The user is to enter a borrower's number, the name, address and status

of which are to be displayed for verification.

(b)Existing reservation details, for that borrower are to be displayed, i.e.

ISBN

Title

&Reservation Date.

(c)The user should then be allowed to add/update/delete reservation

details as required. The database RESERVATION table is to be updated from information on the screen. 3)Design and develop a MENU SYSTEM for your LIBRARY DATABASE

system that will allow the user to access:-

(a) The standard INGRES QBF facilities for general database maintenance.

(b)QBF facilities utilising the four QBFnames FORMS that you developed in

Exercise 7.1.

(c)The TWO reports that you developed in Ex. 8.2 part 1 & Ex. 8.3 part 1

(d)The bookupd Frame developed in Exercise 9.2.

(e)The reservation Frame developed in part 2) of this exercise.

You must name the top menu of your Library application mainmenu.

4)Using appropriate data test your application and correct any problems that your

testing brings to light.

5)Once the application has been thoroughly tested you should generate an Image-Executable file so that the application can be run from the command line (Dollar prompt).