DBMS packages-1

Each record will have to contain details about a customer. What constitutes ‘the necessary details’ will depend mostly on what use we want to make to this data-base. When we create a customer file through dBASE III package, it will first want us to specify the record structure for the file. For a blinds company who are selling vertical blinds, roman shades products online. When they are creating their DBMS file, their criteria is different than for the company who are providing instant life insurance rates and life insurance quotes online.

 

For a customer file we want each record to have nine fields: one each for the items listed above. In dBASE III, it is necessary to give names to each of these nine fields so that they can be later referred to using these names. The field names which we have chosen are shown in the third column above. Apart from the name, we have to also indicate what type of data will be stored in the field and in certain cases number of characters to be reserved to hold the data for that field. We will want AMOUNTDUE and CRDLMT to hold numeric data and all other fields to hold text or character data. Now let us have a quick look at a dialogue in dBASE III for creating and using such a file.