Which movies appear at which festivals? Fix the following multivalued attribute problem with a synthetic key bridge
Question:
Which movies appear at which festivals? Fix the following multivalued attribute problem with a synthetic key bridge entity relationship. Note that there may be a movie (film) that has not appeared in any festival yet. A festival, however, can be entered only when there is at least one movie associated with it. Show your answer in an ERD with proper crowsfoot symbols with all mandatory/optional and degree of participation notations. Mark all PKs and FKs.
FILM ID | FILM TITLE | FESTIVAL NAME |
001 | Acabo de Tener un Sueño | Philadelphia Q Fest; Cedar Rapids Independent Film Festival |
002 | Legacy | American Black Film Festival; Sundance Film Festival; Cedar Rapids Independent Film Festival |
003 | June Falling Down | Wisconsin Film Festival; Cedar Rapids Independent Film Festival; Central Wisconsin Film Festival |
Understanding Financial Accounting
ISBN: 978-1118849385
1st Canadian Edition
Authors: Christopher Burnley, Robert Hoskin, Maureen Fizzell, Donald