Creating a Air Freight Rate Table Database

V

Vidhushi

Hi All,

I have been tasked to create a database for Air Freights.
Here is an example.

Tables I currently have:
Unit of Measure
Port of Export
Foreign Ports
Air Carriers
Tariff Table ( i.e. This is Matrix used my Air Carriers to
determine rates (1-10 Pounds) (Baltimore to Saudi Arabia)
(100 Dollars)

How should I design the structure of the database so that
we could:
SELECT PORT OF EXPORT, SELECT DESTINATION PORT, CHOOSE AIR
CARRIERS WITH THE ABOVE MATRIX AND DETERMINE THE CHEAPER
RATE) FROM EACH AIR CARRIER.

PLEASE ADVICE
THANKS IN ADVANCE
 
Top