Muscat Special Cleaning Service company has been providing building maintenance and cleaning service for their customers in Muscat. The company decides the monthly maintenance cost for their customers based on the total square foot of the building. The cost is shown in the following table. Square Foot of the building | Maintenance Cost >= 15000 100 Rials per month < 15000 40 Rials per month The total maintenance cost per month is calculated based on the maintenance cost of the building and material cost based on the formula shown below: Total maintenance cost = maintenance cost + material cost Write a Python program named buildingservice.py that should take two inputs: the square foot of the building and material cost for 5 customer's buildings and store them in two different lists. The program has to calculate the total maintenance cost for each customer building and store them in a list. Finally, your program has to display total maintenance cost for 5 customers and maximum total maintenance cost.

Muscat Special Cleaning Service company has been providing building maintenance and cleaning service for their customers in Muscat. The company decides the monthly maintenance cost for their customers based on the total square foot of the building. The cost is shown in the following table. Square Foot of the building | Maintenance Cost >= 15000 100 Rials per month < 15000 40 Rials per month The total maintenance cost per month is calculated based on the maintenance cost of the building and material cost based on the formula shown below: Total maintenance cost = maintenance cost + material cost Write a Python program named buildingservice.py that should take two inputs: the square foot of the building and material cost for 5 customer's buildings and store them in two different lists. The program has to calculate the total maintenance cost for each customer building and store them in a list. Finally, your program has to display total maintenance cost for 5 customers and maximum total maintenance cost.

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

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 -…
You are the manager of a Best Buy and you would like to see how much profit you made from your store over the past three months. Below is a worksheet which shows the 'Total Sales' in October 2019, November 2019, and December 2019. A 1 2 3 4 5 October 2019 November 2019 December 2019 2019 TOTAL SALES B DVD Sales 516 439 400 C CD Sales 355 750 751 1355 1856 D Record Sales 50 60 70 180 E TOTAL SALES Write a formula for cell E2 using the SUM function to calculate the TOTAL (DVD Sales, CD Sales, and Record Sales) for October 2019. When creating the formula, keep in mind that it will be copied to cells E3, E4, and E5 without modification. Now that you have written à formula for E2, write the formulas for E3, E4, and E5. 4
Determine where you want to reside if you want to live in an earthquake-prone area using the earthquake hazard map.
if department < 3 then raise = SMALL_RAISE else if department <5 then raise = MEDIUM_RAISE else raise = BIG_RAISE endif endif endif In the following pseudocode, what percentage raise will an employee in Department 5 receive?
Vacation days are based on status. Using the information in the lower table below, do a lookup in the upper table determine the amount of vacation time earned by each employee. Status Vacation Time Earned Full TIme 10 Part Time 7 Contract 0 Employees Status Vacation TIme Earned John Contract Jane Part Time Al Full TIme
SQL code for: (1) Hint: A NULL in the hours column should be considered as zero hours. Find the ssn, lname, and the total number of hours worked on projects for every employee whose total is less than 40 hours. Sort the result by lname */ /* (2) For every project that has more than 2 employees working on it: Find the project number, project name, number of employees working on it, and the total number of hours worked by all employees on that project. Sort the results by project number. /* (3) For every employee who has the highest salary in their department: Find the dno, ssn, lname, and salary. Sort the results by department number. */ /* (4) For every employee who does not work on any project that is located in Houston: Find the ssn and lname. Sort the results by lname /* (5) Hint: This is a DIVISION query For every employee who works on every project that is located in Stafford: Find the ssn and lname. Sort the results by lname */
Sherry’s Meats, a regional meat wholesaler and retailer, needs to collect up-to-date information on how much of each meat product it has in each store. It will then use that information to schedule deliveries from its central warehouse. Currently, customers entering the store fill out a detailed form specifying their individual orders. The form lists over 150 items; it includes meat and meat products available in different amounts. At the end of the day, between 250 and 400 customer orders are tabulated and deducted from the store’s inventory. Then the office worker in each store phones in an order for the next day. Store employees have a difficult time tabulating sale because of the mistakes customers make in filling out their forms. 1. What are the requirements of the clients? 2. Design and draw a specialty form of the same size that will meet the needs of Sherry’s customers, office workers, and warehouse workers. (Design plan for web flow) 3. Design a Web page used by a customer…
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
A social recreation club has a system to keep track of club members, committees and activities. Each club has a registration number and a title. Several members form committee. Members are male and females. Each committee has a name, a unique number and a date, which the committee has formed. The system stores the members' unique identification number, name, address, gender, birth date and club joining date. The club forms committees for different activities. A committee controls and organizes a number of activities, each of which has a unique name, a unique number and description of the event. An event has event ID and description of the event. An activity may consist of several events. Committee publishes many online advertisements about the activities. Advertisement details are ID and a title. Draw the ER diagram to represent the above scenario
Give a brief analysis of the data found in chart in words
Evaluate the following sum: 10 10 k=-10
Make a change, Total = 9 Available Coin Set = { 2, 3, 5 } using dynamic approach