Need help with database design

[wchelly]

I need to build a database which assigns trailers, for a specific date range, for shipments so that trailer usage is as efficient as possible.

Essentially I need to have the following inputs:

Trailer#
Shipment#
Related Shipment# (for return trips so that the same trailer will drop off a load and pick up a load from the same location)
Shipment Month (for flexible shipments)
Shipment Dates (if specific dates are needed)
Delta (This is the number of days needed to make the shipment)

The outputs needed are:
Shipment#
Shipment Dates
Trailer #

Essentially, I need to know if what I am doing makes sense, or if it is even possible to do this.

 

[wchelly]

So I think I need:

Table 1: Shipments with the following fields
Shipment#
Shipment Month (Required)
Shipment Dates (Optional)

Table 2: Trailers
Trailer#

Table 3: TrailerSchedule
Shipment#
Trailer
Shipment Dates

Does this seem Right?

 

[wchelly]

EDIT: I forgot one field below and added it here.
So I think I need:

Table 1: Shipments with the following fields
Shipment#
Shipment Month (Required)
Shipment Dates (Optional)
EDIT:elta: # of days Trailer will be in use for this shipment.

Table 2: Trailers
Trailer#

Table 3: TrailerSchedule
Shipment#
Trailer
Shipment Dates

Does this seem Right?