• 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

    the number of records in adofilms is 0 then dvdid:=0//give the DVDID as 0 else//otherwise begin//begin adofilms.Open;//open adofilms adofilms.last; dvdid:=adofilms['dvdid'];// insert the value of the variable dvdid into the field DVDID in the access table end; DVDid:=DVDid+1;//add 1 to whatever value the variable DVDID is ADOFilms.Append; ADOFilms ['DVDId']:=DVDid;//insert the value

  1. Video Club Database Project

    Viewing a record To view a record, find it using the Find record list box. Deleting a record To delete a record, first find it using the Find record list box, change the information and click on Delete record. View a report In order to view a report, click on 'Film Report'.

  2. Today's competitive global business environment, understanding and managing enterprise wide information is crucial for ...

    They are triggered at a certain point in time, or by an event or an action performed by users. * Trap door - or back door is a routine that is built into a system by its designer or programmer.

  1. Tod's Tyres is a small business that supplies new car tyres to company car ...

    Currency COMPANYDETAILSTBL: Field name Data type Validation Company name Text 25 characters limit Contact name Text 25 characters limit Street address Text 50 characters limit Town/city Text 25 characters limit Post code Text Input mask Telephone number Text 11 characters limit Discount offered Percentage Either 0% or 5% User interface

  2. I have been given the task to design a database for a company called ...

    buttons or macros these allow you to open and close forms at the click of a button. They also allow you to do things like run a query or calculation. * Excel allows you to highlight different cells in colour and fill effects.

  1. Spare Parts Database Project

    Wong; He gets Rs 7000 per month. 13. Self: How many customers do you have? Mr. Wong; Up to date, we have about 200 clients and this is increasing year by year. 14. Self: Do you think of increasing the salary of the employees?

  2. Computing Project

    Finally you can exit. Testing Test ID Test Data Test/Type Reason for test Expected Results Actual Results Data Entry 1. [StudentID] 11457848 Ensure data entry of 8 numbers is possible '11457848' stored AS EXPECTED 2. [StudentID] 114578484584 No more than 8 numbers allowed Error message too many digits AS EXPECTED (See Screen Dump 1)

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