Optimize the following SQL Query by using Query Tree and Heuristic Rules:
SELECT C.Fname, E.Fname
FROM Employee AS E, Customer AS C, Order AS O
WHERE E.EMP_ID=O.E_ID AND C.City=’Jeddah’ AND C.Customer_ID=O.C_ID AND E.EMP_ID=’12943’
You should show the Initial Query Tree and add a screenshot of the Query Tree after applying each rule. [0.5 for each correct step]
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount