Note: Tables included, and answers (1, 2, 3, 4, 5, 6, 8,9,10, and 11) have been provided. I just need the remaining answered 7.

Thanks for the help

Unit 4 Assignment 2

Directions

Perform the following tasks below by using the correct SQL statements. Create the statements in Oracle by using the following steps (SQL > SQL commands > EnterCommand). Once your command is error-free, copy and paste your statements into this assignment document. Upload this Word document for grading.

All questions should be answered with one SQL statement. Use the new Join syntax.

1. Find the columns that make up the primary key of the l_lunch_items table.

Sort the columns by position. (Do this in one statement).

Answer = SELECT lunch_id FROM l_lunch_items ORDER BY 1 ASC;

2. List all the lunches that employees have signed up for. Show me first_name, last_name, lunch_date, and product_code of the items they ordered. Do not includeemployees who don't have a manager.

Sort the rows by product_code.

Answer = SQL> Select first_name, last_name, lunch_date,product_code

From l_employees e,l_lunches l ,l_lunch_items li

where e.employee_id=l.employee_id and l.lunch_id=li.lunch_id and e.manager_id<>null

order by product_code;

3. From the employees table, list the employee_id, last_name, and phone_number of every employee, along with the last_name and phone number of his manager. Sort therows by employee_id. (Hint…tables can be joined to themselves…just give each table a different alias).

Answer = .SQL> SELECT department_code, department_name,COUNT(*) as number_of_employees.

FROM l_employees e,l_departments d

where e.department_code=d.department_code

GROUP BY department_code;

4. Similar to 3, but include rows for the people who do not have managers.

Answer = SELECT employee_id, last_name,phonenumber FROM employee

WHERE manager_id is null ORDER BY employee_id;

5. Count the number of foods supplied by each supplier. List all the suppliers. Show the supplier_id, supplier_name, and number of foods from each supplier. Sort therows on the supplier_id.

Answer = SQL> Select supplier_id, supplier_name, count(supplier_id) as number_of_foods

FROM l_foods f,l_suppliers s

where f.supplier_id=s.supplier_id

order by supplier_id;

6. Count the number of employees who work in each department. List all the departments. Show the department code, department name, and the number of employees. Sort onthe dept_code.

Answer = .SQL> SELECT department_code, department_name,COUNT(*) as number_of_employees.

FROM l_employees e,l_departments d

where e.department_code=d.department_code

GROUP BY department_code;

7. Count the number of servings of each food in all the lunches in the l_lunch_items table. Show all of the foods. Return supplier id, product code, description, andthe number of servings in all of the lunches.

8. Show the columns that make up the foreign key of the l_lunch_items table.

Answer =

SELECT DISTINCT b.column_name, b.position

FROM user_constraints a JOIN user_cons_columns b ON

a.table_name = b.table_name AND a.constraint_name = b.constraint_name

WHERE

a.table_name = ‘L_LUNCH_ITEMS‘

AND a.constraint_type =’R’

9. Find the total amount spent on lunches by each employee. Show first_name,

last_name, credit_limit, and total_price_spent in your results. Order your

answer by total_price_spent in descending order.

Answer = SELECT a.first_name, a.last_name, credit_limit, SUM(c.quantity * d.price) AS total_price_spent

FROM l_employees a JOIN l_lunches b ON a.employee_id = b.employee_id JOIN l_lunch_items c ON b.lunch_id = c.lunch_id JOIN l_foods d ON c.supplier_id = d.supplier_idAND c.product_code = d.product_code

GROUP BY a.first_name, a.last_name, a.credit_limit

ORDER BY total_price_spent DESC

10. For each lunch date, list the total quantity of each food needed for that lunch. List the columns: lunch_date, food_description, full name of the supplier, totalquantity, and total price.

Answer = SELECT a.date_entered, c.description AS food_description, d.supplier_name, SUM (b.quantity) AS total_quantity, SUM(c.price*b.quantity) AS total_price

FROM l_lunches a JOIN l_lunch_items b ON a.lunch_id = b.lunch_id JOIN l_foods c ON b.supplier_id = c.supplier_id AND b.product_code = c.product_code JOIN l_suppliers dON c.supplier_id = d.supplier_id

GROUP BY a.date_entered, c.description, d.supplier_name

11. Find the total amount spent on lunches by each employee. Only show the employees who spent more than their credit limit. Show first_name,

last_name, credit_limit, and total_price_spent in your results. Order your

answer by total_price_spent in descending order.

Answer = SELECT a.first_name, a.last_name, credit_limit, SUM(c.quantity * d.price) AS total_price_spent

FROM l_employees a JOIN l_lunches b ON a.employee_id = b.employee_id JOIN l_lunch_items c ON b.lunch_id = c.lunch_id JOIN l_foods d ON c.supplier_id = d.supplier_idAND c.product_code = d.product_code

HAVING SUM(quantity * price) > a.credit_limit

GROUP BY a.first_name, a.last_name, a.credit_limit

ORDER BY total_price_spent DESC

EMPLOYEE_ID FIRST_NAME LAST_NAME DEPT_CODE HIRE_DATE CREDIT_LIMIT PHONE_NUMBER MANAGER_ID

201 SUSAN BROWN EXE 01-JUN-98 30 3484 –

202 JIM KERN SAL 16-AUG-99 25 8722 201

203 MARTHA WOODS SHP 02-FEB-09 25 7591 201

204 ELLEN OWENS SAL 01-JUL-08 15 6830 202

205 HENRY PERKINS SAL 01-MAR-06 25 5286 202

206 CAROL ROSE ACT – – – –

207 DAN SMITH SHP 01-DEC-08 25 2259 203

208 FRED CAMPBELL SHP 01-APR-08 25 1752 203

209 PAULA JACOBS MKT 17-MAR-99 15 3357 201

210 NANCY HOFFMAN SAL 16-FEB-07 25 2974 203

SUPPLIER_ID PRODUCT_CODE MENU_ITEM DESCRIPTION PRICE PRICE_INCREASE

ASP FS 1 FRESH SALAD 2 .25

ASP SP 2 SOUP OF THE DAY 1.5 –

ASP SW 3 SANDWICH 3.5 .4

CBC GS 4 GRILLED STEAK 6 .7

CBC SW 5 HAMBURGER 2.5 .3

FRV BR 6 BROCCOLI 1 .05

FRV FF 7 FRENCH FRIES 1.5 –

JBR AS 8 SODA 1.25 .25

JBR VR 9 COFFEE .85 .15

VSB AS 10 DESSERT 3 .5

LUNCH_ID LUNCH_DATE EMPLOYEE_ID DATE_ENTERED

1 16-NOV-11 201 13-OCT-11

2 16-NOV-11 207 13-OCT-11

3 16-NOV-11 203 13-OCT-11

4 16-NOV-11 204 13-OCT-11

6 16-NOV-11 202 13-OCT-11

7 16-NOV-11 210 13-OCT-11

8 25-NOV-11 201 14-OCT-11

9 25-NOV-11 208 14-OCT-11

12 25-NOV-11 204 14-OCT-11

13 25-NOV-11 207 18-OCT-11

SUPPLIER_ID SUPPLIER_NAME

ARR ALICE &RAY&#39;S RESTAURANT

ASP A SOUP PLACE

CBC CERTIFIED BEEF COMPANY

FRV FRANK REED&#39;S VEGETABLES

FSN FRANK &SONS

JBR JUST BEVERAGES

JPS JIM PARKER&#39;S SHOP

VSB VIRGINIA STREET BAKERY

DEPT_CODE DEPARTMENT_NAME

ACT ACCOUNTING

EXE EXECUTIVE

MKT MARKETING

PER PERSONNEL

SAL SALES

SHP SHIPPING

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Coach Training Accreditation Scheme 

Title of Training Course: Life Coach School Arkansas

Accreditation level applied for:

Accredited Award

In Coach Training

(AACT)

1. Declaration

Terms and Conditions of AC Coach Training Accreditation

• The representative of the applying organization should read these conditions carefully before signing and sending the completed form and attachments to the AC.  

• Acceptance of these conditions will be required by all successful applicants for AC Coach Training Accreditation. 

• Applicants are urged to refer carefully to the Applicant Guide before completing the application form.

The Provider confirms:

• Understanding of, and agreement with, the AC’s Code of Ethics and Good Practice

• Understanding that the ongoing AC Coach Training Accreditation is dependent upon continuing the organization’s AC Membership

The Provider agrees to:

1. Provide the training course(s) as detailed in this application and the attached documents

2. Inform AC of any significant changes to the course which may affect the accreditation 

3. Implement health and safety, and equal opportunities policies in relation to the course(s) and associated activities

4. Be careful not to represent itself as connected to the AC other than as a member organization with an accredited course(s)

5. Advertise and deliver the course(s) accurately as AC Accredited Coach Training Courses(s), and as presented in this application

6. Comply with the current conditions for use of the appropriate AC logo(s)

7. Make clear to course participants that they do not become Accredited Coaches as a result of attending the course

8. Have a complaints procedure

By answering the above questions and submitting this application to the AC we acknowledge that these statements are true and correct

Your name

On behalf of (Life Coach School of Arkansas)

Date: 7-31-2019

2. AC Coaching Competencies and Code of Ethics Used Within the Coach Training Course

Please complete the tables below. If you use other competencies in addition to those of the AC, please enter details in the relevant section. Please refer to Applicant Guide for further instructions. 

Section One

Coach Training Course Title: Level of AC Coach Training Accreditation applied for: please tick ()

Accredited Award

in Coach Training

(AACT)

Additional Coaching Competencies and Code of Ethics used during course

Section Two

AC Coaching Competency:

Corresponding Coaching Competency:

1. Meeting ethical, legal and professional guidelines

How coaching competency is covered within the Coach Training Course (in brief)

When:

How:

2. Establishing the coaching agreement and outcomes

How coaching competency is covered within the Coach Training Course (in brief)

When:

How:

3. Establishing a trust-based relationship with the client

How coaching competency is covered within the Coach Training Course (in brief)

When:

How:

4. Managing self and maintaining coaching presence

How coaching competency is covered within the Coach Training Course (in brief)

When:

How:

5. Communicating effectively

How coaching competency is covered within the Coach Training Course (in brief)

When:

How:

6. Raising awareness and insight

How coaching competency is covered within the Coach Training Course (in brief)

When:

How:

7. Designing strategies and actions

How coaching competency is covered within the Coach Training Course (in brief)

When:

How:

8. Maintaining forward momentum and evaluation

How coaching competency is covered within the Coach Training Course (in brief)

When:

How:

9. Undertaking continuous coach development

How coaching competency is covered within the Coach Training Course (in brief)

When:

How:

3. Hours of Coach Training Course

Complete the tables below. Please refer to Applicant Guide for further instructions. 

Dates Coach Training Course has been delivered 

* Coach Training Course must be run at least once prior to application

Class-based training hours and coaching practice

Self-study hours *

Actual hours of Coach Training Course

Participant’s coaching practice hours (in addition to class-based practice)**

*See Applicant guide for further details

** in addition to class-based practice undertaken by participants

 4. Coach Training Course Structure 

Please enter details of your Coach Training Course structure in the table below. 

Please refer to Applicant Guide for further instructions. 

Module/Unit Method/Resources Content Blended Learning Time

Assessment criteria

Example:

Module 1

Building rapport

Effective listening

Questioning skills

Tutor led discussion, handouts, exercises

Role of coaching & behaviours/skills 

Types/models of coaching

Key coaching skills

Communication and learning styles Theory & Practice 12 hours Work based assignment and evidence of six hours of coaching

Total Hours

Class-based training hours and coaching practice

Self-study hours

Coaching practice hours (in addition to class-based practice)

5. Coaching Approaches and Models

Please enter details of the coaching approaches and models used in the table below. Please refer to the Applicant Guide for further instructions.

Please list all specific coaching approaches and models used within the Coach Training Course Please tick indicate with a tick () how and when these are used 

Method In class Self-study Coaching Practice

Example: Model used – GROW GROW – Goals, Reality, Obstacles/Options, Will/Way Forward Tutor led presentation

Reading : Observed coaching session  Triad practice session 

6. Lesson Plan Outcomes

Please enter details of the lesson plan outcomes relating to the training of the use of a specific coaching approach or model that you train in your Training Course. 

Learning Outcomes

Number Description of outcome

1

2

3

4

Assessment Criteria Linked to Learning Outcomes Specific requirements

1.1

1.2

1.3

2.1

2.2

2.3

3.1

3.2

3.3

4.1

4.2

4.3

 

7. Lesson Plan Content

Please enter details of the lesson plan for the training of the specific coaching approach or model that you have presented in Section 5. Refer to 

Applicant Guide for further information.

Item Content Activity Materials Time

1.

2.

3.

4.

5.

6.

7.

8.

9.

10.

 

8. Self-Study 

Please enter details of the self-study requirements of the course for which you are applying for AC Coach Training Accreditation. 

Type of self-study Hours

Example: 

Reading: Coaching for Performance by Sir John Whitmore

Total hours of 

self-study

8. Coaching Practice

Please complete the tables below and refer to Applicant Guide for further instructions.

Class Based Practice

 

In Addition to Class Based Practice 

 

9. 10. Feedback, Reflective Work and Supervision

Please complete the table below. 

Element Detail

Example: 

Observation and Feedback Example:

Two triads coaching sessions on days 1 and 2 in triads observed by tutor

One coaching session with volunteer on day 2 observed by external supervisor

10. Written Assessments

Please complete the table below with details of written assignments participants are asked to submit. 

 

 

11. Course Tutors

Please complete the table below writing 200 words outlining the experience and expertise of each of the course tutors to deliver the specified Coach Training Course to the required standard. 

12. Assessment Methods

Please give a give a brief description of up to 500 words of the assessment methods used to determine fitness to practise. Please refer to Applicant Guide for further instructions.

 

 

13. Course Assessors

Please complete the table below only if any assessors on your course are not course tutors.  

Name of Assessor/s Role Experience, qualifications, expertise

Relevant Memberships or Accreditations held

Example: Anne Browne Independent Assessor 3 years as an NVQ Assessor IAV

14. Course Evaluation 

Please complete the table below. Please refer to Applicant Guide for further instructions.

Method used Frequency/time Action taken as a result

Example: Feedback from those coached by the student Twice during the duration of the Coach Training Course – after coaching session 3 of 6 and after session 6 of 6. Results fed back into twice-yearly review of Coach Training Course to ensure adherence to coaching competency framework, coaching methodologies used forming part of the continuous evaluation and improvement process.

 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

See attached document for additional guidance 

How are your two philosophers coming along? Take time to finalize your search for the two and write your faculty member a paragraph in which you announce their names and the one area of political thought for comparison. In a sentence or two, explain what draws you to this focus.

 

********DO NOT TALK ABOUT Aristotle/Socriates********

**********DO NOT WRITE ABOUT Augustine.Arias*******

 

APA format, with intext citation

• Posted: 4 years ago
• Due: 27/02/2016
• Budget: $10

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

assessment.

Students are required to, follow the instructions by your lecturer to confirm any

relevant information. You also need to follow any relevant announcement on

Blackboard that confirm the date and time.

The individual assignment will assess students on the following LOs;

1. On understanding of the various theoretical models of accounting

2. On applying knowledge and understanding to specific financial reporting issues

to AASB accounting standards

3. On discussing the theoretical constructs of contemporary financial accounting

4. On evaluating and explaining the need for the development of a conceptual

framework for accounting, and discuss the influence of such a framework on

accounting practice.

5. On Understanding of the Australian accounting regulatory framework and the

conceptual framework

6. On understanding of how to account for assets, non-current assets and liabilities

7. Be able to calculate for revaluations and impairments of non-current assets, and then

journalise, and

8. Account for leases for both lessees and lessors.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"