Vraag 2: SQL en databasisprogrammering
Die databasis StapDB bevat die inligting van lede van verskillende stapklubs - NSC Information Technology - Question 2 - 2021 - Paper 1
Question 2
Vraag 2: SQL en databasisprogrammering
Die databasis StapDB bevat die inligting van lede van verskillende stapklubs. Die databasis bevat twee tabele, naamlik tblKlu... show full transcript
Worked Solution & Example Answer:Vraag 2: SQL en databasisprogrammering
Die databasis StapDB bevat die inligting van lede van verskillende stapklubs - NSC Information Technology - Question 2 - 2021 - Paper 1
Step 1
Knoppie [2.1.1 - Klubs van Gauteng en SA geaffilieer]
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
SELECT KlubNaam, KlubDorp FROM tblKlubs
WHERE Provinsie = 'GP' AND SA_Geaffilieer = True;
Step 2
Knoppie [2.1.2 - Geboortedatum]
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
SELECT LidNaam, LidVan, GeboorteDatum FROM tblLede
WHERE YEAR(GeboorteDatum) = 2002;
Step 3
Knoppie [2.1.3 - Vertoon lede]
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
SELECT LidVan, LidNaam
FROM tblLede INNER JOIN tblKlubs
ON tblKlubs.KlubID = tblLede.KlubID
WHERE tblKlubs.KlubNaam = '"' + $sklubNaam + '"';
Step 4
Knoppie [2.1.4 - Gemiddelde lidmaatskapfooi]
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
SELECT Provinsie,
FORMAT(AVG(LedeGeld), 'CURRENCY') AS GemFooi
FROM tblKlubs
GROUP BY Provinsie
HAVING AVG(LedeGeld) > 400;
Step 5
Knoppie [2.1.5 - Verander naam van lid]
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
UPDATE tblLede
SET LidNaam = 'Ainsley'
WHERE LidNaam = 'Ainsley';
Step 6
Knoppie [2.2.1 - Uitstaande fooie]
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
// Begin by selecting the first record from tblKlubs
OPEN tblKlubs;
WHILE NOT tblKlubs.EOF DO BEGIN
// Display the club name and yearly membership fee
ShowMessage('Club: ' + tblKlubs.KlubNaam + ' - Yearly Fee: ' + FloatToStr(tblKlubs.LedeGeld));
// Navigate to the next record
tblKlubs.Next;
END;
Step 7
Knoppie [2.2.2 - Datering voltooidte roetes op]
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
// Logic to select a member from the tblLede table
Open tblLede;
// Add code to handle the selection of a member and its routes here.
