Question: Basi di Dati - Modulo 1 10 gennaio 2023 (esame del 22 marzo 2022) 1) Consider the following database of a given company EMPLOYEE(TaxCode,

Basi di Dati - Modulo 1 10 gennaio 2023 (esame del 22

Basi di Dati - Modulo 1 10 gennaio 2023 (esame del 22 marzo 2022) 1) Consider the following database of a given company EMPLOYEE(TaxCode, Code, Name, Surname, BirthDate, Appointment Date, Role, Division) DIVISION (CODE, Function, Head Division) PROJECT(CODE, Title) PARTICIPATION (EmpCode, ProjCode, StartDate, EndDate) NOTE: EMPLOYEE.Division refers to a value in DIVISION.Code EMPLOYEE.Role can take values "Technician", "Admin", "Head of Division" DIVISION.Head Division refers to a value in EMPLOYEE.Code DIVISION.Function can take values "Customer Care", "Development", "Accounting" PARTICIPATION.EmpCode refers to a value in EMPLOYEE.Code PARTICIPATION.ProjCode Refers to a value in PROJECT.CODE PARTICIPATION.StartDate and PARTICIPATION.EndDate are the starting and ending dates, respectively, in which an EMPLOYEE participated in a project. All dates are in the format YYYY-MM-DD a) Find the tax codes, names and surnames of the head of division of "Development" in which there is some EMPLOYEE involved in the project "SUPERCAR" b) Find the tax codes, names and surnames of the employees that joined the project "CASAMIA" as last.

Step by Step Solution

★★★★★

3.55 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a To find the tax codes names and surnames of the head of division in Development where there is an ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

For each of the following financial statement users, indicate whether they would be an internal or external user: a. Bank (lender) b. Shareholders c. Employees (non-management) d. Suppliers e. Labour...

What is the mean state area? (b) What is the median state area? (c) What is the five-number summary of the state areas? Enter your answers in the correct left-to-right order. (d) What is the range of...

Question: When a division is operating at full capacity, and another division requests to buy some of its product, the minimum transfer price that the selling division will accept is computed by O...

Midland Company buys tiles and prints different designs on them for souvenir and gift stores. It buys the tiles from a small company in Europe, so at all times it keeps on hand a stock equal to the...

Question1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel without...

YEAR 2021 Determine the tax liability for tax year 2021 in each of the following instances. In each case, assume the taxpayer can take only the standard deduction. Use the appropriate Tax Tables and...

Use the Motorsports of Miami data in Short Exercise to compute the following: (Enter all amounts in thousands.) Motorsports of Miami, Inc. Income Statement Year Ended December 31, 2010 (In thousands)...

Alcohol and drug use among student athletes

The actuary for the pension plan of Regina Company calculated the following net gains and losses. Incurred during the Year (Gain) or Loss 2014 ........$ (660,000) 2015 ........ 250,000 2016 ...........

Question 2: 8 Marks The controller of Menno Corp presents you with the following observations in a general ledger account called Maintenance: Month Machine-hours Maintenance Costs Incurred January...

A. The Sunsoria Company employs a job-order pricing method and uses a predetermined overhead rate to apply manufacturing overhead to Work in Process inventory. In the current month, the business had...

1. There is a real problem in the quality of service or is the perceived quality of the service poor? 2. Which categories of health care services are generating the major portion of complaints? 3....

Use the information given below to answer the following questions. Where applicable, express answers to ratios to two decimal places. 2.1 Will the company be able to fund its short-term obligations...

If dividends are $100, stock sold is $10, and stock repurchased is $25, the cash flow to stockholders is Blank______. Multiple choice question. $135 $65 $85 $115

A sample space consists of 8 elementary outcomes with the following probabilities. Three events are given as A = {el, e2, e5, e6, e7}, B = {e2, e3, e6, e7}, and C = {e6, e8}. (a) Draw a Venn diagram...

A roulette wheel has 34 slots, 2 of which are green, 16 are red, and 16 are black. A successful bet on black or red doubles the money, whereas one on green fetches 30 times as much. If you play the...

A white and a colored die are tossed. The possible outcomes are shown in the illustration below. (a) Identify the events A = [Sum = 6], B = [Sum = 7], C = [Sum is even], D = [Same number on each...

Jorgensen High Tech Inc. is a calendar-year, accrual-method taxpayer. At the end of year 1, Jorgensen accrued and deducted the following bonuses for certain employees for financial accounting...

The month in which the year's highest temperature occurs in a city has probabilities in the ratio 1:3:6:10 for May, June, July, and August, respectively. Find the probability that the highest...

Which of the following is NOT an example of annuity cash flows?2)_______A) Equal annual deposits into a retirement accountB) The $50 of gasoline you put into your car every two weeks on pay dayC)...

Sally and Charles Heck received the following dividends and interest during 2012: Assuming the Hecks file a joint tax return, complete Schedule B of Form 1040 (on page 2-33) for them for the 2012 tax...

Skyler is covered by his company's health insurance plan. The health insurance costs his company $3,500 a year. During the year, Skyler is diagnosed with a serious illness and the health insurance...

Jerry made the following contributions during 2012: His synagogue (by check).....................................................$680 The Democratic Party (by check)...

The following amounts were obtained from the accounting records of Wachter Sports Products Inc.: Required: Compute the missing amounts?

Jordan Footwear sells athletic shoes and uses the perpetual inventory system. During June, Jordan engaged in the following transactions its first month of operations: a. On June 1, Jordan purchased,...

Kevin Spears, the accountant of Tyler Electronics Inc. has prepared the following information for the company's inventory at the end of 2019: Required: 1. Determine the carrying amount of the...