5.1 Figure 5-59 shows a listing of movie times at theaters in Seattle. Using the data in this figure as an example, do the following:Using MySQL Workbench, construct an ER diagram for problem 5.63. Each part of the question asks you to add functionality to the model. When you have thefinal version as specified in part E, submit the .mwb file to the dropbox for week 5. (30 points)A Create a model to represent this report using the entities MOVIE, THEATER, and SHOW_TIME. Assume that theaters may show multiple movies. Although this report isfor a particular day, your data model should allow for movie times on different days as well. Specify the identifier of the entities and their attributes. Name therelationships and the type and cardinality of all relationships. Explain which cardinalities you can logically deduce and which need to be checked out with users.Assume that distance is an attribute of THEATER.B This report was prepared for a user who is located near downtown Seattle. Suppose that it is necessary to produce this same report for these theaters, but for auser located in a Seattle suburb such as Bellevue, Renton, Redmond, or Tacoma. In this case, distance cannot be an attribute of THEATER. Change your answer in Afor this situation. Specify the entity identifiers and attributes. Name the relationships and identify the type and cardinality of all relationships.C Suppose that you want to make this data model national. Change your answer to B so that it can be used for other metropolitan areas. Change your answer in A forthis situation. Specify the entity identifiers and attributes. Name the relationships and identify the type and cardinality of all relationships.D. Modify your answer to C to include the leading cast members. Assume that the role of a cast member is not to be modeled. Specify the identifier of new entitiesand their attributes. Name the relationships and identify the type and cardinality of all relationships.E. Modify your answer to C to include the leading cast members. Assume that the role of a cast member is specified. Specify the identifier of new entities andtheir attributes. Name the relationships and identify the type and cardinality of all relationships. NEED THE .WMB FILE THAT SHOWS E ONLY!!!