Design the Database for the Destinations, activities and Routes.

[riginoommen]

Tables

• Destinations
• Routes
• Activities

Relations

• Build Primary Keys and Foreign keys for this tables
• Activites and Destinations should be mapped.
• Routes and Destinations should be mapped

Destinations

Fields Required

• name
• description
• place image url
• tags
• activites should be listed
• Routes linked to it

Activities

• name
• type
• description
• cost
• timing
• coordinates (latitude and longitude)
• booking url
• review based on destination

Routes

• name
• description
• destinations associated with route
• Activities with destination.