Design and implement a database of all 58 National Parks in the US and their basic info - Githubissues

BadwaterBay / intelli-trip-planner

RESTful API that intelligently recommends road trip routes, built with Python Flask and MongoDB.

BSD 3-Clause "New" or "Revised" License

4 stars 5 forks source link

Design and implement a database of all 58 National Parks in the US and their basic info #6

Open dongskyler opened 4 years ago

dongskyler commented 4 years ago

~~The database can be implemented with SQ: (PostgreSQL or MySQL) or noSQL (such as MongoDB), whichever makes the most sense.~~

The database will be implemented with MongoDB.

Because it is difficult to pre-define the schema, given that:

Attractions of different types may have very different attributes.
When we scale this database up, we don't know what attributes will be included.

Therefore, a noSQL database (such as MongoDB) is an ideal choice.

The database should include at least the following info:

Name
Coordinates
Type of attraction (e.g. National Park, National Monument, National Historical Park, etc)
Hours
Entrance fee, annual pass
Campsite info
In-park lodging
Major attractions inside each park/attraction
Popularity, measured by, e.g., number of visitors (of last available year)

dongskyler commented 4 years ago

This task is too big. It needs to be broken down to smaller tasks.