Die databasis InkopiesentrumDB bevat inligting oor verskillende tipes winkels in 'n inkopiesentrum en die besonderhede van die bestuurders van die winkels - NSC Information Technology - Question 2 - 2021 - Paper 1
Question 2
Die databasis InkopiesentrumDB bevat inligting oor verskillende tipes winkels in 'n inkopiesentrum en die besonderhede van die bestuurders van die winkels. Die datab... show full transcript
Worked Solution & Example Answer:Die databasis InkopiesentrumDB bevat inligting oor verskillende tipes winkels in 'n inkopiesentrum en die besonderhede van die bestuurders van die winkels - NSC Information Technology - Question 2 - 2021 - Paper 1
Step 1
Knoppie [2.1.1 - Lys winkels]
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 * FROM tblWinkels
ORDER BY WinkelGrootte DESC;
Step 2
Knoppie [2.1.2 - Bestuurdernommer]
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 WinkelNaam
FROM tblWinkels
WHERE BestuurderNom = @BestuurderNom;
Step 3
Knoppie [2.1.3 - Uur > R50 000]
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 WinkelNaam, WinkelGrootte,
FORMAT(WinkelGrootte, "Currency") AS Rental
FROM tblWinkels
WHERE WinkelGrootte > 50000;
Step 4
Knoppie [2.1.4 - Omset per bestuurder]
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 BestuurderNaam, BestuurderVan,
FORMAT(SUM(Omset), "Currency") AS TotaleOmset
FROM tblWinkels W, tblBestuurders B
WHERE W.BestuurderNom = B.BestuurderNom
GROUP BY BestuurderNaam, BestuurderVan;
Step 5
Knoppie [2.1.5 - Datum winkelnaam op]
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 tblWinkels
SET WinkelNaam = 'TeenDream'
WHERE WinkelNaam = 'Jeans 4U';
Step 6
Knoppie [2.2.2 - Vertoon bestuurder]
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
var
bGevind: Boolean;
begin
bGevind := False;
// Doorloop die winkels tabel
// As die naam gevind is, voer die data uit
end;
