Consider the following database schema:
Customer (cid, cname, phone, age)
Order (oid, date, total_price, cid, sid)
Order_item (coid, oid, quota)
Inventory (coid, coname, amount, price, sid)
Shop (sid, sname, revenue)
Membership (cid, sid, date, type)
Primary key attributes are underlined. Note that coid is a unique id for commodities in theinventory and in an order.
Answer the following questions using QBE. Draw tables in your answer.
1. Find the name of the customers who bought ‘surface' on ‘01/21/2015' from shop ‘NYC Windows Store'.
2. Find the oldest customer who is either a member of ‘NYC Windows Store' or ‘LA Windows Store'.
3. Insert records to the Membership table for those customers who have purchased formore than $30000 before '04/01/2014' in the shop ‘NYC Windows Store'. Setmember type = ‘regular member' and date='04/01/2015'.