Table Design Help.
- From: "Abu" <bidhu14@xxxxxxxxx>
- Date: 6 Apr 2007 01:06:23 -0700
Am designing an inventory database and I have difficulty designing the
tables and relationships. We have about 24 different types of
equipments, 6000 customers and 4 warehouses.
In total, we approximate about 6000 * 15 + ([Equipment at warehouses]
+ [equipment at vendor repair]). This of course a high estimate
because a customer can never have all the 24 equipment types installed
at their location.
For 6 of the equipment types, each equipment has a unique serial
number.
For an equipment to be installed, there must be a work order for the
install. The same applies for a removal.
If the equipment is not installed at a customer location, it is either
in one of the warehouses or at the vendor repair.
At the end of the month, we bill for the Installation of certain
equipments, removal of certain equipments. We also bill certain
equipments a monthly service fee calculated on a daily rate basis.
Others can only be billed the service fee if they have been installed
for a full month.
We also need to know what equipment is where as of now. We need a
summary count and an itemized listing. (In a week, we have about 10
to 20 customers requesting an install or a removal; our techs can
therefore easily provide feedback on equipment movement.)
Equipments can also be swapped out incase of a malfunction. We are
mainly interested in tracking movement for equipments with a serial
number (in total less than 1000 equipments have a serial number).
Certain equipments are also serviced after certain number of days.
Weekly we need to report on the maintenance status of each equipment
installed at a location. All equipment a location is serviced when
service is done.
We plan to use MS Access 2003 for this.
Thank you,
Abu.
.
- Follow-Ups:
- Re: Table Design Help.
- From: Allen Browne
- Re: Table Design Help.
- Prev by Date: Re: Help writing multi select list box selections to table
- Next by Date: Re: Table Design Help.
- Previous by thread: Re: Help writing multi select list box selections to table
- Next by thread: Re: Table Design Help.
- Index(es):
Relevant Pages
|
