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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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