" INVENTORY DATABASE 1. Table creationDrug Table Create Drug table based on the given details. It contains the details of Drug Name, NDC,Brand, Strength, Package size, Quantity, Unit price, Expiry date, Dispensed date and Inventoryvalue.1 2. ER diagramThe relationship diagram of the Inventory database is given below. 3. Form The Form view of the Drug table is given below. It is used to add the new inventoryitems in the database. To add the new Drug in the database, click the Add Drug button.2Enter the details of the drug and click the save button. The New record will be added tothe database.The following image shows the drug details which is added in the database.4. QueryMonthly Report The Following query gives the monthly report of the Inventory database.This querygives the details about the selected month. To create a query, select the query wizard and add the3 drugtable. In the criteria field, give the starting and ending date of the specific month. Thenexecute the query. It will display the monthly report of the selected month.The following screenshot shows the monthly report of March month.Dispensed date Report The Following query gives the Dispensed Date report of the Drugs.This query gives thedetails about the selectedDispensed month. To create a query, select the query wizard and addthe drug table. In the criteria field, give the starting and ending date of the specific month. Thenexecute the query. It will display the dispensed date report of the drugs.The following screenshot shows the Dispensed drug details in March month.4 "