Build me an Inventory Management System for a Hardware Store

Project Due Date: December 8, 2021 I should design and create a software application for a hardware store. This store has two (2) types of users - Managers and Cashiers. Managers are allowed to do the following: i. Add new stock items ii. Increase the quantity of stock items iii. Remove an item from the system (not remove the quantity, but the item from the database) iv. Change, or modify all items within the store v. Perform price checks on any item vi. Change their own password and reset passwords for cashiers and other managers vii. Produce several Reports a. Daily Quantity report (List of all items that are under stock) b. Total sales for each item at the end of the month Cashiers require the following capabilities: i. Deduct an item from the quantity as it is sold ii. Perform price checks iii. Change their own password Your system should allow cashiers to sell items, as long as they are in stock, and should give a total bill based on items purchased and the quantity that has been purchased. The bill total must include GCT of 16.5 %. The following will therefore be required in your database, however you are expected to add anything else you deem as required or important to solve your problem User Information: UserId, UserName, Typeof User ITEM Information: ItemId, Item Description, TotalInStock, UnderstockValue, saleprice, PurchasePrice Sales Information: SalesId, CustomerName, ItemId, Quantitysold, datesold Purchase price is the cost the hardware spent to purchase the item. Sales price is the cost the customer pays to purchase the item from the store. SaleID should be automatically generated Stock prices should be in JMD NB: Your system MUST update the database each time an item is sold. Project Presentation PowerPoint Presentation Guidelines Student will make a short (7 – 10 minutes) project presentation. Each presentation must provide the following: 1. Description of the problem [2 marks] 2. Demonstrate (Working Program, Database, Functionality) [8 marks] Presentation Grading [TOTAL 10 marks]