12. Perform all operations in correct order (work must be shown and uploaded):

9. Divide (use a calculator unless the answer has a remainder then work must be shown and uploaded):

2. Round as indicated (no work requried): to the nearest ten

3. Add (use a calculator):

11. Perform all operations in correct order (work must be shown and uploaded):

1. Round as indicated (no work required): to the nearest hundred

5. Subtract (use a calculator):

Write the SQL query to list employee name, job, and salary where the employee is a MANAGER and earns more than $3,000.

DATABASE DESIGN SCENARIO 3: Fitness Center A fitness center would like to develop a database. They want to track member information (choose relevant fields), trainer information (choose relevant fields), and session schedules that link members to trainers. Payment tracking is not required.

DATA QUERY SCENARIO (Use Tables: BRANCHES, EMPLOYEES, SALARYGRADES) BRANCHES BRANCH_ID BNAME CITY 100 FINANCE BOSTON 200 ENGINEERING AUSTIN 300 MARKETING CHICAGO 400 LOGISTICS SAN FRANCISCO   EMPLOYEES EMPNO ENAME JOB MGR HIREDATE SAL COMM BRANCH_ID 9001 ADAMS CLERK 9007 01/12/2010 1000 NULL 200 9002 BAKER ENGINEER 9008 03/10/2012 2100 NULL 200 9003 CLARK SALESMAN 9006 11/11/2015 1800 300 300 9004 DAVIS MANAGER 9010 06/06/2011 3200 NULL 100 9005 EVANS ANALYST 9004 07/14/2013 4000 NULL 100 9006 FORD MANAGER 9010 08/09/2009 3100 NULL 300 9007 GREEN ANALYST 9004 12/12/2014 2700 NULL 200 9008 HARRIS ENGINEER 9006 09/21/2016 1900 NULL 200 9009 IRVING SALESMAN 9006 04/17/2017 1600 200 300 9010 JONES PRESIDENT NULL 01/01/2008 6000 NULL 100   SALARYGRADES GRADE LOSAL HISAL 1 800 1300 2 1301 1800 3 1801 2500 4 2501 4000 5 4001 9999