(Solved): Map each of the following class diagrams to a relational schema. Draw the database tables, clearl ...

Map each of the following class diagrams to a relational schema. Draw the database tables, clearly identify the primary keys, foreign keys, and composite keys, if any. A) [3 points] A booking has many tickets. Given a booking number, we can retrieve all the tickets associated with that booking. Booking - bookingNo: int movieID: int - bookingDate:Date - 1 Movie - title:String - duration - B) [7 points] A movie can be shown/displayed in many theaters and a theater can be reserved to show many movies. However, no two movies are displayed in the same theater at the same date/time. We want to be able to retrieve all show information of a specific movie (date and time and the theater). * Ticket Attendeename: String type: int price: double Theater capacity:int