" Just a value to know the order of invidInventory Integer,7 Primary keyinventory checkedIngredient id whose stock level hasIngrdid Integer,7 Foreign keyto be knownBaselevel Integer,10 Not null The most minimum level of the stockThe total quantity existing on aTotalquantity Integer,10 particular dateUsedquantity Integer,10The quantity used for a dayCurrentIt will value after deduction of Integer,10 quantityusedquantity from total quantitypresentDate dateDate Date on which the purchase has torepurchasedate Date be made. Mode of communication to place anTypeCall details Varchar,20 order by customerDate DateDate on which call is madestarttime Decimal 10,2Unique Starting time of the callEndtime Decimal 10,2 Unique Ending time of the call Duration Decimal 10,2 Not null Total time taken for taking an order2. Relational schema in DBDL:DBDL is an abbreviation of database description language with a synonyms for the database definitionlanguage. It creates table and specify the column along with its data type and size to be stored in adatabase.Table 1.Customer: create table customer customerid int(10) not null, custname varchar(20) not null , custaddrvarchar(40),custphone int(15) , primary key(customer id).Table 2:Menu:create table menu itemidint(5) not null, itemname varchar(20) unique , size char(6), sellpricedecimal(10,2),primary key(itemid), foreign key (ingrdid) references ingredients(ingrdid)Table 3:Ingredients: create table ingredientsingrdid int(7) not null, igrdname varchar(20) unique , typevarchar(10), quantityused int(10),primary key(ingrdid ), foreign key (supplierid) referencessupplier(supplierid)Table 4:Discount: : create table discount discountid int(5) not null, discname varchar(20) unique , disccondint(5), discpercent decimal(10,2), primary key(discountid ) Alter table discount add constraint check(disscond) set disscond = order.itemquantity>4.Table 5:Supplier: create table supplier supplierid int(7) not null, suplname varchar(29) unique, supladdrvarchar(29) , quantity int(7), price decimal (20,4), total decimal(30,5).Table 6:Bank : create table bankbankcardid int(15) not null, bankid int(10) unique, bankaddr varchar(50),accountnum int(15) unique , balance decimal(30,5) not null.Table 7:Employee: create table employee empid int(7) not null, ename varchar(25), accountnum int(15) , typevarchar (10) not null, scharge decimal(10,2), dcharge decimal (10,2),licenseid varchar(25),stotal int(5),dtotal int(5), salary decimal(20,7), primary key(empid)Table 8:Inventory: create table inventoryinvid int(7) not null, baselevel int(10) not null, total quantity int(10),usedquantity int(10),currentquantity int(10),presentdate date, foreign key (ingrdid) referencesingredients(ingrdid)Table 9:Call details: create table calldetails typevarchar(20), calldate date,starttimedecimal(10,2) unique,endtime decimal(10,2) unique, duration(10,2) not null; "