7. Software Sales A software company sells a package that retails for $99. Quantity discounts are given according to the following table: Quantity Discount 10-19 20% 20-49 30% 50–99 40% 100 or more 50% Design a program that asks the user to enter the number of packages purchased. The program should then display the amount of the discount (if any) and the total amount of the purchase after the discount.

7. Software Sales A software company sells a package that retails for $99. Quantity discounts are given according to the following table: Quantity Discount 10-19 20% 20-49 30% 50–99 40% 100 or more 50% Design a program that asks the user to enter the number of packages purchased. The program should then display the amount of the discount (if any) and the total amount of the purchase after the discount.

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

Q: Select statement that will return all records and fields from a table

A: The question is asking for a SQL statement that will return all records and fields from a table in a…

Q: List the first name and last name of all authors. Concatenate the first and last names so that the…

A: Concat() function : This function in SQL joins string into one, maximum string which it can take as…

Q: The number of years that have passed since your birth may be easily determined by using an Oracle…

A: Oracle functions may be accessed through different SQL queries and are built within the Oracle…

Q: The following table is in 2NF. Convert it to 3NF using proper notation: Forum (ForumNum, ForumDate,…

A: Second normal form (2NF) is based on full functional dependency and the third normal form (3NF) is…

Q: 5. Using the Max function, write a formula in cell F7 of Top10_Pivot Sheet to find the maximum "Sum…

A: Max Function: It returns the maximum from the range of values. Syntax: MAX(number1, number2, ....)…

Q: Oracle functions may be used to quickly and accurately determine how many days have elapsed since…

A: Several SQL statements may employ Oracle functions, which are built within the Oracle Database. The…

Q: The State of New York certifies firefighters throughout the state and must keep track of all of…

A: Given: The State of New York certifies firefighters throughout the state and must keep track of all…

Q: Need help with question d, e, f

A: To create a regular expression for the language of all strings that do not end with "ba," you can…

Q: Order Number: 5678 Customer Number: 9123 Customer Name: Thomas Customer Address: 51 Samora Machel…

A: Normalization which refers to the one it is the process of organizing data in a database in order to…

Q: Find the bijection, surjection and cardinality from an NFA

A: NFA is non-deterministic Finite Automata when there exits many paths for the specified input from…

Q: The following table is in 1NF. Convert it to 2NF using proper notation:

A: Facilitator (FacilitatorID, LastName, FirstName, Street, City, ZipCode, (ForumNum, ForumDate,…

Q: Where is part C? Please answer part C

A: Que) Imagine that the vertical arrows below the devices are timelines and that the clocks of all…

Q: would like to get an explanation of the codes and how they function after the dictionary, please

A: Answer:

Q: The State of New York certifies firefighters through- out the state and must keep track of all of…

A: Introduction: A relational database model provides a way of organizing related data and information…

Q: At least one of the Data Table's input window areas must point to the objective function being…

A: Correct Answer is B. False

Q: Please see the attached document and use kruskal algorithm please, Thanks

A: Kruskal’s Algorithm is a greedy algorithm which is used for finding the Minimum Spanning Tree of a…

Q: Product a report showing the distinct first and last names of customers from the state of New York…

A: In the Database , a SQL query which refers to the one it is a request for data from a database. SQL…

Q: Write the header for a procedure named prc_orNot_prc CREATE PROCEDURE Answer:

A: Procedure is a combination of queries that can be put together and called upon need by there name…

Q: USING the SELECT statement, query the track table ordered by the bytes. Set the LIMIT to 5 and…

A: In this problem we need to design share the details what will be the output of the above mentioned…

Question

Include the IPO chart and algorithm.

7. Software Sales
A software company sells a package that retails for $99. Quantity discounts are given according to the
following table:
Quantity
Discount
10-19
20%
20-49
30%
50-99
40%
100 or more
50%
Design a program that asks the user to enter the number of packages purchased. The program should
then display the amount of the discount (if any) and the total amount of the purchase after the discount.

Process or set of rules that allow for the solving of specific, well-defined computational problems through a specific series of commands. This topic is fundamental in computer science, especially with regard to artificial intelligence, databases, graphics, networking, operating systems, and security.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

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

Outline the box model.
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
How many select statements from the same table may be combined?
All foreign language results should be rated Fails to Meet. a) True b) False
For this portion of the lab design the solution in the following manner: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.
You should use an Oracle function to determine the number of days since your birthday.
If the following use-by dates were on containers of food,which one should be used first when following FIFO (First in,First out)?
Rank in order to make it calculate standard deviation
On the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate. Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.
differences between Trigger and Stored Procedures in tabular form
pythin in file and list , I want to make list of month from Jan to Dec , and enter sales for each month . Make average , total , minimum and max sales .
Students: Johnson, Williams, Matt, Jones, Eric, Lili, John and Jason, whose grades are listed below. Each column is the grades each student received. There are 8 students with 10 grades each. Johnson: 79, 92, 85, 0, 100, 64, 72, 99, 90, 86 Williams: 80, 75 93, 94, 0, 90, 89, 88, 87, 86 Matt: 82, 67, 72, 74, 89, 0, 70, 89, 100, 76 Jones: 85, 84, 82.5, 82, 84, 80, 80.5, 90, 96, 85 Eric: 90, 91, 87, 85.5, 86.5, 0, 90, 90, 91, 92 Lili: 60, 75, 81, 70, 80, 81, 94, 67.5, 99, 98 John: 79,0, 74, 96, 88.5, 88, 0, 100, 86, 83 Jason: 89, 90, 90, 85, 85, 90, 91, 88, 100, 79 Write user-defined functions or build-in functions (e.g., sum, mean, max, min, etc.) to calculate: The Average Grade of each student; this average should be a vector. The average of the class; this average is a scalar vector. The highest grade among the Average Grade of Each Student The lowest grade among the Average Grade of Each Student Show a table with each student's name, average grade and letter score using A, B, C, D, F…