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

Please help
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 -…
4) Write dynamic SQL statements: a) Based on controls on the main search screen, write SQL statement to search for employees who is hired in the year as specified by dtHireDate b) Based on controls on the main search screen, write SQL statement to search for employees who is the manager of the department specified by the cboDept c) Based on controls on the main search screen, write SQL statement to search for employees whose manager is specified by the txtEname box d) Assume FrmAddNewEmp has a global variable intEid that is 0 for a new new employee to be added and a valid empno for an existing employee whose data to be changed. Based on FrmAddNewEmp, write SQL statement to update an employee based on the values in the text boxes.
The SUMPRODUCT function calculates the total of the cells that satisfy a given condition True False
Question 26 The image below shows an example of a PROGRAM A) Query Bi Form () Report (D) Table
Computer Science please use excel vba to show code
Instructions: Circle T if the statement is true, F if the statement is false, or write the best answer in the space provided. T F Normalization is used to minimize data redundancy.
Use an IF function to determine if the month in the employee's birth date in Cell C2 matches the value in Cell X1.
None
Given the following table: Student ( id, first_name, last_name, address, program, phone), which of the following statements will list the number of students who are in IT program? a. select max(*) from student where program = 'IT'; b. select sum(*) from student where program = 'IT'; c. select count(*) from student where program = 'IT'; d. select count(program) from student where program = 'IT'; One of the following is not directly supported in PL/SQL blocks a. delete b. alter c. update d. insert Which of the following is not a correct variable declaration in PL/SQL? a. college varchar2(20) ; b. college varchar2(20) = 'Sur' c. college varchar2(20) := 'Sur'; d. college varchar2(20) not null; In handling foreign key violations, the option to reject if the row is referenced in another table is .... a. Cascade b. Set null c. set default d.…
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" ))
Question 29 4 pts Write a Racket function, bmi, that will accept 2 parameters to calculate your body mass index: weight (in pounds) height (in inches) weight 703 height The formula is: bmi Edit Format Table