Please note the last requirement, copy and paste from otherposts will be incorrect. The television show Saturday

Please note the last requirement, copy and paste from otherposts will be incorrect.

Transcribed Image Text:

The television show Saturday Night Live (SNL) needs help designing its database. The show stores information about its shows, cast members, guests and sketches. Draw an ER diagram describing the SNL database for the scenario described below. Assume that the only business rules that hold are those stated below, and that no additional business rules hold. • An SNL show is uniquely identified by a combination of season and sequence number. Each show airs live on a particular date (don't worry about whether the year of the date matches the show's season.) The TV network may decide to rerun a popular show, and a rerun may take place on one or several dates. All dates on which a show airs must be recorded in the database. A given show will have at most one re-run per date, but it is possible that two shows could be re-run on the same date (e.g., during a Best of SNL special). • Each show features a host, uniquely identified by the host's name. There is exactly one host per show. SNL only records hosts in their database who hosted at least one show. A host can perform in a sketch (but doesn't always). A sketch doesn't always have a host that performs in it. • A show features a series of sketches (always at least one sketch), described by their titles. A sketch is performed during exactly one show. The associated show entity and the sketch title uniquely identify the sketch. Sketches are written by one or several writers and performed by one or several cast members. Each writer has written zero or more sketches (zero because there could be a new writer). Each cast member has performed in zero or more sketches (zero because there could be a new cast member). • You may assume that writers and cast members are uniquely identified by their names. • Each cast member has at least one address and at least one phone number. In principle, two or more cast members could have the same phone number. For the purpose of this exercise, do not represent Rerun as an entity, but do represent Writer and Host as entities. The television show Saturday Night Live (SNL) needs help designing its database. The show stores information about its shows, cast members, guests and sketches. Draw an ER diagram describing the SNL database for the scenario described below. Assume that the only business rules that hold are those stated below, and that no additional business rules hold. • An SNL show is uniquely identified by a combination of season and sequence number. Each show airs live on a particular date (don't worry about whether the year of the date matches the show's season.) The TV network may decide to rerun a popular show, and a rerun may take place on one or several dates. All dates on which a show airs must be recorded in the database. A given show will have at most one re-run per date, but it is possible that two shows could be re-run on the same date (e.g., during a Best of SNL special). • Each show features a host, uniquely identified by the host's name. There is exactly one host per show. SNL only records hosts in their database who hosted at least one show. A host can perform in a sketch (but doesn't always). A sketch doesn't always have a host that performs in it. • A show features a series of sketches (always at least one sketch), described by their titles. A sketch is performed during exactly one show. The associated show entity and the sketch title uniquely identify the sketch. Sketches are written by one or several writers and performed by one or several cast members. Each writer has written zero or more sketches (zero because there could be a new writer). Each cast member has performed in zero or more sketches (zero because there could be a new cast member). • You may assume that writers and cast members are uniquely identified by their names. • Each cast member has at least one address and at least one phone number. In principle, two or more cast members could have the same phone number. For the purpose of this exercise, do not represent Rerun as an entity, but do represent Writer and Host as entities.

Answer rating: 100% (QA)

hostName Host hostName hostPhone hostAddress hostPhone Host hostAddress hosts ER Diagram seas... View the full answer