Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

There isn't any other data, answer from this. Only do the sql statement. Database - SQL DML/DDL The following relational schema forms part of an

image text in transcribed

There isn't any other data, answer from this. Only do the sql statement.

Database - SQL DML/DDL The following relational schema forms part of an Employees database. The primary keys are underlined and foreign keys are in italics. Job (iobID. jobTitle, minSalary, maxSalary) Dependent (dependent ID, firstName, lastName, relationship, employee/D) Department departmentID, departmentName, locationID) Location (LocationID, street, postcode, city, state) Employee (emploveeID, firstName, lastName, phone Number, salary jobID, departmentID) Employee employeeID works as jobID at a department departmentID located at locationID. The employee has dependent(s) dependentID. 1. Employee whose full name is 'Fatima Abdul Fateh' has been promoted to 'Manager' and her salary now starts at the minimum salary for 'Manager'. Change the relevant record to reflect the new job and salary of 'Fatima Abdul Fateh'. 2. List the number of employees working in each state. Show the state and the number of employees. Give the new column an alias and sort the results according to the state in ascending order

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

1951077083, 978-1951077082

More Books

Students also viewed these Databases questions

Question

=+ What topics are contained in the contracts?

Answered: 1 week ago

Question

=+Are they specific or general in nature?

Answered: 1 week ago

Question

=+ What is the nature of the contracts or agreements with unions?

Answered: 1 week ago