Customer (CID, CName, PhoneNo, EmailAdd, Gender, DateOfBirth, CAge, Password, Membership, CHome, DeliveryAdd) Order (OID, CID, SID, PayDate,
Question:
Customer (CID, CName, PhoneNo, EmailAdd, Gender, DateOfBirth, CAge, Password, Membership, CHome, DeliveryAdd)
Order (OID, CID, SID, PayDate, PayMethods, Fee)
OrderLine (OID, PID, OrderQuantity)
Product (PID, PType, PDescription (Name, Size, Color), Price, Quantity)
NonCustomizedProduct (NPID, CollectionName)
CustomizedProduct (CProductID) CustomTextCase (TCC_ID) CustomPhotoGC (PGC_ID) CustomAccessories (TAC_ID)
Warehouse (WID, PID, WLocation)
Shipment (SID, OID, RecipientName, ContactNo, DeliDate, DeliArrivalDate)
Self-pick up (PickUpID, StoID)
Destination (DeliveryID, DeliveryAddress)
Store (StoID, StoAdd)
Note: Composite address (Flat, Floor, Block, Building, Street, District) The foreign key relationships between the tables: Customer:Order 1:M Order:OrderLine 1:M Order:ProductLine M:N OrderLine:Product M:1 Product:Warehouse M:1 Warehouse:Ship 1:M Ship:SelfDelivery M:1 SelfCol:Store N:M Ship:DoorDelivery N:M
1. List customer name that order "CustomerTextCase"
2. List the name and phone number of those customer who have placed top ten most orders
3. List the average number of order in each shipment that the final take-up point is Store
4. Find out type of products with average price below $2000
5. Find out members with first names containing character "N" and the name comprises more than 8 strings
6. Find out stores with the most self pickups
7. Find out Warehouse locations of CustomPhoneGC
8. Find out members with high brand loyalty by examining times of purchase
9. Find out the highest purchased product quantity from order line
10. Find out the customer who order CustomAccessories and make PaymentDate on 20 November 2022