HELP, HELP!!! CONVERT A DATA STRUCTURE IN C# TO A ACCESS DATABASE

Hello:



Recently I’m migrating from data structures to databases. I’ve converted a
Customers, Products and PendingOrders collections into a Microsoft Access
2003 data base. But I must convert many other data structures.

Now, the problem is a graph. In this project, there are cities and
transportation means. Traveling to one city to another we must use a car, a
bus, a train, an airplane, or a boat but we can’t travel between two if the
transportation mean is not available, this is there are cities unreachable
using a car (like cities located in islands) , a airplane (the destination
city does not have airplane) and so on.

I’ve used the graph data structure as solution. The nodes are the cities and
the arcs are a relation between the city and the transportation mean. In
math, this is

Destination (city, transportation mean) = {city1, city2}

I’ve implemented this relation between two sets.

C: the set of cities

T: the set of transportation means

D: the set of destination cities given a city and transportation mean. It is
a subset of C.

For this purpose, the arc, called destination, is of the form

(startCity, transportationMean, destinationCities)

For implementation I’ve used list structures:

City1-------|---------àMean1---------------- à{city1, city2}

|-------àMean2---------------- à{city1, city3, city5}

.

.

.

City2-------|---------àMean1---------------- à{city3, city4}

|-------àMean3---------------- à{city1, city4, city7}

.

.

.

Where, basically, there is a list of cities, each city points to its proper
list of transportation means, and transportation mean point to its proper
list of destination cities.

| |--------->| |-------->| | | | |

|----->| |-------->| | | | |

|----->| |-------->| | | | |

|----->| |-------->| | | | |



| |--------->| |-------->| | | | |

|----->| |-------->| | | | |

|----->| |-------->| | | | |

|----->| |-------->| | | | |

|----->| |-------->| | | | |

I’ve red databases examples, but I don’t found a similar model and I don’t
know how to design this recursive relation in Microsoft Access.

Help for this problem!

e-mail me: monin712@xxxxxxxxxxx


.

Relevant Pages

  • =?iso-8859-1?q?Lessons_from__Bogot=E1?=
    ... Now, on the Building a New City tour, Mr. ... Africa's leading cities: Dakar, Senegal; ... Traffic congestion, inadequate public ... transportation, poverty and poor access to jobs and services are ...
    (soc.culture.indian)
  • Re: HELP, HELP!!! CONVERT A DATA STRUCTURE IN C# TO A ACCESS DATABASE
    ... an idea like 'the set of cities' is modelled ... as a table with one record per city. ... FROM tblCitiesModesDestinations ... transportation mean is not available, this is there are cities unreachable ...
    (microsoft.public.access.gettingstarted)
  • HELP, HELP!!! CONVERT A DATA STRUCTURE IN C# TO A ACCESS DATABASE
    ... But I must convert many other data structures. ... transportation mean is not available, this is there are cities unreachable ... city does not have airplane) and so on. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is it true that the Feds mandate "free" rest areas?
    ... transportation. ... Cities like NY wanted express hwys, ... Shakespeare in the Park received much negative publicity, ...
    (misc.transport.road)
  • Re: Should I move to Amsterdam?
    ... > Personal transportation sucks in the Netherlands, ... > Randstad and you have to ... the big cities are notorious for losing your bike fast. ... so we missed our train to Amsterdam by 15 minutes. ...
    (comp.lang.python)