Hi

I was stuck on the designing a database.

It goes something like this -


Many buses can access many bus stops.

e.g. there are 5 bus -stops , and bus numbers are 22, 11, 13, 77.

Each of these buses would/could access any of the 5 bus stops.

In order to resolve this many -many relationship, I made a 3rd entity
bus_journey with two primary keys busstopID and BusID initially
considering, that each bus journey would be uniquely associated with a
bus with only a single bus stop.

However, this fails, since in a bus journey, a bus can access multiple
bus stations.

e.g. in a bus journey, Bus no 11 can travel around and access bus stations 1,2, and 3.

I am out of ideas on the design of this relation between them..

How could you relate these two entities in an ERD ?

Any suggestions would be very helpful


Here's the database design

[img=http://img266.imageshack.us/img266/2008/untitledpr5.th.jpg]

Best regards

just like you did already in the database diagram

oh, wait -- is the reason you're asking about ERDs because you need to hand in an ERD for this assignment?

^No actually its because I need to use this database to feed in real data sourced from the local travel company and display it on my webpage..

I need to use this db in MySQL.

Go back to basics for this one...
Try expanding on this
One line statements for the relationships between each of your objects and post them all back here - this should help clarify the problem and lead you to a solution!

..or even a route comprises many stops
..many routes may use one stop
..many buses may service one route