CUSTOMER DATABASE customer(custno: int, cname: String, custcity: String) order(orderno: int, orderdate: date, custno: int, orderamt: int) item(itemno: int, unitprice: int) orderitem(orderno: int, itemno: int) warehouse(warehouseno: int, wcity: String) shipment(orderno: int, warehouseno: int, shipdate: date)
1. Create all the above tables.
2. Insert at least 5 tuples into all the tables.
3. Display all the records of all the tables.
4. DISPLAY CNAME OF THE CUSTOMER TABLE IN ALPHABETICAL ORDER.
5. DISPLAY WAREHOUSENO OF THE WAREHOUSE TABLE WHOSE WCITY IS ‘HUBLI'.
6. LIST THE ORDERNO FOR ORDERS THAT WERE SHIPPED FROM ALL THE WAREHOUSES THAT THE COMPANY HAS IN A SPECIFIC CITY.
7. PRODUCE A LISTING CUSTNAME,NO OF ORDERS,AVG_ORDERAMT, WHERE THE MIDDLE COLUMN IS THE TOTAL AVERAGE ORDER AMOUNT FOR THAT CUSTOMER.