(TCO 3) You are designing a database for a theatrical production company. The general manager has given you the following description of the business: We put on productions at several theaters around the country. Each production consists of a play running at a theater for a certain period of time. We record the title, author, and copyright date of each play. We also record the name, city, and seating capacity of each theater. For a production, we want to know the play, the theater, and the starting and ending dates. Each play can be used for several productions, and each theater can host several productions on different dates. (a) What are entities involved in this business problem, and what are the attributes of each entity? (b) What are the relationships among the entities, and what is the cardinality of each relationship? (c) What would you choose as the primary and foreign keys for each entity? (Include any associative entities needed.)