Assignment 2. ELECTRICITY BILL CALCULATOR FOR DOMESTIC DWELLINGElectrical Unit Tariff blocksUnitRMFixed ChargeFirst Unit SlabNext Unit2000.218200RMSlab1000.334Surcharge0.00RM/UnitNext UnitSlab3000.516Tax.Charge6%Next UnitSlab3000.546Meter Charge200RMLast Unit Slab1000.571ITEMRATINGSNUMBERno. hours/dayunit consumed in kwhLED816CFL20W516REF200W124FAN80W624total meter reading for a month190Monthly Bill540final bill1 Calculate the electricity bill as per the table given2 nested if formula has to be used to apply various conditions for all tariff blocks3 for two tariff blocks formula is already applied so you have to do for the remaining tariff blockIF(F18<=100,F18*2.7,(100*2.7)+(F18-100)*3)

Here, we have to calculate the electricity bill.

Assignment 2. ELECTRICITY BILL CALCULATOR FOR DOMESTIC DWELLING Electrical Unit Tariff blocks Unit RM First Unit Slab 200 0.218 Fixed Charge 200 RM Next Unit Slab Next Unit Slab Next Unit 100 0.334 Surcharge 0.00 RM/Unit 300 0.516 Tax.Charge 6 % Slab 300 0.546 Meter Charge 200 RM Last Unit Slab 100 0.571 ITEM RATINGS NUMBER no. hours/day unit consumed in kwh LED 8 16 CEL 20w 5 16 REF 200W 24 FAN 80W 6. 24 total meter reading for a month 190 Monthly Bill 540 final bill 1 Calculate the electricity bill as per the table given 2 nested if formula has to be used to apply various conditions for all tariff blocks 3 for two tariff blocks formula is already applied so you have to do for the remaining tariff block IF(F18<=100,F18*2.7,(100*2.7)+(F18-100)*3)

Assignment 2. ELECTRICITY BILL CALCULATOR FOR DOMESTIC DWELLING Electrical Unit Tariff blocks Unit RM First Unit Slab 200 0.218 Fixed Charge 200 RM Next Unit Slab Next Unit Slab Next Unit 100 0.334 Surcharge 0.00 RM/Unit 300 0.516 Tax.Charge 6 % Slab 300 0.546 Meter Charge 200 RM Last Unit Slab 100 0.571 ITEM RATINGS NUMBER no. hours/day unit consumed in kwh LED 8 16 CEL 20w 5 16 REF 200W 24 FAN 80W 6. 24 total meter reading for a month 190 Monthly Bill 540 final bill 1 Calculate the electricity bill as per the table given 2 nested if formula has to be used to apply various conditions for all tariff blocks 3 for two tariff blocks formula is already applied so you have to do for the remaining tariff block IF(F18<=100,F182.7,(1002.7)+(F18-100)*3)

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

FIRST QUESTION : An embassy records details of interviews of visa applicants in the table below. Interviews are conducted by members of staff in some of the embassy rooms. In any given day, a member of staff tends to use the same room throughout that day. An applicant cannot have two interviews in the same day : R : applicantNo interviewDate interviewTime staffNo roomNo AP1 13.5.2016 10:30 S5 R101 AP2 13.5.2016 12:00 S5 R101 AP3 13.5.2016 12:00 S9 R200 AP2 22.9.2016 10:30 S5 R200 - List all possible candidate keys for the above relation :
auto workshop is a vehicle service center located in the city of Muscat, which provides vehicle maintenance/repair services. The charges of vehicle maintenance/repair are based on the type of the service. Details of charges are as follow: Basic Tuning: 50 OMR Software Re-installation: 60 OMR Parts Replacement: 100 OMR Body Paint: 120 OMR The workshop offers 10% discounts to the customers who have membership of the service center. You are required to draw a flow chart diagram and write a C++ computer program that takes customer’s name, car plate number, membership status(Y/N) and the required service (mentioned above). The program outputs the input data and maintenance charges based on the service provided by the service center with discount, if applies.
It is possible to differentiate scalar functions, aggregate functions, and table-valued functions.
Look up student MAJOR and ROOM information based on the student NAME. Enter formula into B2. 1 NAME MAJOR ROOM 2 58 3 4 NAME MAJOR ROOM 5 $1 CIS DBH 6 S2 7 3 A/F DBH A/F DBH 8 $4 мом SCI 9 S5 мом DBH 10 56 CIS SCI 11 S7 CIS DBH 12 S8 A/F 13 S9 мом 14 S10 CIS Size Color Price Item T. 15 Size L T M 16 Color R. 17 Price 28 H. 29 30 XL R. 18
4. Find all instructors in Finance department who have taught some course in 2008. 5. Find all students from Physics department who took course 'CS-319|* .
Calculate the cumulative values of $100 invested in AAPL at the close of trading on the last trading day in December of 1996 through the close of trading on the last trading day in February of 2022. Store these cumulative values as a series named ans 5. I 1: ans 5= I 1: grader.check("q5")
- Find the employee in each department who makes the highest salary in their departments
6. An apartment owner rents one-bedroom apartments for $575 and two-bedroom apartments for $650. A total of 13 apartments rent for $8150 a month. How many of each type does she have?
Answer in python please. Include bounds and risks.
3. You are asked to calculate the weekly take home pay for a group of employees at your company. The employees in this group have a wage rate of 35USD per hour and 65USD per hour when they work overtime. The following table list the hours work by the employees. Employee ID Regular hours Overtime hours 87 40 3 43 40 8 99 32 0 5 40 15