1. Design and implement the below in a database platform and server, using Microsoft SQL Server.

The database includes the following schemas:

• employee (employee-ID, employee- name, city)
• works (employee-ID, company-name, salary)
• company (company-ID,  company-name, city) and
• manages (employee-ID,  manager-name). 

2. For each relation (table), ADD (insert) at least 7 more various records (tuples) and modify the values of the previous tuples so that you can produce meaningful results (at least one tuple).

3. Create select all to display all the records to show the contents of every table. 

4. The above SQL should express each of the following queries:

a. Find the names of all employees who live in the city “Chicago”. 

b. Find the names of all employees whose salary is greater than $1,000. 

c. Find the names of all the employees living in “Chicago” whose salary is greater than $1,000.

d. Find the names of all employees who work for “Chase Bank USA”.

e. Find the names and cities of residence of all employees who work for “Chase Bank USA”.

f. Find the names, street address, and city of residence of all employees working for “ Chase Bank USA” and earn more than $1,000.

5. Draw the ERD for the above queries.

Answer rating: 100% (QA)

To implement the given requirements first lets create the necessary tables and insert records into them Heres how you can create the tables and insert data using SQL Server Create Employee table CREAT... View the full answer