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

Similar questions

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…
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…
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")
Normalize the following table to the 3rd Normal form: Student Student Phone Course Term Grade Instructor Instructor Phone Lauren Fernell 555-7771 MIS 350 F12 A Hess 555-2222 Lauren Fernell 555-7771 MIS 372 F12 B Sarker 555-2224 Lauren Fernell 555-7771 MIS 426 F12 A Fuller 555-2227 Lauren Fernell 555-7771 MIS 375 F12 B+ Wells 555-2228 Brigit Schnieder 555-2215 MIS 350 F12 A Hess 555-2222 Brigit Schnieder 555-2215 MIS 375 F12 B+ Wells 555-2228 Brigit Schnieder 555-2215 MIS 372 F12 A Sarker 555-2224 Brigit Schnieder 555-2215 MIS 374 F12 B Clay 555-2221 Jackie Judson 555-1245 MIS 350 F12 A Hess 555-2222 Jackie Judson 555-1245 MIS 372 F12 B+ Sarker 555-2224 How many tables did you create after normalizing the table? List each of…
1. Make a table of five columns “Name", “Midterm Score", “Final Term Score" , “Average" and Grade. Below 60 = F Above 60 =D Above 70 = C Above 80 = B Above 90 = A
31 Refer to the given SQL statement. SELECT PRODNUM, PRODNAME FROM PRODUCT: Which line designates a product number of at least 300 when added to the end of this statement? O WHERE PRODNUM>=300 WHERE PRODNUM=300+ O WHERE PRODNUM=(300; unlimited) WHERE PRODNUM=>300
database HR list the last name and salary of employees who earn between $5,000 and $12,000, and are in department 20 or 50. Label the columns Employee and Monthly Salary, respectively.
Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with “A”. (Hint: You will use a “Like” phrase.)
Display the salesperson name, product finish, and total quantity sold (label as TotSales) for each finish by each salesperson.
Based on the ERD below, display the first and last names, hire dates, and number of years employed for all employees who have worked for the organization more than 15 years. Order by the most recent hire date.