I'm Gergo Nagy, and I'm learning databases. My project is a bus schedule program, in android, but I stucked with the database part. My program will include 2 main parts: -If I click on a number of a bus, it shows the whole schedule, and a number, that shows when will the next bus start from the departure point. -if I click on the address of the bus stop, it shows which buses crosses this stop. But it only shows that buses, which arrives in an hour.
My problem is the many-to-many database, because one bus has a lot of stops, but a stop "has" a lot of buses. I'll attach a picture, from the schedule, I hope with this it will be easier to understand my question, 'cause my english is really bad, and sorry for that.
I know it's a mess, but with this level of english knowledge, it's my best. I hope you can help me. Thank you in advance