Please do both part A and B.

Draw one ER model diagram (with multiplicities, other details can be skipped) showing three entities, Ticket, Subscriber and VisitingTeam. A ticket is only for one visiting team, while multiple tickets for a visiting team. A ticket is for one subscriber, a subscriber have 5 to 8 tickets of various game dates. In the above problem, the Ticket table has data for game_date, section, and other fields. The primary key is the composite key of game_date and section. The Subscriber table has the primary key ID, and other fields like name and year_started. The VisitingTeam table has the primary key iD, and other fields like team_name, institution, etc. Give the text-form schema for the three tables, showing all known attributes based on the above description. You must indicating primary and foreign keys, if there is any