High School

We appreciate your visit to The company needs a report that shows three category of products based their prices The company needs to know if the product price is cheap. This page offers clear insights and highlights the essential aspects of the topic. Our goal is to provide a helpful and engaging learning experience. Explore the content and find the answers you need!

The company needs a report that shows three category of products based their prices. The company needs to know if the product price is cheap, fair, or expensive. Let’s assume that


If the list price is less than


(avg_price - min_price) / 2


The product’s price is cheap.


If the list price is greater than


(max_price - avg_price) / 2


The product’ price is expensive.


If the list price is between


(avg_price - min_price) / 2


and


(max_price - avg_price) / 2


the end values included


The product’s price is fair.


Write a procedure named Product_Price_Report to show the number of products in each price category:


The following is a sample output of the procedure if no error occurs:


Cheap: 10


Fair: 50


Expensive: 18


The values in the above examples are just random values and may not match the real numbers in your result.


The procedure has no parameter. First, you need to find the average, minimum, and maximum prices (list_price) in your database and store them into varibles avg_price, min_price, and max_price.


You need more three varaibles to store the number of products in each price category:


cheap_count

fair_count

exp_count


Make sure you choose a proper type for each variable. You may need to define more variables based on your solution.


Show your testing.


Note: Some of the above output displayed may not match exactly with your produced output. This is because the script file supplied to you was modified after creation of this lab requirements.

Answer :

Testing is important to ensure the procedure produces the expected output. By providing different sets of data and verifying that the output matches the expected results, you can verify the correctness of the procedure.

To create the Product_Price_Report procedure, you would follow these steps:

1. Define and initialize the variables:
- avg_price, min_price, and max_price to store the average, minimum, and maximum prices respectively.
- cheap_count, fair_count, and exp_count to store the number of products in each price category.

2. Calculate the average, minimum, and maximum prices by querying your database and assigning the values to the corresponding variables.

3. Create a loop to iterate through each product in the database.

4. Inside the loop, use conditional statements to check the price category of each product:
- If the list price is less than (avg_price - min_price) / 2, increment the cheap_count variable.
- If the list price is greater than (max_price - avg_price) / 2, increment the exp_count variable.
- If the list price is between (avg_price - min_price) / 2 and (max_price - avg_price) / 2, increment the fair_count variable.

5. After the loop finishes, print the number of products in each price category using the format "Cheap: [cheap_count]", "Fair: [fair_count]", "Expensive: [exp_count]".

6. Test the procedure with different sets of data to ensure it produces the correct output.

The procedure Product_Price_Report takes no parameters and calculates the average, minimum, and maximum prices of products in a database. It then counts the number of products falling into each price category (cheap, fair, and expensive) based on the provided conditions. Finally, it displays the counts for each category.

The procedure makes use of variables to store the calculated values and to count the products in each category. A loop is used to iterate through each product and the list price is checked against the conditions to determine the category. The counts for each category are incremented accordingly.

Learn more about the list price: https://brainly.com/question/13043080

#SPJ11

Thanks for taking the time to read The company needs a report that shows three category of products based their prices The company needs to know if the product price is cheap. We hope the insights shared have been valuable and enhanced your understanding of the topic. Don�t hesitate to browse our website for more informative and engaging content!

Rewritten by : Barada