Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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:
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 1001 1002 Tickets = 1003 Ticket Holders = 3 3 4 5 1 2 2 2 2 1 1 3 7 8 1 19 20 12 1 2 3 4 5 Pete Alice Juan Dana Beth 1004 1005 1006 Id Name Date Price Assume the following constraints hold: Event = 1 2 4 3 5 Dracula Metro Bobbi Boland Lestat Pirate Queen 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) Tid (Ticket Holders) 1. (25 points) Write a SQL query which gives the name of the ticket holder, the name of the event, and the price paid for the ticket, for all tickets with a price greater than $50. 2. (25 points) Write a relational algebra query which gives the same result as the query you gave for the previous
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started