You are required to create a database for a fictitious Online Shoe Store called WalkthisWay' (think Williams Shoes or Novo) for Task 1. Write an SQL script that builds a database to match the relational model below. These SQL statements in the script must be provided in the correct order. The solution will be demonstrated in one or more MySQL screen snapshots that include the Execute SQL tab SQL code and the results of the executed statements. StoreEmployee (empid, eName, eAddress, ePostCode, eEmail, eMobPh, eStartDate, storeld) Customer (custid. cName, cMobilePh, cEmail, cBirthDate) Order (orderld. oDate, total, GST, deliveryAddress, orderStatus, custid) OrderDetail (orderld, prodld, quantity, retailPrice) Payment (payld, type, amount, pDate, bank TransactNo, orderld) Product (prodid, size, colour, style, qtyOnHand, reorderQty, retail Price, supirid) ProductSupplier (prodid, supirid) Supplier (suplrld, supirName, suplrAddress, suplrPostCode, suplrEmail, suplrMobPh) FOREIGN KEYS StoreEmployee(storeld) references Store (storeld) Order (custld) references Customer(custld) OrderDetail(orderld) references Order(orderld) OrderDetail(prodld) references Product(prodid) Payment(orderld) references Order(orderld) Product(supirid) references Supplier(suplrld) ProductSupplier(prodid) references Product(prodid) ProductSupplier(supirld) references Supplier(suplrld) Other Constraints and Remarks All primary and foreign key attributes are strings (not text) comprising seven digits. All PostCodes are strings comprising four digits. INTEGER type must be used for total, GST, quantity, retailPrice, qtyOnHand, reorderQty, and amount. TEXT type must be used for all other attributes. sName, eName, cName, suplrName must contain a value (you will need to add values to these attributes) MY SQL has order as a keyword, to create this table you will need to use the backward quotation mark as shown Order".