This discussion is now closed.

Check out other Related discussions

Tod's Tyres

15

I have basically finished my database. Is anyone else doing the same thing? We could exchange our databases to see what we need to improve on :biggrin:

Reply 1

username9816

14

TheWolf

I have basically finished my database. Is anyone else doing the same thing? We could exchange our databases to see what we need to improve on :biggrin:

I'm doing the same thing, although I haven't finished my database quite yet.

Reply 2

TheWolf

OP

15

bono

I'm doing the same thing, although I haven't finished my database quite yet.

what stage are you at mate

Reply 3

20pence

I am doing the same thing. I don't know about cars and tyres. would anyone tell me whether or not that One car can only be fitted with one type of tyre. if so there shoud be a one to many relationship between tblCars and tblTyres, or otherwise, pls help me.

Reply 4

Smoky

20pence

I am doing the same thing. I don't know about cars and tyres. would anyone tell me whether or not that One car can only be fitted with one type of tyre. if so there shoud be a one to many relationship between tblCars and tblTyres, or otherwise, pls help me.

Your right one car can have only one fitting of one type of tyre in this case study.

Need any further help send a PM

Reply 5

20pence

Smoky

Your right one car can have only one fitting of one type of tyre in this case study.

Need any further help send a PM

My ER - Model
------------------
(type of )Tyres | >-------- | Supplier |
------------------
.|
.|
/|\
-----------
|*** Cars |---------< | Fittings |
-----------
\|/
.|
.|
----------------
Customers
----------------

Assume that one car can only be fitted with one type of tyre.

Reply 6

Pooh

Hi everyone,

I am using MS-Access 2000, and am OK upto Tables, Queries, Form, Report. BUT struggle with macro, modules a lot. Can someone recommends me a good book to read?

Thanks in advance.

Reply 7

madman

I'm doin this at college and i could really use some help i am having problems gettin marcos to run my queries :frown:

Reply 8

borninblood

Haha, im so lucky i got a decent mark last year in module three.

Reply 9

Otaku Punk

Hey, ive just started this. if somebodys got a workin one it'd be helpful to see it but ive only started so ive got nothing in return..

Reply 10

erk

14

I started this today, really struggling to be honest, never used Access in my life :redface:

!!!!!

Teacher says the ideal system will have 5 tables.. PM's would be helpful :frown:

Reply 11

madman

Could some1 pm me on wif some good sites to learn bout reports on Access 2000 coz i am straggling wif them? Ne1 help me? PM me. :confused:

Reply 12

username9816

14

erk

I started this today, really struggling to be honest, never used Access in my life :redface:

!!!!!

Teacher says the ideal system will have 5 tables.. PM's would be helpful :frown:

My teacher says 4 tables is adequate, it is how you use these tables in creating forms/reports that matter.

My teacher advised 4, and he checked mine and said they were fine.

Reply 13

map200uk

hey,

can someone give me the specification of CPT3 (tods tyres please)
i lost my copy, and cantg find the pdf of it anywhere

thanks

Mark

Reply 14

Revelation

1

I am doing it. very nearly finished database just some visual things and one last query (to remove stock). I used 4 tables - search the forums for "cpt3" for more information. the spec can is available at aqa.org

Reply 15

username9816

14

map200uk

hey,

can someone give me the specification of CPT3 (tods tyres please)
i lost my copy, and cantg find the pdf of it anywhere

thanks

Mark

AS Practical Exercise for Summer 2004 Examination
Tod's Tyres.

Background

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

You have been asked to create a computer application, either programmed or using a database, to replace the current manual record-keeping system. Initially, at least, there will be only one standalone workstation with a printer attached. This is to be kept locked in the office.

For the purposes of this exercise, you may assume that all the cars have the post-2001 format car registration number. Eg AB 03 XYZ

Specification

Specification

--------------------------------------------------------------------------------

Section 1
When a car is brought to Tod for the first time, the following information is recorded on a card: car registration number, company name, type of tyre fitted.

Each time that car has new tyres the date, car mileage, and number of new tyres fitted is recorded on the card.

There is also space to make a comment; for example, the mechanic fitting the tyres may have noted some other problem with the car, which they would bring to the notice of the customer so that it could be sorted out. When a card becomes full, a new card is stapled to the original one.

These cards are filed in car registration number order.

--------------------------------------------------------------------------------

Section 2.
The next time the company books in a recorded car for new tyres, Tod checks the card file to see what type of tyre that car has fitted.

He then ensures that he has the required tyres in stock. He prides himself that he never lets a regular customer down.

--------------------------------------------------------------------------------

Section 3
Tod gets his tyres from one supplier only. This supplier sends him an up-to-date supplier price list once a month. Todd then adds his fitting costs to produce a customer price list. The current price list is as follows.

Type Manufacturer’s
Code Customers’ Price
(Ex VAT)
155/80S13 P1000 £36.00
165/80S13 P3000 £39.00
155/80S14 P5000 £58.50
165/80S14 P7000 £64.00

--------------------------------------------------------------------------------

Section 4.
Some companies are allowed a 5% discount before VAT is added. At present, Tod does not keep a record of who these are because he can remember them. However, a computerised system would have to keep a record.

--------------------------------------------------------------------------------

Section 5.
VAT is payable at the current rate.

--------------------------------------------------------------------------------

Section 6.
Tod keeps company details, (Company name, contact name, address, post code and telephone number), in another card file.

--------------------------------------------------------------------------------

Section 7.
Tod supplies an invoice to his customers. This invoice is supplied in duplicate, one copy for the customer and one for Tod’s own records for his accountant. It has an invoice number in the top right hand corner.

It details the date, the company name, post code and telephone number, the car registration number, the number of tyres supplied with their price, the discount where applicable and the VAT.

--------------------------------------------------------------------------------

Section 8.
Once a month, one of the clerks goes through the cards and pulls out cards for cars which last had new tyres over a year ago and so might be ready for new tyres. Tod then sends the customer a standard letter reminding them that the tyres are ready for replacement, and quoting them a price.

--------------------------------------------------------------------------------

Section 9.
Tod also intends to use a popular word processing package. He wants to use the Internet and e-mail in the near future, and possibly have his own Web site. He feels that a move into electronic communication would be beneficial to his business.

You should bear these plans in mind when designing your system, although you are not expected to incorporate these applications for this exercise.

--------------------------------------------------------------------------------

Testing
Car registration numbers should be validated and the number of tyres sold for one vehicle at any one time should not exceed 5. Testing should ensure that the calculations produce the correct result.