Version 1

  1. Can a quote be said by more than one character?
    This would presumably require different instances of SaidBy for the same pair of Quote and Movie. The diagram does not allow this - the 1 on Character means that a given Quote-Movie combination can only be paired with one Character.

  2. Can a quote be said in more than one movie?
    Yes. A given pairing of quote and character can only participate in SaidBy with one movie, but the same quote can be more than one movie as long as it is said by different characters.

  3. Can a quote be said by more than one actor?
    Yes, in certain circumstances. First, a quote can be said by more than one character if it occurs in different movies (the "1" on Character in SaidBy says only that a particular quote and movie combination can only be associated with one character), and different characters can certainly be played by different actors. Second, while a quote can only be said by one character in a particular movie, that character can be played by different actors in different movies.

  4. Can a character appear in more than one movie?
    Yes. The 'M' on Movie's connection to PlayedBy allows a particular pairing of character and actor to appear in more than one movie, and a character can also be played by different actors in different movies (just not the same movie).

  5. Can a character be played by different actors in different movies?
    Yes. The "1" on Actor in PlayedBy means that a character can't be played by different actors in the same movie (because a particular character and movie pair can only be associated with one actor).

  6. Can a quote be said by a character that doesn't appear in the movie that the quote is said in? In principle, no - the character says the quote and the quote is in a movie, thus the character says the quote in a movie, and thus the character is in the movie. In the diagram, however, the only linkage between an instance of SaidBy and an instance of PlayedBy is through character - a character who says a quote is a Character entity and must then participate in at least one instance of PlayedBy (though not necessarily the one involving the movie the quote is in). This isn't necessarily a flaw - remember that the absence of an instance of PlayedBy involving a particular character and movie doesn't mean that there isn't one, as it could just be that it hasn't been recorded.

  7. Can a character say a quote in a movie that the actor playing that character wasn't in? The total participation of Character in PlayedBy means that you have to have an actor playing the character that said the quote in some movie, but there may not be an instance of PlayedBy for the actor playing the character that said the quote in the same movie the quote was in. Again, keep in mind that the lack of an instance of a relationship doesn't mean that the relationship doesn't exist - it could just be that it hasn't been recorded in the data set.

Version 2

  1. Can a quote be said by more than one character?

  2. Can a quote be said in more than one movie?

  3. Can a quote be said by more than one actor?

  4. Can a character appear in more than one movie?

  5. Can a character be played by different actors in different movies?

  6. Can a quote be said by a character that doesn't appear in the movie that the quote is said in?

  7. Can a character say a quote in a movie that the actor playing that character wasn't in?

Version 3

  1. Can a quote be said by more than one character?

  2. Can a quote be said in more than one movie?

  3. Can a quote be said by more than one actor?

  4. Can a character appear in more than one movie?

  5. Can a character be played by different actors in different movies?

  6. Can a quote be said by a character that doesn't appear in the movie that the quote is said in?

  7. Can a character say a quote in a movie that the actor playing that character wasn't in?

Version 4

  1. Can a quote be said by more than one character?

  2. Can a quote be said in more than one movie?

  3. Can a quote be said by more than one actor?

  4. Can a character appear in more than one movie?

  5. Can a character be played by different actors in different movies?

  6. Can a quote be said by a character that doesn't appear in the movie that the quote is said in?

  7. Can a character say a quote in a movie that the actor playing that character wasn't in?