Answered step by step
Verified Expert Solution
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
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 orderStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started