"5. Discount: discountid, discname, disccond, discpercent.6. Supplier: supplierid, suplname, supladdr, quantity, price, total.7. Bank: bankcardid, bankid, bankname, bankadrr, accountnum, amount.8. Employee: eid, ename, bankid, accnum, scharge, dcharge, stotal, dtotal, type, licenceid, salary.9. Inventory:invid, ingrdid, baselevel, totalquantity usedquantity, currentquantity, daterepurchasedate.10. Call details: type, date, start time, end time, duration.To generate BCNF, the following columns can be used in the preceding tablesTable name column name DescriptionIngredient id helps in retrievingSupplier ingrdid information about stock level, itemdetails.Bankid is used to know the details of theBank bankidemployee, customer alsoLicence id is used to find the employeeEmployee licenceidwho works on basis of delivery routesOrder date gives the details of customer,Order orderdateorderitem.**All the column name specified in the tables name above are the candidate keys which areimplemented in the third normal form to covert the table into BCNF normalization type. Data dictionaryA data dictionary is a collection of descriptions of the date objects or items in a data model forthe benefit of programmers and others who need to refer to them or the dictionary of data is at a timethe pillar of work and the result of research and analysis of data. It is just like a depicted picture of theentire work. This dictionary of data defines all categories of data or data types, brief the all essentialinformation about the software is included.Table DatatypeField name Constraint Descriptionname ,sizeOrderid Integer, 6 Primary key Identification numberof orderOrderdate Date Not null Date on which order is madeThe order is made by phone or walk- Type Varchar,20 Not nullinCustomer number who has made theCustomerid Integer ,10 Foreign keyorderCustomer had ordered an item fromItemid Integer,5 Foreign keyOrdermenuDiscount given to the customer forDiscountidInteger, 5 Foreign key an item on certain terms andconditionsBased on the discount amt isDiscountamtDecimal(7,3) deductedBankcardidInteger ,15 Foreign key Used to collect the amount for ordered items through a bankcardThe number of items purchased byItemquantityInteger,5 the customerDecimal Total amount after deduction ofTotal amnt(10,3) discountEmployee id used to keep track whoEmpidInteger ,7 Foreign keyworks on a particular order It is used to create a unique and notCustomeridInteger ,10 Primary key null field which distinguish between two customersName of the customer who places anCustnameVarchar,20 Not nullCustomerorderAddress of the customer, it can beCustaddrVarchar,40 Not nullmultivalued attribute if neededCustphoneInteger ,15Phone number of the customer Identifies each and every item with aItemidInteger,5 Primary key unique number and it will be notMenuemptyItemnameVarchar,20 Unique Name of the item "