Print the course code, start date, and number of attendants for all course offerings that had at least two attendants in 2021. 5.2 Provide the employee IDs of all workers who have ever taught a course as a trainer but have never taken a course as an attendant/trainee. 5.3 Show all the records in eid, job, duration, and evaluation. 5.4 Find out if ever two classes have been conducted at the same course location at the same time. LessonsTrainingAttendant Subject EvaluationCodeStartdateTrainer Location2001DATA4SQL10-9-2021AndrewJHBSQLТАВ14-9-2021AndrewMidrand2002DATADATA22-9-2021AndrewPretoria2003PLUS4PLUS4-10-2021SmithPretoria2004REP2REP8-10-2021khethaJHBDATA4ERR20-10-2021khethaMidrand2005ERR42006ERR42007SQL5Source: Okwonkwo, C. (2021) EmployeeseidsnameInitjobdeptdoblocationsalary2001StonesAdminHR3-12-1980JHB50002002JohnsonSalesrepSales12-4-1991Midrand70002003NkosiFManagerAccounting4-6-1978Pretoria200002004DludlaHsalesrepsales20-6-1985JHB75002005DlaminiJManagerHR7-9-1976Pretoria250002006PaleAdminHR16-3-1997Midrand60002007PeterMAccountant Accounting14-4-1969JHB80002200SmithTrainerTraining4-12-1982JHB12000CoursesCodeDescriptionDuration CampusSQLIntroduction to SQL4 daysJHBТАВTable creating7 daysMidrandDATAData manipulation4 daysPretoriaPLUSCommand line3 daysPretoriaREPReport generation4 daysJHBERRError handling7 dayaMidrand

According to bartleby strategy I am permitted to address explicit number of inquiries (counting…

Answered: Print the course code, start date, and…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Print the course code, start date, and number of attendants for all course offerings that had at least two attendants in 2021. 5.2 Provide the employee IDs of all workers who have ever taught a course as a trainer but have never taken a course as an attendant/trainee. 5.3 Show all the records in eid, job, duration, and evaluation. 5.4 Find out if ever two classes have been conducted at the same course location at the same time.

Lessons
Training
Attendant Subject Evaluation
Code
Startdate
Trainer Location
2001
DATA
4
SQL
10-9-2021
Andrew
JHB
SQL
ТАВ
14-9-2021
Andrew
Midrand
2002
DATA
DATA
22-9-2021
Andrew
Pretoria
2003
PLUS
4
PLUS
4-10-2021
Smith
Pretoria
2004
REP
2
REP
8-10-2021
khetha
JHB
DATA
4
ERR
20-10-2021
khetha
Midrand
2005
ERR
4
2006
ERR
4
2007
SQL
5
Source: Okwonkwo, C. (2021)

Employees
eid
sname
Init
job
dept
dob
location
salary
2001
Stones
Admin
HR
3-12-1980
JHB
5000
2002
Johnson
Salesrep
Sales
12-4-1991
Midrand
7000
2003
Nkosi
F
Manager
Accounting
4-6-1978
Pretoria
20000
2004
Dludla
H
salesrep
sales
20-6-1985
JHB
7500
2005
Dlamini
J
Manager
HR
7-9-1976
Pretoria
25000
2006
Pale
Admin
HR
16-3-1997
Midrand
6000
2007
Peter
M
Accountant Accounting
14-4-1969
JHB
8000
2200
Smith
Trainer
Training
4-12-1982
JHB
12000
Courses
Code
Description
Duration Campus
SQL
Introduction to SQL
4 days
JHB
ТАВ
Table creating
7 days
Midrand
DATA
Data manipulation
4 days
Pretoria
PLUS
Command line
3 days
Pretoria
REP
Report generation
4 days
JHB
ERR
Error handling
7 daya
Midrand

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions