Vraag 2: SQL en Databasisprogrammering
Die database 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 database StapDB bevat die inligting van lede van verskillende stapklubs. Die databas bevat twee tabelle, naamlik tblKlubs... show full transcript
Worked Solution & Example Answer:Vraag 2: SQL en Databasisprogrammering
Die database 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
Die SQL-stelling om die klubs wat in Gauteng geaffilieer is te vertoon is:
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
Die SQL-stelling om lede wat in 2002 gebore is te vertoon is:
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
Die SQL-stelling om lede te vertoon vanaf 'n spesifieke KlubNaam is:
SELECT Lede.LidVan, Lede.LidNaam
FROM tblKlubs INNER JOIN tblLede
ON tblKlubs.KlubID = tblLede.KlubID
WHERE tblKlubs.KlubNaam = 'Gegewe KlubNaam';
Step 4
Knoppie [2.1.4 - Gemiddelde ledegeld]
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
Die SQL-stelling om die provinsie en gemiddelde ledegeld per provinsie te vertoon is:
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
Die SQL-stelling om die naam van lede wat as 'Ainsley' gespel is te verander is:
UPDATE tblLede
SET LidNaam = 'Ainsley'
WHERE LidNaam = 'Ainsley';
Step 6
Knoppie [2.2.1 - Uitsande fooi]
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
Die kode om die naam van die klub en jaarklikse ledegeld te vertoon is:
ShowMessage('Die Klub is ' + tblKlubs.KlubNaam + ' en die ledegeld is ' + FloatToStr(LedBedrag));
Step 7
Knoppie [2.2.2 - Datum voltooi 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
Die kode om tblLede se ID te verkry is:
dbgrdMany.Refresh;
Step 8
Knoppie [2.2.3 - Voeg lid hul]
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
Die kode om die KlubID uit die radiogroep te verkry is:
KlubID := `Gegewe waarde`; // waar die waarde uit die radiogroep verkry word
