Question: use python 3.7 please solve all . Problem Description The Operation Manager of a Karak shop keeps an inventory of food and beverages raw material,

use python 3.7 please solve all .  use python 3.7 please solve all . Problem Description The Operation
Manager of a Karak shop keeps an inventory of food and beverages
raw material, onpaper. The usual operations of the manager for the inventory

Problem Description The Operation Manager of a Karak shop keeps an inventory of food and beverages raw material, onpaper. The usual operations of the manager for the inventory database include adding new material, updating levels of current stock material and producing different reports based on the current stock levels. As the inventory is getting larger, this manual system is becoming difficult to manage. The Operation manager decided to develop a computerized system to help him manage the inventory to increase the effectivity and the efficiency of the shop Operations. Because the manager is not an expert in database management systems, he decided to develop his own application, based on the Python knowledge he had during his early engineering education. The raw material data are printed as in the following table: Item Item Price Per Item Quantity Item Description Creation Update Category Name Serial Item Volume Timestamp Timestamp Code (OR) or Weight Normal 1 2021-02-05 Milk 09:32:36.43535 0 Item NML1 1 10 50 Full Fat Milk ML2 N 10 1 30 Normal Milk Semi-Fat Milk ML3 3 10 1 10 Normal Milk Skimmed Milk 2021-02-05 09:32:36.43535 0 2021-02-05 09:32:36.43535 0 2021-02-05 09:32:36.43535 0 2021-02-05 09:32:36.43535 0 ML4 4 25 0.5 4 Normal Milk Lactose free milk Coffee COF1 un 60 2 20 Brazilian Roasted Black Coffee 1 Coffee COF2 6 120 25 Costa Rican Medium Roasted Black Coffee Red Malaysian Tea Tea TEA1 7 40 0.5 20 2021-02-05 09:32:36.43535 0 2021-02-05 09:32:36.43535 0 2021-02-05 09:32:36.43535 0 2021-02-07 08:23:23.12535 0 CML1 8 10 0.5 30 Condense d Milik Baladna Condensed Milk Sweety English Breakfast Tea Tea TEAZ 9 50 1 24 Data is read from the inventory file and stored in arrays of correct data type. Further data processing is performed on these arrays. Requirements Phasel: Within the main function do the following: You are required to help this Operation Manager by developing the Inventory Control System. Your system should perform the following operations: A. Add a new item that asks the user to input data of a new Item Category and then add the data to the material file. B. List the current inventory in a tabular format (begin with the Item Category followed by Item description). In the last column of this list show the total price of each item category (i.c. price quantity) C. Produce lists of the following: 1. All items whose quantity field

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!