The domestic tariff charged by Sabah Electricity Sdn Bhd (SESB) is given in Table 1. Based on the tariff, write a C++ program that can do the following: a. Tell the user to input the monthly usage (in kWh) from January to December. b. Calculate the consumption, discount, tax, and bill in RM for each month. - For consumption of less than or equal to RM600 per month, a 10% discount is given. For consumption of more than RM600 per month, a 6% service tax is imposed. c. Display the output as depicted in Figure 1. Format the values to two decimal points. Table 1 Tariff Category For the first 100 (1-100kWh) per month Unit Rates Sen/kWh 17.5 Sen/kWh Sen/kWh For the next 100 (101-200kWh) per month 18.5 For the next 100 (201-300kWh) per month 33.0 For the next 200 (301-500kWh) per month For the next 500 (501-1000kWh) per month Sen/kWh 44.5 Sen/kWh 45.0 For the next kWh (1001kWh onwards) per month Sen/kWh 47.0

Determine the kind of books in the library's current collection. Each category should include just a single entry.

Question 20 Unknown value can be represented in a table as O NULL O Zero O Unknown ΝΑ

Enter all of the various kinds of numerical information. In SQL

Table EMP Column name Column type Integer Up to 10 characters Integer Integer Example entry 7369 Description Employee ID number Employee surname ΕMPNO ENAME SMITH Employee's job title No ID no. of employee's manager Date employment started Monthly salary JOBNO 10 MGR 7566 HIREDATE Date 17/12/1980 SAL Integer 1600 Table JOB Column type Integer Up to 15 Column name Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN characters c) Write SQL statements to define referential integrity constraints on EMP table and give SQL examples to describe the different ways that referential integrity constraints can cause the database system to behave when a user attempts to update a table row. (Maximum 300 words).

Define the following aggregate functions in an SQL Query. COUNT, MIN, MAX, SUM, AVG

For questions 4 and 5, use the following order for the rows in your truth tables.P QT TT FF TF FP Q RT T TT T FT F TT F FF T TF T FF F TF F F4. (8 marks) Construct truth tables for the following statement forms.In your truth table, make sure that you include a column for each intermediate expression that you evaluate on your way to your final answer.(a) (P ↔ ¬Q) ∧ (P ↔ Q)(b) (¬P ∨ (¬Q ∨ ¬R)) ∨ (P ∧ Q)

Rank in order to make it calculate standard deviation

SQL DML/DDL There are five tables describing employees of a company, departments, buildings, which department(s) an employee works in (and a percentage of the time for each), and in which building an employee works (an employee may have more than one office). The primary key of each table is the attribute(s) in capitals and underlined. The foreign keys are in italics. Other attributes are not necessarily unique.Employee (EID, Ename, Salary, Start_Date, End_Date)Building (BID, Bname, Address)Department (DID, Dname, Annual_Budget)In_Department (EID, DID, Percentage_Time)In_Building (EID, BID)Write the SQL statements for the following.1. Find the names of Departments where NO employees work. 2. For employees who are still working in the company, end date has no value (empty). For those who have left the company and have end date values, show their names and the duration of their employment in years.  3. Find the names of buildings where more than 50 employees work.  4. The tables have…

Looking Up Data- INDEX () & MATCH() Which of the following statements describes how the INDEX) and MATCH() functions are combined to lookup data?   A) MATCH() is used within the INDEX() function to return the relative position of the data in the lookup table B) INDEX) is used within the MATCH() function to return the relative position of the data in the lookup table C) MATCH() is used to match values from the lookup table and the source table, INDEX() returns the index of these values D) INDEX calculates the relative position of the data in the source table and returns values for MATCH() to lookup