Question: 1.4. Determine all the employees that does not work for the department of sales. (3 Marks) 1.5 Determine all the employees that have people working

1.4. Determine all the employees that does not work for the

1.4. Determine all the employees that does not work for the department of sales. (3 Marks)

1.5 Determine all the employees that have people working under them. (3 Marks)

Office location JHB Midrand Table 1: Employees eid sname Init job dept dob 2001 Stones S Admin HR 3-12-1980 2002 Johnson K Salesrep Sales 12-4-1991 2003 Nkosi F Manager Accounting 4-6-1978 2004 Dludla H Trainer Training 20-6-1985 2005 Dlamini J Manager HR 7-9-1976 2006 Pale K Admin HR 16-3-1997 2007 Peter M Trainer Training 14-4-1960 Pretoria JHB Pretoria Midrand JHB

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Database Section A Application-Based Question(s) 50 Marks S Question 1 Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: Table 1:...

Database Management systems question please answer ASAP within 30 mins Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: Table 1:...

Q1 Please provide answers for this SQL database question job Question 1 Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: Table 1:...

Database management system question please answer asap Question 1 Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: Table 1: Employees...

S Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: Table 1: Employees eid sname Init job dept dob Office location 2001 Stones Admin HR...

eid sname Init job dept dob 2001 Stones S Admin HR 3-12-1980 2002 Johnson K Salesrep Sales 12-4-1991 2003 Nkosi F Manager Accounting 4-6-1978 2004 Dludla . Trainer Training 20-6-1985 2005 Dlamini J...

Oracle databases use structured query language (SQL) for writing and querying data. Consider the Table 1 below: sname Init Job Table 1: Employees dept HR Sales eid dob 2001 Stones S Admin 3-12-1980...

-44 - Initial Online Assess X + -wnloads/ITDIB2-B44%20-%20Initial%20Online%20Assessment%20Paper%20Block%204%202021%20(V1.0).pdf Paper Block 4 2021 (V1.0).pdf 2 / 7 67% + Application-Based Question(s)...

I have a Cost/Managerial Accounting assignment that I need help on. Please show full work and calculations and explain answers in detail. For example, a question out of 5 marks would require 4-5...

Mr. and Mrs. Krenz are contributing to a Registered Education Savings Plan (RESP) they have set up for their children. What amount will they have in the RESP after eight years of contributing $500 at...

I earn $65000 per year. I won the lotto and took home $1,000,000 and put into account earning 5% per year, compounded annually. I want to withdraw $65000 at the beginning of each year to replace my...

3. Albert takes either Bus A or Bus B to school every day. Buses A and B either arrive punctually or late. The probabilities of Bus A and Bus B arriving 2 7 punctually are and respectively. 3 8 Find...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Give an example of a Composite Primary Key use in a HCM Payroll Table.

How are Third Normal Form rules disregarded in Dimensional Database Design?

Provide examples of Dimensional Tables.