st Test 2 Spring x Question assessment/take/aunchjsp?course. assessment idas-140

Question

st Test 2 Spring x Question assessment/take/aunchjsp?course. assessment idas-140284-1&course; ida.3521667.18content id 2746685-18stepanull completion status QUESTION 15 35 points Save Answer Consider the following database schema (primary keys are bolded and underlined) Employes(eID integer, eName: string, age integer, sala real Works(eID integer, dName: string, startedDate: date, ended: date) DepartmentsldNamre string, budget real, mana gerEID: integer) The meaning of these relations is straightforward; for example, the table works has one record per employee department pair, such that an employee works for a department for a specific period of time There are four foreign keys for this database: 1. the attribute eID of the relation Works that references the relation Employees, 2. the attribute dName of the relation Works that references the relation Departments. 3. Write the following queries in SQL. No duplicates should be printed in any of the answers You should use the SQL keyword DISTINCT only when necessary. In addition, the creation of temporary tables is not allowed, i er for each question, you must wnite exactly one SQL statement. Note: You MUST denote the number of each query before your answer 1. Retrieve name, age, and salary of employees 2. the and of every employee who is older than 40. 3 For all with a S500,00000, print their manager name and budget 4. Print the name and average salary of each department 5. Find the name and salary of each employee who makes more than the highest salary of employees at the Inormation Technology department 3 (12pt)

Explanation / Answer

#include<iostream.h>
#include<conio.h>
#include<stdio.h>
#include<math.h>
float f(float);
void main()

trap=h*(f(a)+2.0*sum+f(b))/2.0;
cout<<"Value of integral with "<<n<<endl;
cout<<"Subintervals="<<trap;
getche();
}
float f(float x)

#include<iostream.h>
#include<conio.h>
#include<stdio.h>
#include<math.h>
float f(float);
void main()

trap=h*(f(a)+2.0*sum+f(b))/2.0;
cout<<"Value of integral with "<<n<<endl;
cout<<"Subintervals="<<trap;
getche();
}
float f(float x)

#include<iostream.h>
#include<conio.h>
#include<stdio.h>
#include<math.h>
float f(float);
void main()

trap=h*(f(a)+2.0*sum+f(b))/2.0;
cout<<"Value of integral with "<<n<<endl;
cout<<"Subintervals="<<trap;
getche();
}
float f(float x)

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.