Draw context diagram that represent supply ordering system

Assignment Help Database Management System
Reference no: EM13328440

Draw a context diagram that represents a Supply Ordering System (SOS). This system is to be used by EraTech company to supply computers to their clients whenever order has been finalised. Decompose this to a level-0 diagram. Document the process description into Structured English and Decision Tree based on the discount policy given below.

Discount policy:
Using the SOS, EraTech sends out invoices monthly and will give discounts if payments are made within 10 days. The discount policy is as follows: If the amount of the order for computer supplies is greater than $1,000, subtract 4 percent for the order; if the amount is between $500 and $1,000, subtract a 2 percent discount; if the amount is less than $500, a discount is not applicable. All orders made via the Web will automatically receive an extra 5 percent discount.

 

Reference no: EM13328440

Questions Cloud

Explain sum of products''s s - sum of reactants''s s : The unit of S was the J/(mol*K) the book said. But, in delta S, why the unit is J/K? I just think when I want to calculate delta S, sum of products's S - sum of reactants's S, so the unit of delta S is same as S I thought. What is it
Determine at what rate must the gases be ejected : A rocket traveling 1850 m/s away from the Earth at an altitude of 6800 km fires its rockets, at what rate must the gases be ejected
Determine the final charge on the capacitor : You have an uncharged capacitor (12 x 10-6 F) and a resistor (1000 ohms) connected to a battery of 200 V at time t = 0, What is the final charge on the capacitor
Evaluate the percent ionization of acetic acid : (a) Calculate the percent ionization of 0.00190 M acetic acid (Ka = 1.8e-05). % ionization = % (b) Calculate the percent ionization of 0.00190 M acetic acid in a solution containing 0.0710 M sodium acetate. % ionization = %
Draw context diagram that represent supply ordering system : Draw a context diagram that represents a Supply Ordering System (SOS).
Describe hcl is a stronger acid than h2s : Select all of the correct statements about the relative acid strengths of pairs of acids from the choices below. HCl is a stronger acid than H2S because Cl is more electronegative than S. H3PO3 is a stronger acid than H3PO4 because it has fewer ox..
Compute the new damping constant : mass, 0.057 kgs, driving force F0 = 8.9 N and linewidth 48 radians/second, has its damping constant, b, changed, Determine the new damping constant,b
What maximum height above the launch point does ball attain : A ball is thrown upward,. At 5.00 m above its launch point, the ball's speed is one-third its launch speed. What maximum height above the launch point does the ball attain
Explain excess 6m naoh solution instead of 6m nh3 solution : The choice of precipitating reagent is important. Briefly explain what the consequences would be if excess 6M NaOH solution instead of 6M NH3 solution were used to separate Fe3+ and Al3+ ions from Ca2+, Cu2+,

Reviews

Write a Review

Database Management System Questions & Answers

  Produce budget reports for department at university

Consider system which produces budget reports for department at university. For whichever system you select, answer the following design questions. Who will use output?

  How referential integrity constraint prevent data

In physical database design, referential integrity constraints can be defined. What actions does referential integrity constraint prevent from happening when data is inserted in table which contains this constraint?

  Write query to perform inner join of grade and student

Write a query that performs an inner join of the grade, student, and grade_type tables using ANSI SQL 99 syntax (JOIN ON).

  Explain the architecture of a system for serving up

Draw a diagram of, and explain the architecture of a system for serving up dynamic pages from a database. Show the protocols involved, the flow of messages and what types of information the messages contain.

  Case study-zen chiropractic clinic

Display the full details for the cheapestservices provided by ZC2 -  The Case Study-Zen Chiropractic Clinic

  Explain the idea for database and partitioned view

Explain the idea for the database along with the thoughts for partitioned view. How would you utilize this partitioned view?

  Explain good strategy for processing queries

Explain a good strategy for processing each of following queries. Determine all machines at Almaden plant. Determine employee 1 machine.

  Write name of employee on every project located in houston

Write the name(s) of employee(s) who works(work) on every project located in Houston. Write the name(s) of employee(s) who only works(work) on every project located in 'Houston.'

  Prepare the relational schema for database

Prepare the relational schema for database

  Creating database structure using sql

creating database structure using SQL

  Compare two non-sequential file structure models

Compare the two non-sequential file structure models. What advantages does the first one have over the second and what advantages does the second have over the first?

  Explain evaluating a proposal for acquisition and sourcing

When evaluating a proposal for acquisition and sourcing, are there considerations that are unique in the case of an IT project versus a non-IT project

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