Create a flowchart and pseudocode using control breaks

Assignment Help Database Management System
Reference no: EM13945456

Shemrock Inc. is a brake pad manufacturing company. This company uses raw materials, such as carbon powder, iron, ash, and resin. It wants to develop an inventory management system that will have the following features:

The system should store the current inventory levels for different raw materials in a file.

If carbon powder is less than 500 lbs, then the system will check if orders are still pending on the shop floor. If pending orders are for more than 5,000 brake pads, then someone should order 2,000 lbs of carbon powder; otherwise, someone should order for 1,000 lbs of carbon powder.

Similarly, perform the same check for other raw materials iron, ash, and resin. The list of all the raw-material vendors is available with Shemrock Inc. The system should read and store the vendor information and then, depending upon the raw material that is to be ordered, print out the purchase order for that raw material. The purchase order will contain the details of the raw material such as the name, quantity, total cost, and vendor address.

Create a flowchart and pseudocode using control breaks that enable the user to print invoices for any raw material that is selected.

Reference no: EM13945456

Questions Cloud

Design a class named productionworker that extends employee : The workday is divided into two shifts: day and night. The shift field will hold an integer value representing the shift that the employee works. The day shift is shift 1 and the night shift is shift 2. Design the appropriate accessor and mutator ..
Illustrate your answer by referring to specific brands : Illustrate your answer by referring to specific brands within each of the two product categories you have chosen.
What principles of statutory interpretations were utilized : What principles of statutory interpretations were utilized by the Court in this case - Explain in plain English the implications of Australian Maritime Officers'
Examples of pseudocode containing control structures : From the above examples of pseudocode containing control structures, analyze the logic implemented in the pseudocode.
Create a flowchart and pseudocode using control breaks : The system should store the current inventory levels for different raw materials in a file.
Both fishing method and the range of fishing operation : describe the development which have taken place during recent years in both fishing method and the range of fishing operation
Loss on the abandonment : Loss on the abandonment of office equipment $25,000 Loss on the sale of a building
What disciplines are essential for spiritual growth : What does Scripture and current research say about the role of apostles, prophets, evangelists, shepherds, and teachers in church multiplication?
Which bond has the higher yield to maturity : Bond B was issued 10 years ago with a coupon rate of 8%. If bonds with similar risk today are yielding about 8%, which bond has the higher yield to maturity?

Reviews

Write a Review

Database Management System Questions & Answers

  Design an relational model model of a database

Design an Relational Model (RM) model of a database (DB) that will be useful for each of the chosen enterprises. (Hint: You may choose to translate the 2 ER model designs you created ).

  Write a program to calculate the tax of an employee

Write a program to calculate the tax of an employee whose employee number is input from the keyboard. Display an appropriate error message if the data does not exist in the Emp table.

  Create application owner and stored in schema

One of the tenets of database development is to never permit developers to create or own objects during development. All objects are created by application owner and stored in that schema.

  How do e-commerce websites use database technologies

How do e-commerce websites use database technologies to improve sales and track customer-buying and customer-searching habits? In your discussion, provide at least three examples of e-commerce websites that use databases.

  Describe the benefits and current trends of data

write a six to eight 6-8 page paper in which youquestion 1. provide an executive overview that addresses the

  Yrace history of the development of databases

In 500 words or less, trace the history of the development of databases beginning with pre-computer days to the present.

  Give preliminary information on data requirements for gis

You have been requested to give preliminary information on the data requirements for a GIS which is to be used to hold inventory of continental scale vegetation maps for coarse scale land surface

  Activity-based costing to assign overhead costs to products

How much overhead cost would be assigned to each of the two products using the company's activity-based costing system

  Roles and responsibilities of database administrator

For this assignment, research different roles and responsibilities of a database administrator. Research 3 routine tasks involved in database administration

  Build entity relationship model military information system

Build an entity relationship model for the above scenario. Show all attributes and indicate all of your key attributes in red.

  Variation of activity-based costing

Product cost of product U86Y under the company's traditional costing system is closest to - product cost of product M91F under the activity-based costing system

  Determine the total amount of indirect factory wages

Determine the total amount of indirect factory wages and factory equipment depreciation costs that would be allocated to the Product Processing activity cost pool.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd