Hello.

I'm programming a website in which we have sport clubs listed in a DB, structure is as follows:

club (id_club, club_name, club_city)
court (id_court, court_name, club_id_club (FK), court_type)
court_has_sport (court_id_court , sport_id_sport)
sport (id_sport, sport_name)

So as you can imagine, a court may allow more than one sport to be played in it (for instance, soccer and...