• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19

Setting up a business - Tod's Tyres.

Extracts from this document...


Tom O'Neill L6LY Tod's Tyres 8172 Introduction Tod's tyres is a company which deals in fitting new sets of tyres to fleets of cars. Tod has to record the details of each car, and send the owners a letter when the cars are due for new tyres. Previously, this could all be done manually, but the growth of the company has meant there is a need for a more efficient system. The existing system is all manual, with Tod or one of his clerks keeping a book containing all the details of cars he maintains, as well as the addresses of his clients. He writes out a letter on a basic word processor on his home computer, and changes the address manually. A new design is needed to make the company more efficient, as Well as increase the capacity for adding new customers in the future. Ideally, the system should be very easy to use, as Tod himself is not very experienced with computers. Because Tod hold's the details of his customers on this computer, it must be protected from unauthorised use. A good way to do this would be to protect either the entire computer or the database with a password Specification of solution The Solution, for it to be a complete success, must be capable of each of the following: 1. It must store each record in a way that it is easily visible, easily compared with similar records, and easily retrievable with a query 2. It has to be protectable with at least a password, to satisfy the requirements of the data protection act. 3. The database itself must be easy and intuitive to use for its users, and must be a stable and reliable program. ...read more.


more easily than having each record on paper, for instance, or even entering the information in a word-processing application. For example, it's a lot easier to add a record in-between two others, because a Database program like Access will automatically update other fields, like the "Autonumber" field, for example. It's also a lot easier to move the records down in the first place, because the database program has many spreadsheet features. The screenshot here shows the option clearly visible. However, performing the same operation in word can send records all over the page. Entity Relationship diagram This illustrates the relationships the solution will need to take into account. The relationships should ideally be linked in real time, so that changing the record in one table will automatically update the fields in another table. Database Notation: ACCOUNTS (Customer account ID, No. of cars name, company address ,company postcode, 5% discount?) CARS (Customer account ID, Car ID, Model name, Reg number, Last tyres date) CURRENT JOBS (Customer account ID, Car ID, Date in, reg number) TYRE STOCKS(Tyre ID, Number left in stock) Data dictionary Car Database Fieldname Type Description Customer ID Number duplicates OK Car ID Autonumber Duplicates not OK Comments Text (256 characters) Allows other car details to be recorded, e.g. year of production Reg Number Text Only accepts 'new' numbers (?? ?? ???) Tyre type needed Text - (P1000 OR P3000 OR P5000 OR P7000) Indicates which tyre type best suits the car Last change date Date/time Should display the date in days, months and years. Example... Accounts Database Fieldname Type Description Customer ID Autonumber Must be indexed, duplicates not OK No. of cars Number Preferably looks up quantity of cars listed 5% Discount? ...read more.


Using the switchboard to increase tyre stocks (e.g. following a delivery of fresh tyres) automatically updates the 'tyre stocks' table. The table is updated successfully, which suggests the switchboard has allowed for real-time editing of the database 9. Because of the following validation rules in the 'tyres used' field: Putting in a value greater than 5 or lower than 1 produces the following error message: Evaluation The system has left Tod with a powerful database of stock and account details. This has completely computerised the system, making it more efficient and productive. This has meant addresses are accessible at the touch of a button, saving time. The added increase in staff morale has made the firm more efficient, as happier workers are more productive. This increased efficiency will save the firm money in the short run. This means extra profit for the firm. However, improvements could still be made in the future, including these points: 1. Connecting the system to the internet, allowing Tod to simply email reminders to interested clients. This would make the entire system more reliable and efficient, since labour costs are reduced by eliminating the need for a clerk to put the letters in envelopes, etc. It also reduces the possibility for human error, as long as the details are correctly input in the first place. 2. Upgrading the computer to make the system more stable. More RAM in future upgrades may prove particularly useful. Also, over time the company may wish to transfer the details into a bespoke system. This would maximise processing power, since RAM is being dedicated only to the basic functions of the database, and not unnecessary functions such as a windows shell. Also, it would reduce the possibility of time being wasted by employees on unrelated applications, like games on the computer. Tom O'Neill Page 2 07/05/07 2944 Words ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Visual basic

    equals to false godown = False 'sets goup equals to true goup = True End If 'looks if the ball is at the top of the form If ball.Top < Me.Height - Me.Height Then 'sets goup equals to false goup = False 'sets godown equals to true godown = True

  2. Computing Project

    Rent Out A DVD Form procedure TFMRentOutaDVD.BtnClick(Sender: TObject); This procedure adds a record to the loans table outlining who has rented which DVD and at what price. procedure TFMRentOutaDVD.BtnPrintClick(Sender: TObject); This procedure is to print out a recipet after a customer has rented out a DVD procedure TFMRentOutaDVD.BtnExitClick(Sender: TObject); This

  1. Primary or Secondary Storage.

    Information or data is sent to the printer buffer, freeing memory to concentrate on other important tasks. Secondary/Backing Storage Backing storage is used for long-term data storage, usually on magnetic tape; magnetic disk or compact disk (CD) The storage is non-volatile.

  2. GCSE I.T Security Case Study - Riverside Leisure Centre

    There is one highlight of the software security system, this is that they abide by the Data Protection Act (1998) even though they are exempt by the rule that says, "Where a sports club or a recreational club that is not a limited company holds the data."

  1. Smart Card System

    Technology Encryption is the conversion of a piece of data or plaintext into a form, called a ciphertext, which cannot be easily understood by unauthorized people. Meanwhile, decryption is the process of converting encrypted data or ciphertext back into its original form so that it can be understood.

  2. System I designed in order to produce a promotion package for her newly formed ...

    and update data Internet * Download relevant information of the web such as page layouts, data structures and modern day music * You can open a new window to see another search result with a click of a button * You can get feedback from companies via the web using the e-mail service.

  1. Computing Project

    Table Availability Details Holds the details of all the available time slots in the coming fortnight, this allows the instructor only to see what is available, he can liaise with the student and once a slot is agreed a booking can be made.

  2. Describe the functions of each section within the shops and Head Office, paying particular ...

    Warehouse Clothing and footwear Administration staff Branch manager hands an annotated stock list to Administration staff who e-mails warehouse Task 2 An analysis of the processes for recording sales in a shop and for mail order sales in Head Office.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work