DOEACC Society 2007 Advanced Level Course In Computer Science A2-R3: BUSINESS SYSTEMS - Question Paper

5. Answer any 5 of the subsequent in not more than 100 words:
a) Visual FoxPro permits 4 various kinds of indexes. define in brief about every 1 of them.
b) Write the steps to the change the structure of an existing table in Visual FoxPro.
c) Write the steps that you will take to create multiple key index using the Table Designer dialog box.
d) Explain with an example the use of a Macro (&) command.
(5 x 3)

6. Answer any 3 from the following:
a) Visual FoxPro has a few built in date functions by which you can do any date-oriented tasks. define any 5 of them in the subsequent tabular format:
Date Function Meaning of the Date Function Format in which you will use






b) The subscribers’ details of a magazine are maintained in a database. The fields are Subscriber number, Subscriber name, Address (three fields) and Expiry Date (Month and Year in the form MM/YY). Write a command module to accept month and year through terminal and printout names and addresses of all subscribers whose subscriptions are expiring in the next month. The printing should be done in such a way that the name and address could be used as an address sticker.
c) Consider the subsequent library database.
Field Name Description Type Width
TITLE Book Name Character 50
AUTHOR Name of author Character 30
CLASS Number of book Character 10
DETAIL Details of the book Memo 10
STOCK Quantity in stock Numeric 3
ISSUED Quantity issued Numeric 3
Write procedures that will handle the subsequent queries on such a database:
i) A query enquiring whether a particular book is available.
ii) A query enquiring about the books written by an writer.
iii) A query enquiring about books of the identical name but by various writers.
d) The names of persons are available in a database split into 3 fields:
FIRSTNAME, MIDNAME AND LASTNAME.
It is desired that names of the persons be printed in alphabetical order of LASTNAME. It is however obtained that a few records have blanks in the field LASTNAME. In such cases the MIDNAME should be taken as LASTNAME.
Write a program in Visual FoxPro to print it as directed.
(5 x 3)








7. A credit card company maintains the records of its customers in a table named CUSTOMER.DBF. The structure of the table is provide below:

Field Name Type Width Dec Remarks
CUST_NO Char 5 Customer Number
C_FNAME Char 10 Customer's 1st Name
C_MNA ME Char 10 Customer's Middle Name
C_SNAME Char 10 Customer's Surname

Earning:   Approval pending.