QUESTION 1 a) Based on the requirement given below, prepare a flowchart for a program develop for PaintsForYou Painting Shop, to calculate customer's total purchases of painting products. • Set all necessary variables. • Get customer's name. Ask if customer is a member of the shop o If yes, ask for customer's membership ID o If customer is a member, they will get 10% discount off the total price Get item code to purchase and quantity • Based on the item code, identify the item name and price. o If user enter invalid item code, set item name as “Invalid Code" and price is RM0.00 Calculate the payment for the product. • Calculate the total price. • Display the quantity, item name, and payment of the product. Repeat as long as user wish to purchase more item. • If user wish to stop purchase, calculate the total price after discount. • Display the total price, discount and total price after discount. • Refer to Sample Output 1 and Sample Output 2. b) Båsed on the description given in (a), write the pseudocode

QUESTION 1 a) Based on the requirement given below, prepare a flowchart for a program develop for PaintsForYou Painting Shop, to calculate customer's total purchases of painting products. • Set all necessary variables. • Get customer's name. Ask if customer is a member of the shop o If yes, ask for customer's membership ID o If customer is a member, they will get 10% discount off the total price Get item code to purchase and quantity • Based on the item code, identify the item name and price. o If user enter invalid item code, set item name as “Invalid Code" and price is RM0.00 Calculate the payment for the product. • Calculate the total price. • Display the quantity, item name, and payment of the product. Repeat as long as user wish to purchase more item. • If user wish to stop purchase, calculate the total price after discount. • Display the total price, discount and total price after discount. • Refer to Sample Output 1 and Sample Output 2. b) Båsed on the description given in (a), write the pseudocode

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

Similar questions

Problem Statement for Stock Transaction Program George uses the services of a brokerage firm to buy and sell stocks. Each time he buys or sells a block of stocks, he must pay the brokerage firm a commission of 1.5% per share.Design a program that allows George to enter the number of shares in the block, the price per share when he bought the block and the price per share when he sold the block. The program should display the amount of money he paid to buy the stock and the amount of the commission. The amount of money he made when he sold the stock and the amount of the commission, the amount of profit (or loss) he madeafter paying for the purchase cost and both commissions. There are three user inputs for this problem: the number of shares in the block, the price per share when the block was bought, the price per share when the block was sold. There is one constant: the percentage of the commission (1.5%) The amount to buy the stock is: number of shares in block * purchase price per…
To help Lungi manage the blankets he has, he will need a proper report which provides him with the following information: ● Blanket description Blanket size (area of the blanket) Lungi's risk manager has advised him never to have more than 30 blankets in stock. Write the pseudocode for two modules which could be incorporated into the application planned for Lungi in Question 1. The first module must: a. Allow Lungi to enter the description and size of the blankets. b. Store the details entered in arrays. C. Provide Lungi with the option to view the list of blankets captured. If Lungi wishes to view the list of blankets, the contents of the arrays should be passed to another module. The second module should: a. Receive the arrays as arguments. b. Write the contents of the arrays to a text file that Lungi can print.
Change the order of the numbered Use Case Definition steps to correspond to the following problem definition: A college provides every incoming freshman with a gift card for a choice of two specialty restaurants within the cafeteria. Students should select one specialty restaurant they want. A program opens a window that displays each specialty restaurant one picture at a time when a student clicks the corresponding button. After making a decision, the student should click the Select Restaurant button. After selecting a restaurant, the student should exit the application.
View your last submission CHALLENGE ACTIVITY Write two statements to read in values for my_city followed by my_state. Do not provide a prompt. Assign log_entry with current_time, my_city, and my_state. Values should be separated by a space. Sample output for given program if my_city is Houston and my_state is Texas: 2014-07-26 02:12:18: Houston Texas Note: Do not write a prompt for the input values. Code writing challenge activity demo 3.1.3: Concatenating strings. 446244.3123728.qx3zqy7 UAWNH 1 current_time 2 3 4 Run = '2020-07-26 02:12:18:' Your solution goes here " 5 print(log_entry) View your last submission Feedback? 1 test passed All tests passed Feedback?
In order for a player to navigate your game, you will need to develop a function or functions using Python script. Your function or functions should do the following: Show the player the different commands they can enter (such as “go North”, “go West”, and “get [item Name]”). Show the player’s status by identifying the room they are currently in, showing a list of their inventory of items, and displaying the item in their current room. You could make these separate functions or part of a single function, depending on how you prefer to organize your code. Sample function showing the goal of the game and move commands def show_instructions(): #print a main menu and the commands print("Dragon Text Adventure Game") print("Collect 6 items to win the game, or be eaten by the dragon.") print("Move commands: go South, go North, go East, go West") print("Add to Inventory: get 'item name'") The blue image is an example of how the code should look. The map image is the map your code should…
Create the following variables that can be used to store values. Use the naming conventions as outlined in the Algorithms/Pseudocode Guidelines document in the course resources section of the course. 1. test grade for student test 2. total of all test grades added together 3. the average for the test grades Create an assignment statement that sets the value of the variable you created to store the value of all test grades added together to zero. You may refer to Table 6.1 in Chapter 6 for examples. Create an input statement to input the value for the first test grade for the variable you created. Create an algorithm that will obtain the test grade for three students, add the test grades together, calculate the average of the test grades, and output the average. Use a count-controlled loop to create the algorithm. Use the information from your answers to questions 3, 4, and 5 in the creation of your algorithm. Also use information and examples from Chapter 6…
Given str="University of applied Sciences and technology"; Enter the result of the following statement: document.write(str.toUpperCase());.................................. document.write (str.indexOf("applied")); ................................. document.write(str.substring(3,10)); ................................................... document.write(str.charAt(0)); .................................................
PLEASE USE FLOWGORITHM.Design a program for Jones College. The current tuition is $12,000 per year, and tuition is expected to increase by 5 percent each year. Display the tuition amount for each year over the next five years (use a looping structure) and also the total tuition at the end of the program. Hint: You will need to use two assignment statements for calculating purposes. One will be an accumulating total assignment statement.
Design a "Car Rental" Visual C# application, which allows the user to search for and book a car rental. It is required to create a database file that contains at least three related tables, the first of which contains the cars data with the data fields, such as: car ID car type car model quantity on stock cost per day Make up at least five records in the first table and save your database file in the default folder of your project. The second table should contain the customer information, such as: customer ID first name last name telephone number credit card data The third table should contain the bookings data, such as: booking ID car ID customer ID pick-up date drop-off date total cost Please note that you can create more tables as well as add more data fields, if necessary. Your program should contain multiple Windows forms as follows: The first form will enable the user to search for a car rental. If a car rental is selected, the second form may provide more into about the car that…
Instructions You are working as a computer programmer for a mortgage company that provides loans to consumers for residential housing. Your task is to create an application to be used by the loan officers of the company when presenting loan options to its customers. The application will be a mortgage calculator that determines a monthly payment for loans and produces an amortization schedule for the life of the loan. The company offers 10-, 15-, and 30-year fixed loans. Inputs The program should initially prompt the user (the loan officer) for the principal of the loan (i.e. the amount that is being borrowed). It should then ask him or her to enter an annual interest rate for the loan. The final input should be the number of years that the loan will be outstanding. Because the company only offers three different terms (10-, 15-, and 30-year loans), the program should ensure that no other terms are entered. Payment Calculator The formula to calculate the monthly payment for a fixed…
Instructions Assuming you are registered in a class with several activities/categories (quizzes, labs, homework, attendance, etc.), you would like to keep track of your grades throughout the quarter. For each category, you need to add your grade, e.g., for the labs you got 100 in lab 1, 95 in lab 2, etc. How are we going to store our grades for each category? Remember that in our main program, we keep the information for various grade categories. This information is stored as a list of lists, which can, for example, look like this: [["Lab", 35], ["Quiz", 35]] Each list that is contained in the main “database” (a list of lists) contains information about a category and its corresponding grade percentage. If for the labs, you got 100 in lab 1, 95 in lab 2, we can store this information for the “Lab” category as an additional list: ["Lab", 35, [100, 95]] This means that our database would then look like this (note the nesting of the grades): [["Lab", 35, [100, 95]], ["Quiz", 35]] In order…
Create flow chart to print the result of 25 students in a class. Assume that each student has 4 grades. Find the average of the grades. If it is greater than or equal to 50 then display the student is passed otherwise student is failed. Print the result and average for 25 students.