Consider the following database.
TRAVEL-AGENT (name, age, salary)
CUSTOMER (name, departure_city, destination, journey_class)
TRANSACTION (number, cust_name, travel_agent_name,amount_paid)
a. Write an SQL query to display the names of all travel agents whoarranged trips for customer “John Smith”.
b. Define indexes on selected attributes to speed up your query.Justify your selections.
Expert Answer
An answer will be send to you shortly. . . . .