museums data structure

The museums database stores data about museums and the cities that they reside in. The recipes using this data source are based on you being part of a tourism company. The following diagram shows the relationship between museums and cities, where a single city can have many museums:

museums

The museums table contains the following details for each museum:

Field	Description	Example
id_museum	Identification for the museum	3
name	Museum's name	Museo de Arte Latinoamericano
id_city	Identification for the city; it references to the cities' data	1

cities

The cities table contains the following details for each city:

Field	Description	Example
id_city	Identification for the museum	1
city	City's name	Buenos Aires
country	City's country	Argentina