[AccessD] Vehicle maintenance database (cross posted)

David, I am also needing to create a maintenance "module" to add to one of
my products.

Maybe we could work together on this - or at least share ideas.

I have to include heavy equipment (backhoes, graders, loaders, etc.) as well
so I'll also have to track the services by hours rather than miles.

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
dmcafee at pacbell.net
Sent: Friday, April 08, 2005 1:45 PM
To: ACCESS-L at PEACH.EASE.LSOFT.COM
Cc: AccessD at databaseadvisors.com
Subject: [AccessD] Vehicle maintenance database (cross posted)


I was given a task to quickly come up with a vehicle maintenance schedule
database. before I get further, I was wondering if anyone already has
something in place.

If not, this is what I have so far:

tblModels:
	ModelID PK
	Model (Camaro, Corvette)

tblAutoMfg
	AutoMfgID PK
	AutoMfg (Chevrolet, Honda)

tblMfgModels
	MfgModelID PK
	AutoMfgID FK
	ModelID FK

tblYears
	YearID PK
	ModelYear (2005, 2004, 2003...)

tblAutoYears
	AutoYearID PK
	YearID FK
	MfgModelID FK

I'm looking at schedules that can be either light duty or heavy duty
The maintenance schedules can also be either date based or mileage (or
kilometer based).

Something like Oil Changes, every 3000 miles or 3 months. But some items
have only date based services and others have only mileage based service
intervals.

I was thinking something like
tblMaintenanceTasks
MaintTaskID
MaintTask (Oil Change, Rotate Tires...)

tblIntervals
IntervalID
Interval (3, 3000, 7500...)
IntervalTypeID

tblIntervalType
IntervalType (Miles, Months)

But I was also thinking of making tblIntervals, a little less normalized,
something like:
tblIntervals
IntervalID
IntervalMiles
IntervalKilos
IntervalMonths

I have also not been told if we will be drilling down into sub model type
(i.e. Mustang GT, Mustang LX), so for now, I am assuming that I will be
relating these suggested service maintenance intervals to tblAutoYears.

Any suggestions?

TIA,
David McAfee

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com