Do the following: 1 - NSC Information Technology - Question 2 - 2023 - Paper 1

To display the LecturerName, LecturerSurname, and abbreviated gender, the SQL query would be:

SELECT LecturerName, LecturerSurname, LEFT(Gender, 1) AS [Gender (M/F)]
FROM tblLecturers;

To display CourseID and CourseName for courses with multilingual lecturers:

SELECT CourseID, CourseName
FROM tblCourses
WHERE tblCourses.LecturerID IN (
    SELECT LecturerID
    FROM tblLecturers
    WHERE Multilingual = TRUE
)
ORDER BY CourseName;

To calculate the total salary for each lecturer based on their courses:

SELECT LecturerID, FORMAT(COUNT(*) * 10000, 'C', 'en-ZA') AS Salary
FROM tblCourses
GROUP BY LecturerID;

For calculating and displaying the average course duration for each lecturer:

var
  Sum, Count: Integer;
begin
  Sum := 0;
  Count := 0;
  // Loop through each lecturer
  // For each lecturer, loop through their courses
  // Sum durations and count courses
  // Display the average as: Average Duration: Sum / Count:0.00;
end;

To add a new lecturer to the tblLecturers table:

tblLecturers.Insert;
tblLecturers['LecturerID'] := 'ZT032';
tblLecturers['LecturerName'] := 'Zander';
tblLecturers['LecturerSurname'] := 'Thomas';
tblLecturers['Gender'] := 'M';
tblLecturers['Multilingual'] := True;
tblLecturers.Post;