Draw the entities and relationships suggested by each word problem. Include the proper foreign key(s). Remember to make a copy for yourself.

Concerts are the coming together of one or more bands at one or more locations. So a location will host one or bands and bands will play at one or more locations. When a band plays again at the same location we will just overwrite the prior data. For every concert we want to capture the ticket price and local quiet hours (if any). Bands have a unique name, a genre, and a cost. Locations have a city, state, tax rate and a venue