Tod's Tyres is a small business that supplies new car tyres to company car fleets and car hire firms. I have been asked to create a computer application, either programmed or using a database, to replace the current manual record-keeping system.

Authors Avatar

Tod’s Tyres – The Practical Exercise 2004

Contents

Design        

 
Design

Background

Tod’s Tyres is a small business that supplies new car tyres to company car fleets and car hire firms.

I have been asked to create a computer application, either programmed or using a database, to replace the current manual record-keeping system.

Definition of data requirements

When a car is brought to Tod, the following information is recorded on the card “CARDTBL”: (invoice number), (car registration number), (company name), (type of tyre), (date), (car mileage), (number of new tyres fitted), (comment) and (total price).

The next time the company books in a recorded car for new tyres, Tod checks the cars file to see what type of tyre that car has fitted; he then ensures hat he has the required tyres in stock: “PRICELISTTBL” (type of tyres), (manufacturers code) and (customer’s price ex VAT).

Tod gets his tyres from one supplier only. This supplier sends him an up-to-date supplier list once a month. Some companies are allowed a 5% discount before VAT is added.

Tod keeps company details: “COMPANYDETAILSTBL” (company name), (contact name), (street address), (town/city), (post code), (telephone number) and (discount offered).

CARDTBL:

PRICELISTTBL:

COMPANYDETAILSTBL:

User interface design including output, forms and reports

In this particular exercise, I have created each form and report by using wizards, supplied through the software used.

Form design of “cardtbl”…

Join now!

Report design of “invoice”…

Method of data entry, including validation

I intend ...

This is a preview of the whole essay