Create data tables within MySQL based on this diagram. Use all the entities and relationships described in that question. Choose Primary keys and foreign keys minutely! Also, after creating the tables, insert data records into these database tables.

What data to use to populate the tables?

Continents --> use all from the list of continents.

the 'neighborhood' information of continents also should be replicated from the world map.

Islands --> use at least 5 from each continent.

Oceans --> use the list provided.

Straits --> use as per your relationship requirements (your design choice).

List of continents and their sizes can be found here: https://en.wikipedia.org/wiki/Continent (Links to an external site.)Links to an external site.

Neighborhood relation among the continents can be also be found here.

List of islands along with their continents and bodies of water can be found here: https://en.wikipedia.org/wiki/Lists_of_islands (Links to an external site.)Links to an external site..

Consider only these oceans: (sizes can be found here: https://en.wikipedia.org/wiki/List_of_seas (Links to an external site.)Links to an external site. )

Atlantic Ocean

Arctic Ocean

Southern Ocean

Indian Ocean

Pacific Ocean

List of straits: https://en.wikipedia.org/wiki/List_of_straits (Links to an external site.)Links to an external site.

Island/continent information of the straits can also be found here.

name area name area bodies of water land mass connected isa isa many to many continent island ocean strait separated many to 1 many to 1 located name area name area bodies of water land mass connected isa isa many to many continent island ocean strait separated many to 1 many to 1 located