I want to create a database schema in which there is an table name 'Route' which contains different route_names and for each route_name there is a source_station,destination_station and the different stations which comes midway between source and destination.The stations will be joined from the station table created separately.
The problem is that it may be possible that one route have 3 stations while other have 12 so if i make 12 columns in route table then there may be null values for various route.
Can using of NoSql solve my problem and if yes then pls tell me how??
or can this be done itself in MySQL ??
One more thing order of the stations is also important like station 1 after that station 2..and so on... for each route
I want to store the data on the server and fetch the data using the webservices to my android app..
Kindly help
Aucun commentaire:
Enregistrer un commentaire