"Table 10:Order : create table order orderid int(6) not null, orderdate date not null,type varchar(20), discountamtdecimal (7,3), itemquantity int(5),total amnt decimal(10,3),primary key(orderid), foreignkey(customerid) references customer(customerid), foreign key (itemid) references menu(itemid),foreign key(discountid) references discount(discountid), foreign key (bankcardid) referencesbank(bankcardid), foreign key (empid) references employee(empid) on update cascade;Part-21. Create a normalized database gourmetMysql:>Create database gourmetpizza;2. Insert at least three rows in all the tables. a. mysql:> insert into customer (customerid , custname, custaddr ,custphone)values (101, ‘john’,’rosterstreet melbourne’, 87956423); mysql:> insert into customer (customerid , custname, custaddr ,custphone)values (102,‘adam’,’sydney’,2356898);. mysql:> insert into customer (customerid , custname, custaddr,custphone)values(131,’diana’, ‘diahouse melboure’,56897456);b.mysql:> insert into menu ( itemid, itemname, size, sellprice)values (11,’tandor’,’small’,105.50);mysql:> insert into menu ( itemid, itemname, size, sellprice)values (12,’spicy’,’medium’,210.75);mysql:>insert into menu(itemid, itemname, size,sellprice) values (13,’chickcy’,’medium’,300); c. mysql:> insert intoingredients ( ingrdid, igrdname, type, quantityused) values(501,’almonds’,’solid’,10); mysql:> insert intoingredients ( ingrdid, igrdname, type, quantityused) values (502,’cashew’,’solid’,11);mysql:> insert intoingredients ( ingrdid, igrdname, type, quantityused) values(503,’sauce’,’liquid’,150);d. mysql:>insert into supplier (supplierid, suplname, supladdr , quantity, price )values(‘6011’,’swastik’,’adeladie’,1000,10,);mysql:>insert into supplier (supplierid, suplname, supladdr , quantity, price )values(6012,’sherme’,’saintburgs’,1200,90);mysql:>insert into supplier (supplierid, suplname, supladdr , quantity, price )values(6013,’sherlock’,’newzealand’,1520,75);mysql:>update supplier set total=quantity * price;e. mysql:> insert into discount (discountid, discname, discpercent) values (20101,’summer’,10,);mysql:> insert into discount (discountid, discname, discpercent) values (20121,’rain’,18,);mysql:> insert into discount (discountid, discname, discpercent) values (20120,’autmn’,5,);mysql:>upate discount set disscond = true whereorder.itemquantity>4.f. mysql:> insert into Bank (bankcardid, bankid, bankaddr accountnum, balance)values(1000200555,2450, ‘axis’,’melbourne’,245010,500);mysql:> insert into Bank (bankcardid, bankid, bankaddr accountnum, balance) values(1052200555,2540,‘scot’,’melbourne’,254011,1500); mysql:> insert into Bank (bankcardid, bankid, bankaddr accountnum, balance) values(100520051,6582,‘british’,’sydney’,56823,10000.500);g. mysql:> insert into employee (empid, ename, accountnum , type, scharge, dcharge ,licenseid ,stotal,dtotal) values(1001,’ davidjones’,245010,’shift’,175, ,,35, ,);mysql:> insert into employee (empid, ename, accountnum , type, scharge, dcharge ,licenseid ,stotal,dtotal) values(1002,’border’,25896,’delivery’, , 125,8745682, ,52);Mysql:>insert into employee (empid, ename, accountnum , type, scharge, dcharge ,licenseid ,stotal,dtotal) values(1005,’ian smith’,568942,’delivery’, , 145,8733456182, ,56);Mysql:>update employee set salary =scharge*stotal where type = ‘shift’;Mysql:>update employee set salary=dcharge*dtotal where type=’delivery’;h. mysql:>insert intoinventoryinvid, baselevel, totalquantity, usedquantity, presentdate) values(2011,500,10000,2500,’10.05.2017’,);mysql:> insert intoinventoryinvid, baselevel, totalquantity, usedquantity, presentdate) values(2013,200,1000,250,’10.04.2017’,);mysql:>insert intoinventoryinvid, baselevel, totalquantity, usedquantity, presentdate) values(2021,1500,10000,2500,’18.04.2017’,);mysql:>update inventory set currentquantity = totalquantity-usedquantity;i.mysql:>insert into calldetails (type, calldate,starttime, endtime) values(‘telephone’,’10.05.2017’,’10.55’,’11.12’); "