Allow episodes to have multiple hosts
- Permit a many to many relationship between host and episode; an episode may have more than one host and a host may have more than one episode.
- Requires the addition of a linking table (e.g.
- Requires the double host entries in the hosts table to be identified and turned into single host entries linked to the same show.
- A test version of this was implemented in 2014 so some of the planning has been done
- Code which depends on the existing database structure will need modification. The use of database views will assist with this transition by hiding the full (possibly complex) queries