Hey how are you? Please check the attachment and let me know  if you can do,Thank you

 

 

1. [40 pts] Using the MySQL scripts in the companydb.sql file, generate a new company database.
The companydb.sql file can be found on elearn. Put a screenshot of your final database setup. 2. [70 pts] Write/Run SQL queries for the following use cases.
a. [5 pts] Retrieve the name and salary of all employees. b. [5 pts] Retrieve the name and address of all employees who work for the 'Sales'
department. c. [5 pts] Retrieve the name and address of all employees who work either for the 'Sales' or
‘Administration’ department. d. [5 pts] Retrieve the name and address of all employees who work either for the 'Sales' or
‘Administration’ department, sorted alphabetically by last name, then first name. e. [5 pts] Retrieve all employees in the research department whose salary is between
$30,000 and $40,000. f. [5 pts] List all name of employees, the projects that they have been working on, and the
amount of time they spent for those projects. g. [5 pts] Retrieve all employees whose address is in Atlanta, GA. h. [5 pts] List all the department names which are located in Dallas. i. [5 pts] Retrieve all distinct salary values of very employee. j. [5 pts] A new person whose name is Joshua T Miller has been hired. Add this new
employed person to the system along with his following information:
SSN: 456363313
birth date: 1971-10-18
address: 98 Oak Forest, Katy, TX salary: 37000
superssn: 456363313
dno: 3 k. [5 pts] Joshua’s salary has been increased with 10%. Make the required update. l. [5 pts] Joshua left the company after working 3 years. Delete his personal record from
the system.
m. [bonus-10 pts] Make a list of all project numbers and project names for projects that
involve an employee whose last name is 'Smith', either as a worker or as a manager of
the department that controls the project.

Attachments:

• 1493773325-Q5 1.docx