Help With Creating Tables

Lancer1

New member
Local time
Today, 10:43
Joined
Nov 18, 2008
Messages
3
I need to create tables in access given the following narrative:


System Specification
In an effort to be environmentally conscious, a city council have decided to set up a
bicycle‐share scheme to enable short journeys within the city. Bicycles are kept at a
number of parking stations throughout the city, and members of the public can borrow a
bicycle at any time and return it to any parking station after use.
There is an annual fee to join the scheme, and the first 30 minutes of borrowing is free.
After this free period, a small charge (50c) is applied for each 30 minutes, and if the bicycle
is on loan for more than two hours the fee is increased to 10 euro per hour. If the bicycle is
kept for more than 5 hours, a fee of 100 euro is charged. Members register their credit card
details when they join, and the fees are automatically deducted for each borrowing.
The council keeps track of each bicycle and how many times it has been borrowed. Each
bicycle is also given a small maintenance check every week to ensure it is road worthy.
The council have a maintenance team who travel through the city and remove bicycles
which are faulty or in need of maintenance.
The council also keep track of how many bicycles are at each parking station, and publish
this on the internet in real time so that the borrowers can check which parking stations
have a bicycle available.
To ensure the smooth running of the scheme, and to give a good service, the council
produce regular statistics on the use of the scheme. This means that they can increase the
number of parking places in locations where there is a higher demand, or move bicycles
around the city if necessary.


I've decide on 5 tables with fields like:


BICYCLES
------------
Bike ID
Station ID
Cust ID
Maint ID
Times Rented

PARKING STATIONS
------------------------
Station ID
Location
Bike Qty

CUSTOMERS
-----------------
Cust ID
FName
LName
Address1
Address2
County
Credit Card
Invoice No

RENTALS
------------
Invoice No
Annual Fee
Time Borrowed
Charge

MAINTENANCE
-------------------
Maint ID
Bike ID
Condition

I'm just wondering if anyone can take a look and see if i'm on the right track with my tables?
There's a lot more to do then that, but I'm finding it hard to get it started.

Thanks
 
Picture attached..
 

Attachments

  • untitled.GIF
    untitled.GIF
    30.4 KB · Views: 161

Users who are viewing this thread

Back
Top Bottom