PRACTICAL EXERCISE 1,3Using the information given in the table below, calculate the total amountpayable by the company to the employees using a formula.AServices Company LtdOvertime DetailsDateNameHours WorkedRateAmount26-Nov70350.00KennedyKennedy4526-Nov5100500.006.26-Nov100500.00MaryLewis26-Nov4100400.00JudyKennedyLewis30-Nov3100300.006.30-Nov6.70420.001030-Nov100500.001130-NovKennedyJudy470280.001230-Nov100500.001330-NovLewis100500.001402-DecJudy470280.0015Total Amount

Answered: Image /qna-images/answer/9ab1c1bd-5ba0-4554-b9fc-d005b1a3ce20.jpg

Using the information given in the table below, calculate the total amount payable by the company to the employees using a formula. B 1 Services Company Ltd Overtime Details 3. Date Name Hours Worked Rate Amount 70 350.00 Kennedy Kennedy 4. 26-Nov 5. 26-Nov 100 500.00 6. 26-Nov Mary 5 100 500.00 26-Nov Lewis 4 100 400.00 Judy Kennedy Lewis 30-Nov 100 300.00 30-Nov 6. 70 420.00 10 30-Nov 100 500.00 11 30-Nov Kennedy Judy Lewis 4 70 280.00 12 30-Nov 100 500.00 13 30-Nov 5 100 500.00 02-Dec Judy 4 70 280.00 15 Total Amount 49 00 M45

Using the information given in the table below, calculate the total amount payable by the company to the employees using a formula. B 1 Services Company Ltd Overtime Details 3. Date Name Hours Worked Rate Amount 70 350.00 Kennedy Kennedy 4. 26-Nov 5. 26-Nov 100 500.00 6. 26-Nov Mary 5 100 500.00 26-Nov Lewis 4 100 400.00 Judy Kennedy Lewis 30-Nov 100 300.00 30-Nov 6. 70 420.00 10 30-Nov 100 500.00 11 30-Nov Kennedy Judy Lewis 4 70 280.00 12 30-Nov 100 500.00 13 30-Nov 5 100 500.00 02-Dec Judy 4 70 280.00 15 Total Amount 49 00 M45

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: List the years and their total gross earnings (sum of earnings per year), but do not include gross…

A: ANSWER:-

Q: During the month of January, an employer incurred the following payroll taxes: FICA Social Security…

A: Debit Payroll Tax Expense: $819 Credit FICA Social Security Taxes Payable: $372 Credit FICA…

Q: Find the numbers that has not been used as DEPTNO in the DEPT table.

A: you can use this query

Q: In how many ways can a 16-person club select a president, vice-president, and secretary from among…

A: There are 16 people to choose.in that 3 distinct persons to be selected.

Q: Show all female’s first names and their salary. Show the branchno that has a supervisor whose…

A: Relational database is a type of database which stores and provides the access to data which are…

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: 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: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition. student…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Find the listing of customers who did not make purchases during the invoicing period. Sort the…

A: SQL: SQL (Structured Query Language) is a programming language used to manage and manipulate data in…

Q: Your university runs many hundreds of courses each semester and needs to keep track of key…

A: the code is given below:-

Q: Display CustomerName and Status as 'Q2 for every customer who was born during the 2nd quarter of…

A: The given problem is related to database SQL query. The problem has provided the msCustomer table…

Q: Check the following statement: select sysdate Today, (select count (*) from departments)…

A: Solution :

Q: Write the Excel function to determine the number of salespersons who had a Sales Total above the…

A: use countif function to apply condition in given range countif syntax:- countif(range,criteria)…

Q: For each sale made on June 1, 2015, show the following information: CustomerID, Customer name…

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: Determine which categories are covered by the existing book stock. There should only be one listing…

A: A trader's book contains a record of all of the positions that they have taken. The entire number of…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors'…

A: Attribute (Simple): Simple qualities are ones that cannot be further subdivided. For example, in the…

Q: Find the total revenue generated by each product in the past quarter (last 3 months), you would need…

A: In SQL Server, we can use the DATEADD() function to get last 3 months (or n months) records.

Q: Vacation days are based on status. Using the information in the lower table below, do a lookup in…

A: A lookup function is used to match a lookup value in a one-column or one-row range, and returns the…

Q: List the names of all Staff members who hold a faculty position and have a salary of $45,000 or…

A: SQL Space: To leave the space while displaying the data ,a function called space is used. Syntax:…

Concept explainers

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.

Question

PRACTICAL EXERCISE 1,3
Using the information given in the table below, calculate the total amount
payable by the company to the employees using a formula.
A
Services Company Ltd
Overtime Details
Date
Name
Hours Worked
Rate
Amount
26-Nov
70
350.00
Kennedy
Kennedy
4
5
26-Nov
5
100
500.00
6.
26-Nov
100
500.00
Mary
Lewis
26-Nov
4
100
400.00
Judy
Kennedy
Lewis
30-Nov
3
100
300.00
6.
30-Nov
6.
70
420.00
10
30-Nov
100
500.00
11
30-Nov
Kennedy
Judy
4
70
280.00
12
30-Nov
100
500.00
13
30-Nov
Lewis
100
500.00
14
02-Dec
Judy
4
70
280.00
15
Total Amount

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

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

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

pythin in file and list , I want to make list of month from Jan to Dec , and enter sales for each month . Make average , total , minimum and max sales .
the employee table have the following . ask user what is the employee_id and how much employee wants to contribute 2 substitutions variable from end user &emp_id &contribution_amount If employee salary is in between $1000-$3999 And if employee's contribution amount is less than $100 then company match $100 if employee's contribution amount is greater than 100 but less than $200 then company match $75 if employee's contribution amount is greater than $200 then company match $50 $4000-$6999 And if employee's contribution amount is less than $100 then company match $150 if employee's contribution amount is greater than 100 but less than $200 then company match $100 if employee's contribution amount is greater than $200 then company match $75 $7000-$12000And if employee's contribution amount is less than $100 then company match $200 if employee's contribution amount is greater than…
Using SQL find the number of employees from the table:
Please help from attached file. Find the distinct number of workers who work in the HR department and who earn more than ₹250,000. Find the last name and title of all workers and the department they work in who earn less than the average salary. What is the average salary paid for all workers in each department? List the department, the average salary for the department, and the number of workers in each department. Name the average column 'AvgSal' and the number of workers column to 'Num'. What is the total compensation for each worker (salary and bonus) on a per monthly basis? List the name of the worker, their title, and the their monthly compensation (annual compensation divided by 12). Change the header for compensation to 'MonthlyComp' and round it to the nearest whole number. List the full names of all workers in all capital letters who did not get a bonus. What are the full names of all workers who have 'Manager' in their title. Do not "hard code" the titles; use string…
Formula to calculare the total sales amount of the customer name HORSHOE INCORPORATED. Note: This excel worksheet goes up to row 1699! Thanks.
Find the total revenue generated by each product in the past quarter (last 3 months), you would need the following tables and their respective columns: Orders table: order_id (Primary key) order_date Order_details table: order_id (Foreign key) product_id (Foreign key) quantity price per unit Products table: product_id (Primary key) product_name