Information about films contains information about movies, stars and studios. Movies

have a title, year of production, length and the film type. Stars have a name and address.

Studios have a owner and a banner. Movies are shot in studios which own them. A

movie is shot in only one studio. Stars are connected to one or more studios but can act in

any film which may or may not be owned by the studio. Arrive at an E-R diagram.

Clearly indicate attributes, keys, the cardinality ratios and participation constraints.