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

  Normalize the following table into first normal form

Normalize the following table into first normal form. The table uses one row to record information about each student. A student may take one or more electives. This table is not in 1NF. Normalize this table so it is in 1NF. In your answer, list a..

  Design an expanded entity relationship model diagram

You are to design an Expanded Entity Relationship Model Diagram. An example of the Expanded Entity Relationship Model Diagram is seen in Figure 3.27 on page 89.

  Differentiate between a flat file and a relational database

Determine when a sequential file is more useful than a database. Differentiate between a flat file and a relational database

  Calculate confidence and support of rule

Assume that 30% of science students are majoring in biology. Would you consider to be novel with respect to rule? Describe. Calculate confidence and support of rule.

  Develop an eer model for the given situation

Develop an EER model for the following situation, using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation.

  What is the purpose of a database driver

what is the purpose of a database driver in terms of what it connects and What are some other examples of Database Drivers out there for the J2EE and .NET Platforms?

  Create database for university to monitor students

A database is to be created for University to monitor students' progress throughout their course of study. Students are reading for degree (such as BTech, BTech(Hons) MCA, etc) within framework of modular system.

  Statements for the subsequent queries of the database

Write the statements for the subsequent queries of the database - Find Beth' s home state.

  Create database that implements the proposed data warehouse

Knowing the customers for targeted advertising. The board would like to know which type of customers (age or gender) are more interested in which types of cars (type)

  Stack and queue data structure

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

  Project taskstask 1 analytic objectiveindividual groups are

project taskstask 1 analytic objectiveindividual groups are expected to come up with an analytic objective for which

  Create stored procedure to updates members balance

Create a stored procedure that updates the members' balance in the membership table by correctly recording the current or outstanding balance for each customer.

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