Cosmos: A Personal Voyage was a pioneering TV show created and presented by Carl Sagan. Now you are required to design an EER diagram that will be able to capture some of the details / information of the show.

The show consists of episodes. Each episode has a number, a title, a brief description, a length (in minutes) and an original air date. The episodes have several writers and producers (people) who have name, surname and some more biographical information. An episode may be written by many writers and produced by many producers; and similarly a writer or producer may take part in many episodes.

The episodes discuss several scientific events/stories (stories) by interrelating them. Each such story has a title (e.g. the story of the Heike crab), details and a number of science fields that it is related to (e.g. Biology, Evolution, Artificial selection). Stories are interrelated to each other as presented and described in the show; a story may be interrelated to a number of stories from different episodes. The stories also may include historical figures (e.g. Eratosthenes) and a historical figure may appear in more than one stories.

The episodes are presented by Carl Sagan but at each episode several other scientists or domain experts appear as guest stars. These also have a name, surname and some more biographical information. Moreover, a guest star can also be a writer or producer of the show. These guest stars contribute to the presentation of the stories given in the previous paragraph. A guest star may contribute to a number of stories and a story may have a number of contributors.

Each episode has a soundtrack that consists of a number of musical pieces. Each one of them has a title, a composer and a genre. A musical piece may appear in a number of episode soundtracks.The pieces are used as a background music during the presentation of different stories and a piece may be the background music of many stories. Each composer has a name, surname and some biographical information. It is possible for a composer to be the writer or the producer of an episode.

Each episode has a number of filming locations. The location consists of a specific place name with several fields (e.g. Navajo Reservation, New Mexico, USA). An episode may be filmed in many locations, a location may be used in many episodes. The guest stars join Carl Sagan in these locations.

Carl Sagan during his narrations in the show uses sentences that can be characterized as quotes. A quote appears only in one episode but an episode may have a number of quotes. The quotes refer to a number of subjects or topics.

The show has been broadcast in many countries. At each country the show has a local name (e.g. Kozmos: Kiisel Yolculuk) and may have been broadcast by a number of channels (e.g. TRT1, NTV). At each channel each episode has a specific initial broadcast date. The episodes have a local name in the countries that they are broadcast. In some channels the show is broadcast with subtitles whereas in some channels with dubbing. If it is dubbed, then a number of voice actors may have taken part in the dubbing. The voice actors have a name, surname and some more biographical information.

Develop the EER diagram of the Cosmos: A Personal Voyage TV Show based on the aforementioned information. Make any assumptions if required. You are free to add any new attributes, entities, relationships and other required new items to make your EER diagram more complete/consistent or your database design more interesting / efficient. You can add more information if you deem necessary by browsing the Internet or collecting further information about the TV show.

You are required to draw your EER diagram by using an appropriate software. That can be MS Visio or SmartDraw or any other software you think serves your purpose (search the Internet for EER / ER drawing tools, you will find a plethora of them).