Information Technology Reference
In-Depth Information
Fig. 4. The part of ERD (simplified Martin's notation) diagram for questions parameters
tables.
Table name
description
Column
name
Symbol
Key
Column description
j
kd_idmia
pk
ID delivery point
tra_miast
delivery points
naz
id_nazwa
The name of the point
z
id_zapot
The demand for pallets
i
kd_idtra
pk
ID route
tra_trasy Routes
naz
id_nazwa
The name of the route
tra_dosta
delivery points along
the route
j
kd_idmia
pk(fk)
ID delivery point
i
kd_idtra
pk(fk)
ID route
l
kd_idsam
pk
ID type of truck
The capacity of truck type (in
pallets)
tra_samoch
truck types
k
id_poj_k
u
id_kur_u
Feasible number of curses
w
id_cza_w
Feasible duration of the courses
tra_sa_tr
allocation of trucks to
the routes
i
kd_idtra
pk(fk)
ID route
l
kd_idsam
pk(fk)
ID type of truck
c
id_kos_c
The cost of route by the truck type
Search WWH ::




Custom Search