Create an ER Schema for the following scenario. The schema must include: The ER diagram itself, complete with attributes and cardinality constraints. An entity attribute list briefly describing, when necessary, the attributes for each entity. Try to have at least 5 attributes per entity, although this will not be reasonable for some entities. A list of relationship attributes and their descriptions. (NOTE: NOT all relationships will have attributes.) A list of assumptions you have made in order to make the diagram. A community theater needs a system to keep track of its people and productions. Draw an ER model that most accurately and concisely represents the following scenario 1. The theater employs a small number of people on a part time basis to take care of some professional functions. Most of the people associated with the theater are volunteers. 2. The theater is organized into several committees which deal with everything from overseeing a particular production to planning the long term administration of the theater. The theater wishes to keep track of who has served on different committees in the past, as well as the current composition of the committees. 3. The committees of the theater form a hierarchy. 4. The theater gives productions. The productions have names and performance dates. Each performance has a certain number of tickets allocated for it and several different pricing options. The number of tickets actually sold should also be tracked for each performance of the production. 5. Some productions are based on scripts rented from publishing companies. Other pro- ductions are developed by the theater itself. The rental cost of each production should be recorded as appropriate. 6. Each production has people who participate in the production in various roles. Each production has at least one director. Many other people perform onstage. Some people work behind the scenes. People audition for various roles in a production. These should be tracked until after a production is cast. 7. The script roles performed by an actor in a particular production should be recorded. The off-stage roles (not listed in the scripts) filled by a person should also be recorded. Different actors may perform the same role during different performances of the produc- tion. Each participant in a production (but especially the on-stage performers) sh have a brief biographical statement to be included in the playbill for the production. 8. Depending on the circumstances (if someone is sick), different people may perform a given role on differing dates during the production. 9. Some popular productions are performed on a recurring basis. (For example, "A Christ- mas Carol" is performed every year.)