Basi di Dati - Modulo 1 10 gennaio 2023 (esame del 22 marzo 2022) 1) Consider...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
a To find the tax codes names and surnames of the head of division in Development where there is an ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
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...
-
The programming language is Java and all of the Classes I was given are in bold. ALIEN CLASS import imagePackage.RasterImage; import java.awt.BasicStroke; import java.awt.Color; import...
-
On June 1, Marchon Company Ltd. borrows $60,000 from Acme Bank on a 6-month. $60,000, 8% note. The note matures on December 1. Instructions (a) Prepare the entry on June 1. (b) Prepare the adjusting...
-
Question 7: On January 1, 20X1, a utility building was purchased for $2,190,000. Assuming a 25-year useful life and its worth to be $246,000 at the end of its life, how much would the "depreciation...
-
Which journal entry records obtaining a bank loan of $15,000? DATE ACCOUNTS POST REF. DR. CR. a. Notes Payable 15,000 Accounts Receivable 15,000 b. Notes Payable Cash 15,000 15,000 C. Cash Notes...
-
Suppose Ritter Brothers purchases $400,000 of 5% annual bonds of Clarkson 1. Corporation at face value on January 1, 2016. These bonds pay interest on June 30 and December 31 each year. They mature...
-
1.Bulletin board - does the company have to allow union flyers?
-
ZIM Inc. (ZIM) is a high-technology company that develops, designs, and manufactures telecommunications equipment. ZIM was founded in Year 5 by Dr. Alex Zimmer, the former assistant head of research...
-
Explain Erik Erikson's theory of socialization as a lifelong process.
-
If (log 1068)/(log108) = logganswer, then what is the answer?
-
Pina Colada Corporation manufactures car stereos. It is a division of Berna Motors, which manufactures vehicles. Pina Colada sells car stereos to Berna, as well as to other vehicle manufacturers and...
-
Put yourself in the place of a Chief Marketing Officer for a rising snack food company. You gather data from an appropriate number of consumers. Your dependent variable is "Likelihood to Purchase"...
-
CH-CH, reacts 1000 times faster than Ph-CH=CH, with Br-HOAc but only 3.8 times faster with pCI-CH,SCI in HOAC at 25C. Explain.
-
Prove lim(5x-17) = -2 x3
-
The following quote on Apple stock appeared on August 21, 2019, on Yahoo Finance: If you wanted to buy Apple, what price would you pay per share? How much would you receive per share if you wanted to...
-
From the choice of simple moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate? Why? please write it in word...
-
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)...
-
Discuss some of the special considerations involved in the audit of investments in group entities.
-
Joplin Ltds financial year ends on 30 June 20X1 and the companys auditor, Hagan and Partners, conducts the annual audit during July and August. Hagan and Partners has prepared auditing procedures for...
-
What is a solicitors representation letter? What effect might the failure of a solicitor to respond to a request for representation have on the auditors report?
Study smarter with the SolutionInn App