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 van 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 - Huur > 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(65 * WinkelGrootte, 'Currency') AS Rental
FROM tblShops
WHERE 65 * 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;
// Oor die bestuurders begin loop
For I := 0 to tblWinkels.RecordCount - 1 do
begin
if tblWinkels.FieldByName('WinkelNaam').AsString = InputBox('Voer naam van die winkel in', ''] then
begin
// Vertoon bestuurder se inligting
ShowMessage('Bestuurder: ' + tblWinkels.FieldByName('BestuurderNom').AsString);
// Mark as gevonden
bGeVind := True;
end;
tblWinkels.Next;
end;
end;
