Question: Database management system question Please answer asap Use the tables (Courses and Lessons) below and the employees table in question 1. Write SQL to answer

Database management system question
Please answer asap
Database management system question Please answer asap Use the tables (Courses and
Lessons) below and the employees table in question 1. Write SQL to

Use the tables (Courses and Lessons) below and the employees table in question 1. Write SQL to answer the following questions. 2.1 Provide the course code and description for any courses having a four-day duration (2 Marks) 22. Which courses have been held in JHB and/or in Pretoria? (3 Marks) 2.3 Which employees took both the JAV and the DATA courses? (5 Marks) 2.4 Print a list of all workers who did not attend the JAV training (5 Marks) Courses Lessons Code DATA JAV Attendant Subject 2001 DATA JAV 2002 DATA 2003 JAV 2004 JAV DATA 2005 MATH MATH Description Duration Campus Database 4 days JHB management systems Java script 7 days Midrand Mathematics 4 days Pretoria Information 3 days Pretoria systems Hyper Text 4 days JHB Markup Language Project 7 days Midrand management ISY HTML 2006 PMT ISY 2007 PMT

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!