Vacation days are based on status. Using the information in the lower table below, do a lookup in the upper table determine the amount of vacation time earned by each employee.    Status              Vacation Time Earned Full TIme                       10 Part Time                        7 Contract                          0   Employees              Status                   Vacation TIme Earned John                        Contract Jane                        Part Time Al                            Full TIme

Q: display all fields in the JOB table sorted by the largest hourly charges for the job first

A: SELECT * will fetch you all record in table

Q: List the years and their total gross earnings (sum of earnings per year), but do not include gross…

A: ANSWER:-

Q: Display the maximum price of all the products in PRODUCTS table for each Supplier ID having a…

A: Here we need to join Table Supplier and PID. Since they have common attribute,they can be joined…

Q: he following shows a training company’s workshops, the number of days of each, and their…

A: In this question we have to calculate and display the total cost of attending a workshop, including…

Q: Create a list showing only the EmployeeID, Sales, and Projected Sales sorted from highest to lowest…

A: The query selects the specified columns from the EmployeeSales table and orders the result set based…

Q: Based on the ERD below, display the assignment number, employee number and assigned hours for either…

A: Here we are joining three tables ASSIGNMENT, EMPLOYEE, and JOB and the assigned job is either 501 or…

Q: Measured by average standard price, what is the least expensive product finish?

A: SELECT  ProductFinish FROM Product_T WHERE ProductStandardPrice= (  SELECT…

Q: List of products names for a given list of vendor IDs:

A: As per our company guidelines, we are supposed to answer only one question per post and kindly…

Q: Please see the attached and assist with below question. Using the “Aggregates” worksheet, complete…

A: The given problem is to complete the given excel for an income tax calculation using MS EXCEL and…

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

A: you can use this query

Q: Table: Task Primary key: TaskID Foreign key: Team MemberID TaskID 1 2 3 Description Build login…

A: INSERT Query: It used to insert new record in table. Syntax: INSERT INTO table_name (column1,…

Q: 1. Use the following table to answer the questions below. Table name: Products Column Role Data Type…

A: We have to extract year from the Date filed and then the year has to be 2021  Now, we have to count…

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: Analyze the given tables showing the information of different candidates and departments. You are…

A: => here in the question given 2 tables one is Candidates and other one is Departments

Q: Table: Import Primary key: ImportID Foreign key: CountryID ImportID 1 2 3 Description Electronics…

A: The answer is given below

Q: Refer to the WORKERS table: WORKERS Empno Empname Job Mgr HireDate Sal Comm Deptno 24000 2.405 17000…

A: Given :

Q: FIRST NAME LAST_NAME SALARY John Russell 14000 .4 Karen Partners 13500 .3 Alberto Errazuriz 12000 .3…

A: NOTE: Here student mentioned list employee managed by each manager. so here I am using manager id to…

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: Based on the ERD below, display all columns in the JOB table for those job descriptions that have…

A: 2) Query to display all columns in the JOB table for those job descriptions that have both analysts…

Q: Conference Planning The following table shows a training company's workshops, the number of days of…

A: Code for an application that lets the user select a workshop from one ListBox and a location from…

Q: Q :Draw a flow chart for Grade calculation.

A: Flow chart is a pictorial representation of given scenario. Using certain symbols, the flow chart…

Q: Show the employee dataframe after sorting by year join in descending order and by salary in…

A: Using R show the employee dataframe after sorting by year join in descending order and by salary in…

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: Given the employees of medium-sized semi-conductor firm, find the employee that joined November 8,…

A: The Excel INDEX function returns a value in an array based on the row and column numbers you…

Q: There are 9 workers for ASH Development Sdn. Bhd. as shown in Table Q4. Unfortunately, there are…

A: According to question there are 9 workers and 4 rooms. The Ids of workers selected for the jobs are…

Q: creat the following tables and insert your own values: emp(eno, ename, bdate, title, salary, dno)…

A: The SQL INSERT INTO Statement is used to add new rows of data to a table in the database

Q: Financial Aggregated Data Average Revenue Largest Expenses Lowest Revenues Smallest Expenses # of…

A: the answer is

Q: List the department name and its instructor’s average salary in which the instructors teach a course…

A: SQL implements WHERE clause with SELECT command in order to retrieve stored information from the…

Q: For each different job_id group in the employee table, show the average salary and job_id for the…

A: SELECT Average_salary,              Job_id  FROM employees  WHERE EXISTS (SELECT *…

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: Add a CHECK constraint on the BEDROOOM column in the ROOMS table. It must accept a value from 1 to 5…

A: CHECK is the keyword used for CHECK constraint and after table has created, if you want to add this…

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: Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd…

A: Overview : The COUNT() function returns the number of rows that matches a specified criterion. The…

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…

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.