Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you help me in this program i want it in python language Problem Description An engineer keeps an inventory of car parts, but on

image text in transcribed

image text in transcribed

image text in transcribed

can you help me in this program i want it in python language

Problem Description An engineer keeps an inventory of car parts, but on paper. The usual operations on his 'inventory database include adding new parts, updating levels of current stock 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 engineer decided to develop a computerized system to help him manage the inventory. As he is not 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 parts data are printed as in the following table: make model partNo price quantity part Name Toyota Corolla 1 3.65 11 Brakes Toyota Land Cruiser N 65.70 26 Battery Mazda CX3 3 45.55 13 Battery Honda City 4 10.95 30 AC compressor o Requirements Phasel: You are required to help this engineer by developing the Inventory Control System. Your system should perform the following operations: Show the menu of possible operations in the system as shown below. The menu should include the following operations. o List the current inventory in a tabular format (begin with the partNo followed by the PartName). The last column of this list shows the total price of each item (i.e., price* quantity). O List all parts 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 Concepts

Authors: David Kroenke

4th Edition

0136086535, 9780136086536

More Books

Students also viewed these Databases questions

Question

How do modern Dashboards differ from earlier implementations?

Answered: 1 week ago