Below are three tables which model the (hypothetical) ticket sales of a (hypothetical) Broadway ticket agent. Your answers to the questions should be perfectly general: even if the rows of the tables were to change, as long as the new rows conform to the schema and satisfy the listed constraints, your queries should remain correct. Id Holder Event Seat Id Name 2 1 -0 v Ticket Holders = 1001 1002 Tickets = 1003 1004 1005 1006 3 3 4 5 1 2 7 8 1 19 20 12 2 3 4 5 Pete Alice Juan Dana Beth 1 3 Id Name Date Price Assume the following constraints hold: 1 Event = Dracula Metro Bobbi Boland Lestat Pirate Queen 4 2004-08-01 1992-04-02 2003-11-01 2006-03-03 2007-04-12 100 20 1 50 60 TIEvent (Tickets) C Tid (Event) TT Holder (Tickets) C Tid (Ticket Holders) 5 3. (25 points) Write a SQL query which gives the name and seat of all of the ticket holders who have been to an event which took place before 2006. 4. (25 points) Write a relational algebra query which gives the same result as the query you gave for the previous