Chikoro-bestuurskool gebruik 'n databasis om die bespreking van leerlingbestuurders te bestuur - NSC Information Technology - Question 2 - 2022 - Paper 1

To show the reservation number and the name of the learner manager from the records where the test center is Bellville, use the SQL statement below:

SELECT BespreekNom, BestuurderNaam, BestuurderVan
FROM tblBesprekings, tblBestuurders
WHERE tblBesprekings.LBestuurderID = tblBestuurders.LBestuurderID 
AND tblBestuurders.LDriverID = 'Bellville';

To delete records from the tblBesprekings where the test center is Pretoria and the reservation date falls between specified dates, employ the following SQL statement:

DELETE FROM tblBesprekings
WHERE Toetsentrum = 'Pretoria'
AND BespreekDatum BETWEEN '2022/05/18' AND '2022/05/25';

To count the number of learner managers by gender, you can consider the seventh digit of the ID number. The SQL statement would look like this:

SELECT COUNT(*) AS TotalFemale,
       (SELECT COUNT(*) FROM tblBestuurders WHERE SUBSTR(ID, 7, 1) BETWEEN '5' AND '9') AS TotalMale
FROM tblBestuurders
WHERE SUBSTR(ID, 7, 1) BETWEEN '0' AND '4';

To display the bookings for a certain learner manager by input ID, the following SQL can be structured:

SELECT * 
FROM tblBestuurders 
WHERE LBestuurderID = :id;