Answered: Assume we want to determine the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Assume we want to determine the commission received by a salesperson. The commission rate is based on two factors, the amount of sales and the class to which the salesperson belongs. The input will be the sales and the class which the sales person belongs. The output will be the salesperson's nme, number and commission. The commission rate will be based on the following:

Class =1 If sales is equal to or less than $1000, the rate is 6 percent

Class 2= If the sales is less than $1000, the rate is 4 percent.

Class 3= If the sales is $1000 or greater, the rate is 6 percent

Class 4= The rate is 4.5 percent of all sales amounts

Class5= The rate is 5 percent for all sales amounts

Class- any other= Output appropriate error message

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions