"SizeChar,6Size of the itemIngrdidInteger ,7 Foreign key Ingredients used in the item Selling price per item for a particularSellpriceDecimal 10,2 Not nullsize Its specifies the uniqueness of eachIngrdidInteger,7 Primary keyingredient which is also not nullIngrdnameVarchar20 Unique Name of the ingredientType of ingredient. Wet, dry, solid ,TypeVarchar10 liquidSupplier identification used toIngredientsSupplieridInteger,7 Foreign key specify the supplier who supplies theingredientsThe volume of ingredients used toQuantityusedInteger,5 make an item which is been ordered.Date to know the volume ofDateDateingredient used on that particularday To know the discount details with itsDiscountidDiscountInteger,5 Primary keyunique number DiscnameVarchar,20 Unique Name for the discount schemeIf the number of items purchased,DisccondInteger,5 Check then discount can be executedThe amount of percentage to beDiscpercentDecimal 10,2 deducted from the total amount A unique number generated forSupplieridInteger ,7 Primary keyevery supplierSuplnameVarchar,29 Unique Name of the supplierSupladdrVarchar,29Address of the supplierSupplier The volume of ingredient supplied byQuantity Integer,7 the supplierPriceDecimal 20,4Price per each quantityTotalDecimal 30,5Total price1. Bank: bankcardid, bankid, bankname, bankadrr,accountnum, amount.Card number which is unique forBankcardidInteger, 15 Primary keyeach customer who holds itBankBankidInteger,10 Unique Every bank has its unique number BanknameVarchar,26Name of the bankBankaddrVarchar,50Address of the bank.AccountnumInteger,15 Unique Accountnum for employees Shows the balance of the accountBalanceDecimal 30,5 Not nullnumber. Specification of the employee with aEmpidEmployeeInteger,7 Primary keycompany numberEname Varchar,25Name of the employeeAccountnum Integer,15Account number of the employeeWhether the employee works onType Varchar Not nullhourly or delivery basissCharge Decimal 10,2Charge per shiftDcharge Decimal 10,2Charger per deliveryLicenceidVarchar,25Licence of the employeeStotal Integer ,5Total number of shifts by a employeeTotal number of delivery by aDtotal Integer,5 employeeSalary Decimal 20,7Total salary of each employee "