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

Related questions

Q: Model Vin Price VEHICLE CAR TRUCK SUV Engine_size Tonnage No_seats VEHICLE Vin price Model CAR Vin…

A: Map this schema to a set of relationships. 1) CAR entity relationship: Merge the SALES…

Q: Use the averageif function to calculate the average number of girs and average number of boys.

A: The AVERAGEIF function in Excel is a statistical function that calculates the average of selected…

Q: Use the given data to classify the record below using the k-NN algorithm for k=1 to 5. Loan…

A: The python code for the model is given below with self-explanatory embedded comments:1import pandas…

Q: c) Write a query to display the patron ID and the average number of days that patron keeps books…

A: Algorithm:Select Data: Start by selecting the necessary data from the PATRON and CHECKOUT…

Q: Calculate the profit (profit) as the retail price minus the wholesale price

A: Note: Since programming language is not mentioned in the question, we will answer this program in…

Q: The State of New York certifies firefighters throughout the state and must keep track of all of…

A: Given: The State of New York certifies firefighters throughout the state and must keep track of all…

Q: Zsnd

A: Step 1:As you can see in the table, it is $69,000. Step 2:The federal government of the United…

Q: se the given data to classify the record below using the k-NN algorithm for k=1 to 5. Loan…

A: To classify the new record for each value of k using the k-NN algorithm, we need to calculate the…

Q: Find the staff name who has the maximum salary for each branch Find the staff name who has the…

A: SQL is the Structured Query Language, which is the computer language for storing, manipulating and…

Q: According to the U.S. Census Bureau, the 10 largest American cities (by population) in 2000 were as…

A: Java program that defines an arrays that holds this information about locations and population and…

Q: Apply normalization of the following data table showing all required details patient patient patient…

Q: The State of New York certifies firefighters through- out the state and must keep track of all of…

A: Introduction: A relational database model provides a way of organizing related data and information…

Q: Use the given data to classify the record below using the k-NN algorithm for k=1 to 5. Loan…

A: Based on the information you provided, we can classify the record with the given loan purpose,…

Q: Muscat Special Cleaning Service company has been providing building maintenance and cleaning service…

A: ALGORITHM:- 1. Take input details from the user for 5 houses. 2. Calculate the total maintainence…

Q: a,b a b qo q1 q2

Q: 2. Explain why the data in the table is not in Third Normal Form. • For this question you cannot say…

A: Answer 2. A table is considered to be in third normal form if it looks like this:If it's in the…

Q: Find all instructors in Finance department who have taught some course in 2008. in MySQL Find…

A: Given table schema:instructor (ID, name, dept_name, salary)student (ID, name, dept_name,…

Q: -6 Refer to the given table. Salesperson Number 137 137 137 106 106 106 106 204 204 361 361 361…

A: First Normal Form (1NF) is a property of a relation in a relational database. A relation is in first…

Concept explainers

jQuery and JavaScript

JavaScript is a client-side programming language used to create dynamic web pages and animations. It uses just-in-time compilation which means it is read line-by-line, checked for correctness of syntax and executed immediately.

Question

Assignment 2. ELECTRICITY BILL CALCULATOR FOR DOMESTIC DWELLING
Electrical Unit Tariff blocks
Unit
RM
Fixed Charge
First Unit Slab
Next Unit
200
0.218
200
RM
Slab
100
0.334
Surcharge
0.00
RM/Unit
Next Unit
Slab
300
0.516
Tax.Charge
6
%
Next Unit
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
CFL
20W
5
16
REF
200W
1
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)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2- Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 215 84 2002 215 HS 1991 215 JC 1994 216 B4 1989 216 CDP 2004 216 CNP 2002 216 HS 1985 217 HS 1992 217 JC 2000 218 B4 1990 218 CDP 2000 218 CNP 2005 218 HS 1984 218 M2 1995 TABLE EMPLOYEE EDUCATION Table name: EDUCATION EDU_CODE EDU_DESCRIPTION a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. EMP_EDUC 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma PRIMARY KEY(s) Junior College degree Master's degree FOREIGN KEY(s)
Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degree
A B 1 Given Information: 2 3 4 5 6 7 8 9 Decision Variable: 10 11 12 Uncertain Variable: 13 Daily Demand 14 15 16 17 Copier Rental Store Cost Price C D Variable Cost Max Production per Copier Days Business is Open # of Copiers to Rent Workspace: Calculate Annual Copies Sold Maximum Annual Production Estimated Annual Demand Actual Amount of Copies Sold 18 19 20 Objective: Calculate Annual Profits 21 Revenue E $5,000.00 per year $4,800.00 per year $0.10 per copy $0.03 per copy 100000 copies 365 days F 3 copiers 1500 copies per day 300,000 544500 G H This is a very problem. You how much th based on dem
in a shop ,there are 10 employee and 20 kinds of goods，goods id between 1-20 EMPLOYEE id first name last name gender 10001, 'Tom', 'Brown', 'F'10002, 'Elizabeth', 'Tremblay', 'F'10003, 'Gladys', 'Julie', 'F10004, 'John', 'Taylor', 'M10005, 'Amelia', 'Smith'10006, 'Logan', 'Katherine'10007, 'Leo', 'Brown'10007, 'Lem', 'Thompson'10009, 'Tom' 'Smith'10010, 'Emma', 'Campbell' ------------ and I want to add a name library in it ,like this how could i create a HTML file ,with will randomly create customers with these employee . there is a start button on the page . press "start "bottom ,and it will It will randomly match 10 items, customers, and goods, display goods id ,customername and gender ,employer name , id and gender . how to do such a page ?
Use the table below to find the output PRODUCT_ID PRODUCT_NAME BRAND UNIT PRICE SUPPLIER_ID CATEGORY_ID 113 Note Book Atlas Pieces 5 S1 C1 114 Sticky Note Fanta Воx 4.3 S3 C1 117 Paper Clips Nizwa Packet .5 S4 C1 111 A4 Paper Double A Ream 2 S1 C2 112 Plastic envelope Atlas Packet 1.7 S2 C1 115 White Board Marker Pentel Вох 2.2 S3 C2 116 Stapler Small Nizwa Pieces S4 C1 Write the OUTPUT of the following SQL Statement: 1- SELECT brand FROM products WHERE price = 2.2; 2 - SELECT product_name FROM products WHERE product_name like "%Ma%' 3 - SELECT price * 2 FROM products WHERE product_id = 111 4 - SELECT unit FROM products WHERE supplier_id = 'S3' and Category_id ='C1'
LUNCH SALES Days of Week Lunch Sold Qty Unit Price Total Sold Monday Chicken 25 15.00 $ 375.00 Monday Pork 15 20.00 $ 300.00 Monday Fish 20 25.00 $ 500.00 Tuesday Mutton 15 23.00 $ 345.00 Tuesday Fish 30 25.00 $ 750.00 Wednesday Chicken 55 15.00 $ 825.00 Thursday Turkey 45 18.00 $ 810.00 Friday Turkey 60 18.00 $ 1,080.00 Saturday Chicken 15 15.00 $ 225.00 Saturday Mutton 45 23.00 $ 1,035.00 Saturday Fish 55 25.00 $ 1,375.00 Saturday Turkey 50 18.00 $ 900.00 Saturday Pork 20 20.00 $ 400.00 Sunday Fish 55 25.00 $ 1,375.00 Sunday Mutton 35 23.00 $ 805.00 Sunday Chicken 30 15.00 $ 450.00 #NAME? Fruit # of Days Sold Total Sold Sum of Total Sold Chicken Mutton Fish Turkey Pork Instructions: (Fill in the columns of the "Calculations Table") 1.…
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
Is the following table in First Normal Form? If so, how would you get it into first normal form. SalesPerson/Product table Order Number Product Number Salesperson ID SalesPerson Name Commission Percentage Year of Hire Department Number Department Name Product Name Unit Price Quantity 137 19440 15 Baker 10 1995 73 Commercial Sales Hammer 17.50 473 24013 Saw 26.25 170 26722 Pliers 11.50 688 186 16386 7 Adams 15 2001 59 Home Sales Wrench 12.95 1745 19440 Hammer 17.50 2529
Major Vegetables and Root Crops Quarterly Bulletin, April-June 2023 September 2023 Production of cabbage during the second quarter of 2023 was registered at 23.33 thousand metric tons. This represents a decrease of -4.5 percent from the 24.44 thousand metric tons recorded output in the same quarter of 2022. CAR was the leading producer of cabbage with 18.50 thousand metric tons or 79.3 percent share to the total production during the quarter. This was followed by Central Visayas with 1.38 thousand metric tons or 5.9 percent share. The January to June 2023 area harvested for cabbage was estimated at 2.94 thousand hectares. This was 0.6 percent higher than the same period of previous year’s level of 2.92 thousand hectares. what is the cause of the decrease in production? what is the critical baguio vegetable production has decreased these past few years?
Use the given data to classify the record below using the k-NN algorithm for k = 1 to 5. Loan Purpose Checking Repairs Savings Months Customer Employed Months 0 900 25 4 Click the icon to view the table of classified records. D Complete the table below for the nearest neighbors and for the classification of the new record for each value of k. k Distance Classification 1 2 3 4 5 (Round to four decimal places as needed.)
A plan view sketch of a benchmark leveling run is shown below. Along each line representing a sight is the value of the rod reading for that sight. The numbering of TPs shows the direction of the level run. Place the data in the form of field notes. Assuming that the average length of each BS and FS is 125 ft, determine the order of leveling (accuracy) of the survey BM 14 48.292 7.485 不 10.260 T 2.641 1.485 TP 1 TP 3 3.982 π 2.247 8.643 不 TP 2 8.636 9.829 T 7.642 BM