Suppose that there are three tables, Person, WorkFor, and Company, in a database. o The Person...

Transcribed Image Text:

Suppose that there are three tables, Person, WorkFor, and Company, in a database. o The Person table stores information about the ID, name, street, and city of each employee. o The Company table stores information about the tax number, name, and city of each company. A company may have several branches located in different cities. In this case, each branch of this company has its own tax number. (a) (b) (d) o The WorkFor table stores information about the ID and salary of each employee, and the tax number of each company. Write the data definition language (DDL) to create these three tables. (c) Write a SQL statement to calculate the number of employees who live in the city Uppsala. Write a SQL statement to find the names of all the employees who live in the city Stockholm. (1) Write a SQL statement to find the ID numbers of all the employees who work for the company IKEA and earn more than 35000. (e) Write a SQL statement to update the records in the WorkFor table, to double the salary of each employee whose salary is currently below 10000. Write a SQL statement to find the names of all the employees who work for companies which have branches located in the cities Stockholm or Uppsala. Suppose that there are three tables, Person, WorkFor, and Company, in a database. o The Person table stores information about the ID, name, street, and city of each employee. o The Company table stores information about the tax number, name, and city of each company. A company may have several branches located in different cities. In this case, each branch of this company has its own tax number. (a) (b) (d) o The WorkFor table stores information about the ID and salary of each employee, and the tax number of each company. Write the data definition language (DDL) to create these three tables. (c) Write a SQL statement to calculate the number of employees who live in the city Uppsala. Write a SQL statement to find the names of all the employees who live in the city Stockholm. (1) Write a SQL statement to find the ID numbers of all the employees who work for the company IKEA and earn more than 35000. (e) Write a SQL statement to update the records in the WorkFor table, to double the salary of each employee whose salary is currently below 10000. Write a SQL statement to find the names of all the employees who work for companies which have branches located in the cities Stockholm or Uppsala.

Answer rating: 100% (QA)

Answer Here is the DDL for creating the three tables Person WorkFor and Company Create the Person ta... View the full answer