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

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
Get step-by-step solutions from verified subject matter experts
