1_DESIGN(school store)

1_DESIGN(school store)

1. Designing the System Processes

   • The type of data would be numbers and texts; data would not be very long; fieldnames would be name, code amount and short desciption of the product; not too much records because there is aproximately a high amount of information information.
   • Not too many times the data would be accessed; as quickly as possible the data needs to be accessed and the data files are aproximately large so a hard drive would be perfect to store the information. data.

2. Designing On-Screen Forms for Data Input

   • In the text box it would be placed the name of the product.
   • In the drop-down menus it would be placed the code of the product.
   • In another drop-down menu it would be placed the amount of each product and it would be modified automatically depending on the sales of the product.
   • In another text box the product would be shortly described.

3. Designing the System Outputs

   • Designing On-Screen Reports would be product details, in which it would be placed the code of the product, the name, a short description and an image.
   • In designing On-Print reports it would be the same as On-Screen the only thing that would change is that the report must fit in a piece of paper, should include paage numbers, header/footer, etc.

4. Data Validation Techniques

   • The presence check would be used for the code, name and the amount of the product because that info must be present.
   • The length check is necessary for the name, code and description, the length must be short.
   • A type check would be required in code and amount of the product (there can´t be letters).

5. Designing the Sytem Inputs

   • A barcode reader in which the information of each product is gathered and input at the same time, this will also function for stock control system.
   • A card reader in which the recharged money would be discount immediately after it passes through it.

6. Data Verification Techniques

   • The verification technique would be double-entry, so first one person enters all the information about the product and to be sure about it another person later will enter again the information and finally they will make a comparison between all the data.