Question: Write the following SQL queries based on the following relational schema: Staff(staffID: integer, name: string, age: number, salary: number (5), address: str Faculty (facultyID: string,

Write the following SQL queries based on the following relational schema: Staff(staffID: integer, name: string, age: number, salary: number (5), address: str Faculty (facultyID: string, facName: string, budget: number (7), manageriD: integer Research (staffid: integer, facultyXD: string) List the faculty ID, faculty name and the total salary in each faculty. [5 marks]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

Based on the relational schema below: Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pcttime: integer) eptdteg er imegen Express the following queries...

Name 2 (15pts) A university database contains information about instructors Gdentified by social security number, or SSN, with name, email address, phone number and office number as attributes) and...

Answer this question using a subquery if needed, thanks! SQL statement must prompt table in my SQL workbench 2. Retrieve the name and salary of the two highest salaried employees for the department...

Answer this question using subqueries if needed. Table must prompt in my SQL workbench, thanks! 3. Retrieve the name of employees, whose salary is higher than the average of all employees, and their...

Answer this question using subqueries if needed. Thanks! 1. Find the minimum, maximum, and average salary in each department. Query: DROP DATABASE IF EXISTS HW1; CREATE DATABASE HW1; Use HW1; CREATE...

Consider the following relational schema. An employee can work in more than one department; also, the percentTime field of the Works relations shows the percentage of time that a given employee works...

Task 2 (50 points): Consider the following relational schema. An employee can work in more than one department; also, the percentTime field of the Works relations shows the percentage of time that a...

15pts) Consider the following relations: Student(s num: integer, s name: string, major string, level: string, age: integer) Class(c name: string, meets at: string, room: string, fid: integer)...

The switch in Fig. 8.91 is opened at t = 0 after the circuit has reached steady state. Choose R and C such that Î± = 8Np/s and (d = 30 rad/s. 10 40 V 0.5 H

If social engineering is a common reason that confidential information was revealed, what needs to be done to prevent this from occurring?

7. It is given that M = {x: x is a perfect square such that 0

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

2. Develop a persuasive topic and thesis

1. Define the goals of persuasive speaking

4. Explain three forms of rhetorical proof: ethos, logos, and pathos