Hello All,
I am working on a database, and have doubts in two fields (startpoint, and endpoint locations)therefor want your comments and suggestions, my database tables look like the following:

[Projects table:]
project_id
project_name
startpoint_location_id
startpoint_latitude
startpoint_longitue
endpoint_location_id
endpoint_latitude
endpoint_longitude

[Location table:]
location_id
location_name


the startpoint_location_id and endpoint_location_id is linked to the location table,it means that Location table has one-to-many relationship with projects table.

Now my question is whether this is a good database design or should I handle it differently, please update me as soon as possible.

Thank you