Question:

Consider the following scenario.

  • There are televisions series, which have names, networks and production companies, and are identified by names
  • A television series has one or more episodes, identified by episode number. Episodes also have a title and a length.
  • There are also movies. A movie is identified by its title. It also has a studio.
  • An actor is identified by name and birth date, and also has a nationality.
  • A writer is also identified by name and birth date, and also has a literary agency that represents him or her.
  • An actor can appear as a “regular” on a television series, a guest star on an episode, and a performer in a movie.
  • An episode has a writer, and a movie has a writer.

Draw an ER diagram that represents this scenario.

ImageImageImageImageImage

Advertisements