12:11ul 4Ghttps://moodle.nct.e...2 من 4Program 1Al Basmath Hospital is the largest healthcare group in Oman. The group spread his wings acrossOman. They want to calculate discount and final bill amount from the patient's medical billamount. Write a Python program to ask the user to input the patient's medical bill amount andage for 10 Patients and store them in two different lists. The sample input data is shown below.Bill amount- 100, 75,110, 300, 150, 400, 200,100,140,100]60,15,65,34, 25, 22,15,65,73,37]Age=Your program has to do the following tasks.a) Calculate and display the discount for each patient according to the following table andstore it in a List.Bill AmountDiscountAgeAge >=60Bill Amount < 505% of Bill Amount50 S Bill Amount < 150150 S Bill Amount10% of Bill Amount15% of Bill AmountAge < 60Bill Amount < 1002% of Bill Amount5% of Bill Amount100 s Bill Amountb) Calculate and display the final bill amount after deducting discount from bill amount foreach patient and store it in a list according to the following formulaFinal Bill Amount =Bill Amount- discountc) Assume that all the patients are having medical insurance facility. So that you calculate howmuch insurance company will pay for each patient based on the criteria given in the belowtable. Store insurance company payment in a list.Final Bill Amount Insurance Company PaymentFinal Bill Amount < 20090% of Final Bill amount200 S Final Bill Amount < 40080 % of Final Bill amount400 SFinal Bill Amount70% of Final Bill amountd) Calculate and display the amount to be paid by each patient after deducting insurancecompany payment from final bill amount. Store it in a list according to the followingformulaAmount to be paid= Final Bill Amount- Insurance company paymente) Calculate and display sum of final bill amount of all the patients.f) Calculate and display average final bill amount of all patients whose age is >= 60.8) Calculate and display number of patients whose age is less than 60.h) Calculate and display the maximum final bill amount.All amounts should be displayed with three decimal places. Include the following comments atthe beginning of your code.# File Name# Student Id# Student Name: : : OmantelgameفتحEducational games Oالمزیدالقوائمالملفاتالمصادر

Add your Id and name inside <> at line 2 and line 3

d) Calculate and display the amount to be paid by each patient after deducting insurance company payment from final bill amount. Store it in a list according to the following formula Amount to be paid= Final Bil1 Amount- Insurance company payment e) Calculate and display sum of final bill amount of all the patients. f) Calculate and display average final bill amount of all patients whose age is >= 60. g) Calculate and display number of patients whose age is less than 60. h) Calculate and display the maximum final bill amount. All amounts should be displayed with three decimal places. Include the following comments at the beginning of your code.

d) Calculate and display the amount to be paid by each patient after deducting insurance company payment from final bill amount. Store it in a list according to the following formula Amount to be paid= Final Bil1 Amount- Insurance company payment e) Calculate and display sum of final bill amount of all the patients. f) Calculate and display average final bill amount of all patients whose age is >= 60. g) Calculate and display number of patients whose age is less than 60. h) Calculate and display the maximum final bill amount. All amounts should be displayed with three decimal places. Include the following comments at the beginning of your code.

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

CUSTOMER (cid, name, phone_number, address) LOCATION (lid. title, city, country) TRIP (tid, lid, trip_date, duration_in_days, price) BOOKING (cid, tid) Find the trip bookings of "Joe Smith". Your answer: O (ti>|3i( € Booking A3ci( € Customer An "Joe Smith" O ti>|3 ci ( € Booking A3 ci, n ( E Customer An-"Joe Smith" ) o ti>|3 ci ( € Booking A 3n, pn, a ( € Customer An- "Joe Smith" )) (|3 ci, ti ( € Booking A 3 ei, n, pn, a ( €E Customer An-"Joe Smith" ))
Which function to be used to calculate the total customers who are above 35 years of age and earning more than 10 lacs per year. a. countif() b. sumifs() c. sumif() d. countifs()
6. SELECT e.Last_Name, m.Last_Name AS "Manager Name", e.Salary*12 AS "Annual Salary", 1.City FROM employees e JOIN employees m ON e.Manager_id = m.Employee_Id JOIN departments d ON d.Department_id = e.Department_Id JOIN locations 1 ON 1.Location_id = d.Location_id WHERE 1.City = "California"
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 30 $215 31 60 $195 61 ཙཙ 120 $175 121 and up $155 Click on the datafile logo to reference the data. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 30 $215 31 60 $195 61 120 $175 121 and up $155 172 12
Please provide examples of how calls and returns work together.
Subject SubjectNO Student SUB_Name STD_Name Pre SUB Specialization STD NO Registration SubjectNO STD NO REG date Q1) Write procedure to print the registration dates for all subjects that are registered by student whose name "ALI". h 17
Please provide examples of how calls and returns work together.
Minimize the following DFA: 0 1 →90 q1 90 91 qo 92 92 93 91 *q3 93 90 94 93 95 95 96 q4 96 95 96 q7 96 q3 Hint: Use the "table filling method" for minimizing your DFA (if needed).
3. MOH codes are a 5-digit combination of alpha and digit numeric and an alpha suffix Create a table showing the Suffix (Alpha) that are going to be included in coding of diagmostic test Be sure to include two columns in your table: Alpha suffix and code definition
Which of the statements below is correct? (See the tables in the JustLee Books database for further information.) Only numeric data may be utilized with the MIN function. Only date values may be utilized with the MAX function. Only numeric data may be utilized with the AVG function. A nested function cannot contain the SUM function.
(1) Prompt the user for a title for data. Output the title. Ex: Enter a title for the data: Number of Novels Authored You entered: Number of Novels Authored (2) Prompt the user for the headers of two columns of a table. Output the column headers. Ex: Enter the column 1 header: Author name You entered: Author name Enter the column 2 header: Number of novels You entered: Number of novels (3) Prompt the user for data points. Data points must be in this format: string, int. Store the information before the comma into a string variable and the information after the comma into an integer. The user will enter -1 when they have finished entering data points. Output the data points. Store the string components of the data points in an ArrayList of strings. Store the integer components of the data points in a second ArrayList of integers. Ex: Enter a data point (-1 to stop input): Jane Austen, 6 Data string: Jane Austen Data integer: 6 (4) Perform error checking for the data point entries. If…
Customer (CID, CName, Street, City, State, Gender)Agent (AgentID, GName, Position, Salary, Gender, BranchNo)Invoice(InvoiceNo, CID, AgentID, Product, Quantity, Total_amt) List the name of agents, position and salary for all agents that begin with ‘Sales’ in their title position and with salary more than the average salary. Example of titles with ‘Sales’ are ‘Sales Executive’, ‘Sales Manager’, ‘Salesman’ and many other titles. Sort the list by name in alphabetical order