Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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: Quantity Item Description Item Category Item Name Code Item Serial Price Per Item (QR) Creation Timestamp Update Timestamp Item Volume or Weight 1 NML1 1 10 50 Full Fat Milk Normal Milk 2021-02-05 09:32:36.43535 0 ML2 NI 10 1 30 Semi-Fat Milk Normal Milk ML3 3 10 1 10 Skimmed Milk Normal 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 Lactose free milk Normal Milk Coffee COF1 5 60 IN 20 Brazilian Roasted Black Coffee 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 Milk Baladna Condensed Milk Sweety English Breakfast TEAZ 50 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 (ie. 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And Implementation

Authors: Edward Sciore

2nd Edition

3030338355, 978-3030338350

More Books

Students also viewed these Databases questions

Question

What is a finite stochastic process?

Answered: 1 week ago