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

An agency called Resourcecover supplies part-time/temporary staff to hotels throughout Mauritius. The table shown in Figure 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for each employee. NIN contractNo HrsPerWeek empName HotelNo HotelLocation 125WD C1024 16 Samuel Н25 Grandbay Fody 142XA C1024 24 Dev Samy Н25 Grandbay 169YD C1025 28 Sara Ally H4 Tamarin 125WD C1025 16 Samuel Н4 Tamarin Fody Figure 1: Resourcecover i. The table shown in Figure 1 is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies. i. Describe and illustrate the process of normalising the table shown in Figure 1 to 3NF. State any assumptions you make about the data shown in this table.
Order Number: 5678 Customer Number: 9123 Customer Name: Thomas Customer Address: 51 Samora Machel Street City- Country: Durban, South Africa ProductNo A 123 B 234 C 345 Description A4 Paper Order Form Toner Staples Normal Form Quantity 100 200 1000 Date: 25/12/2020 Unit Price R1.00 R150.00 R5.00 1.1 Using normalization principles, depict the ONF, 1NF, 2nd NF and 3rd NF of the data above. Example: Below is an example of the table information converted to zero normal form, read chapter five in your module guide and convert the table to first, second and third normal form. The format of your answer must be as depicted below: • ORDER( order number, customer number, name, address, order date(product number, description, quantity, unit price))
TABLE 4-6 Parking Tickets at Millennium College Parking Ticket Table St ID L Name F Name Phone No St Lic Lic No Ticket # Date Code Fine 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/12 2 $25 16017 11/13/12 1 $15 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/12 $100 16293 11/18/12 1 $15 17892 12/13/12 2 $25 1. Convert to INF Relation 2. Draw dependency diagram showing all functional dependencies 3. Identify anomalies 4. Convert to 3NF Relations 5. Develop EER Diagram with appropriate cardinalities
Excel: Create a totalizer (function or formula in Excel) of the quantities of “ON” shares traded, that is, all those with “ON” regardless of the other term that accompanies them (as is the case with ON N1 or ON NM, for example) . Code Asset Type ABCB4 ABC BRASIL PN N2 EALT4 ACO ALTONA PN AELP3 AES ELPA ON TIET3 AES TIETE E ON N2 TIET4 AES TIETE E PN N2 TIET11 AES TIETE E UNT N2 BRGE8 ALFA CONSORC PND BRIV4 ALFA INVEST PN ALSC3 ALIANSCE ON NM ALPA3 ALPARGATAS ON N1
Use the university schema for the following questions student takes ID ID course id sec id name dept_name tot ged semester vear grade section course course id sec id department course id advisor title dept_name credits dept name s id semester Year building room number time slot id building budget time_slot time slot id day start time end time prereq instructor classroom couTse id grereg id ID building room_number name dept_name salary сараcity teaches ID course id sec id semester year Figure 2.9 Schema diagram for the university database. Use the online SQLite tool from db-book.com to write SQL statements for each of the questions below. Paste your solution SQL statement under each question and upload the document to Canvas. 1. Display the name and total institution credits taken (not tot_cred which includes transfer credits) of students that do not have an assigned advisor (across all years). a. Hint: link takes with courses and student, for students not in advisor, project the name…
Apply Normalization A table with the students and their grades in different topics. UnitID | StudentID | Date TutorID | Topic Room | Grade Book 5 U2 U1 U5 U4 St1 St1 St4 St2 St2 23.02.03 Tut1 18.11.02 Tut3 23.02.03 Tut1 05.05.03 Tut3 04.07.03 Tut5 GMT 629 Gln 631 5.1 4.7 GMT 629 4.3 PhF 632 AVQ 621 4.9 5.0 Deumlich Zehnder Deumlich TutEmail tut1@fhbb.ch tut3@fhbb.ch tut1@fhbb.ch Dümmlers tut3@fhbb.ch Swiss Topo tut5@fhbb.ch
ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear
PK Cus CODE PK INV NUMBER PK,FK1 INV NUMBER LINE NUMBER HEDenerates contains PK CUS LNAME CUs FNAME CUs INITIAL CUS AREACODE CUS PHONE CUS BALANCE FK1 CUS CODE INV DATE P CODE LINE UNITS LINE PRICE FK2 is found in VENDOR PRODUCT PK V CODE PK P CODE V NAME v CONTACT V AREACODE V PHONE V_STATE V ORDER P DESCRIPT P INDATE P_QOH P MIN P PRICE DISCOUNT FK1 V CODE upplies Write a SQL query to list the product code, vendor code, and vendor name for all products and includes those vendors with no matching products. Y CODE- PRODUCTY CODE
DDEPARTMENTS Columna Data Model IConstraints iGrants Istatutica Triogers irlahback Dependendes Detals i * a E X Sort. Fiter. DEPARTMENT... DEPARTHENT NAME 10 Administration () MANAGER_ JD ) LOCATIONUD 1700 200 20 Marketing 201 1800 30 Purchasing 40 Human Resources 114 1700 203 2400 50 Shapping 121 1500 €0 IT 103 1400 70 Public Relationa 204 2700 80 Sales 145 2500 90 Executive 100 1700 10 100 Finance 108 1700 11 110 Accounting 205 1700 12 120 Treasury (null) 1700 13 130 Corporate Tax (null) 1700 14 140 Control And Credit (null) 1700 15 150 Shareholder Services (null) 1700 16 160 Benefita (aull) 1700 17 170 Manufacturing (null) 1700 18 180 Construction (null) 1700 19 190 Contracting (null) 700ב 20 200 Operations 1700 (null) (null) 21 210 IT Support 1700 22 220 NOC (null) 1700 23 230 IT Helpdesk (null) 1700 Departments EMPLOYEE JD FIRST NAME LAST NAME EMAL 101 Neena 0 HIRE DATE ) 08D 21-SEP-89 AD VP 10 PHONE NUMBER SALARY COMMESSION PCT ) MANAGER D DEPARTMENT ID Kochhar SROCHHAR…
A local veterinarian hospital keeps record about the different pets they see over time, as well as information about the owners and treatment provided.The following tables represent a sample of the information recorded about owners, pets, and treatments. Owners LastName FirstName Phone Downs Marsha 555-537-8765 James Richard 555-537-7654 Frier Liz 555-537-6543 Pets PetName Type Breed Weight King Dog Std. Poodle 25.5 Teddy Cat Cashmere 10.5 Fido Dog Std. Poodle 28.5 King Horse Border Collie 25.0 Treatments Name Anesthesia Required Vaccine No Dental Yes Surgery Yes A veterinarian hospital wants to set up a data warehouse containing various information about the business. One section of this data warehouse should focus on recording information related to each pet visit to the hospital. For each of the visit, it is essential to record the various information…
SAS PROGRAMMING Variable STUDENT_ID SCHOOL Label Student's identification number School (1 = SMK Puteri, 2 = SMK Cabang Tiga, 3 = SMK Dato' Harun) Mark for first round Mark for second round Mark for third round M1 M2 M3 Status for round 1 Status for round 2 Status for round 3 S1 S2 S3 Obs STUDENT_ID SCHOOL M1 M2 M3 S1 S2 53 Average 1 STTO01 85 80 83 Passed Passed Passed 82.0007 1 2 STTO02 1 84 77 50 53 Passed Failed 75 74 Passed Passed Passed 77.0007 3 STTO03 Passed 02.0000 4 STTO04 2 80 80 95 Passed Passed Passed 85.0000 5 STTO05 6 STTO08 7 STO07 8 STTO08 9 STTO00 2 69 55 00 Failed Failed Passed 61.3333 2 07 01 Failed Passed Passed 85.6087 08 71 70 Failed 3 81 80 0 Passed Passed Passed 83.007 3 72 04 01 Passed Passed Passed 85.0007 Passed Passed 69.0000 The winner of the Mathematic Competition is the one who passed all three rounds and obtain the highest average mark. Display the data set with the winner appears on top.
Load the given data set into Google Colab python 1. In USD, find the average salary of Data Scientists as well as the standard deviation. 2. List each unique Job Title 3. For each unique Job Title, find their average salary (USD) and standard deviations. https://uc-bcf.instructure.com/courses/28339/files/5680123?verifier=fXym8nGyMe7CmvKYy7QmRDfcunF4DZwhuqakH1rL&wrap=1