Confidential
NATIONAL
SENIOR CERTIFICATE
GRADE 12
INFORMATION TECHNOLOGY P1
NOVEMBER 2024
MARKS: 150
TIME: 3 hours
This question paper consists of 25 pages, 2 data pages,
2 pages for planning and a separate information sheet.
Copyright reserved Please turn over
Skip to contentAll 2024 papers 





View all





Information Technology Grade 12 P1 November 2024 NSC QP
Grade 12 Information Technology Paper 1 question paper from the November 2024 NSC (English), 30 pages. Read online or download the free PDF.
Information Technology · Grade 12 · November 2024 NSC · 2024. Question paper, 30 pages. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Question paper
- Year
- 2024
- Exam period
- November 2024 NSC
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 30
- File size
- 1.3 MB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 30
This exam
November NSC 2024
Questions in this paper
Document textSearch extracted text and jump to a page.
Information Technology/P1 2 DBE/November 2024
NSC Confidential
INSTRUCTIONS AND INFORMATION
1. This question paper is divided into FOUR sections. Candidates must answer
ALL the questions in ALL FOUR sections.
2. Two blank pages have been provided at the end of the question paper, which
may be used for planning purposes.
3. The duration of this examination is three hours. Because of the nature of this
examination, it is important to note that you will not be permitted to leave the
examination room before the end of the examination session.
4. This question paper is set with programming terms that are specific to the Delphi
programming language. The Delphi programming language must be used to
answer the questions.
5. Make sure that you answer the questions according to the specifications that are
given in each question. Marks will be awarded according to the set
requirements.
6. Answer only what is asked in each question. For example, if the question does
not ask for data validation, then no marks will be awarded for data validation.
7. Your programs must be coded in such a way that they will work with any data
and not just the sample data supplied or any data extracts that appear in the
question paper.
8. Routines, such as search, sort and selection, must be developed from first
principles. You may NOT use the built-in features of the Delphi programming
language for any of these routines.
9. All data structures must be defined by you, the programmer, unless the data
structures are supplied.
10. You must save your work regularly on the disk/CD/DVD/flash disk you have
been given, or on the disk space allocated to you for this examination session.
11. Make sure that your examination number appears as a comment in every
program that you code, as well as on every event indicated.
12. If required, print the programming code of all the programs/classes that you
completed. Your examination number must appear on all printouts. You will be
given half an hour printing time after the examination session.
13. At the end of this examination session, you must hand in a disk/CD/DVD/
flash disk with all your work saved on it OR you must make sure that all your
work has been saved on the disk space allocated to you for this examination
session. Ensure that all files can be read.
Copyright reserved Please turn over
Information Technology/P1 3 DBE/November 2024
NSC Confidential
14. The files that you need to complete this question paper have been provided to
you on the disk/CD/DVD/flash disk or on the disk space allocated to you. The
files are provided in the form of password-protected executable files. Nov
Do the following:
Double click on the following password-protected executable file:
DataNOV2024.exe
Click on the 'Extract' button.
Enter the following password: #RUN4@New
Once extracted, the following list of files will be available in the folder
DataNOV2024:
Question 1: Question 3:
Houses.txt MRecord_U.pas
Question1_P.dpr Question3_P.dpr
Question1_P.dproj Question3_P.dproj
Question1_P.res Question3_P.res
Question1_U.dfm Question3_U.dfm
Question1_U.pas Question3_U.pas
Question 2: Question 4:
ConnectDB_U.pas Question4_P.dpr
MarathonsDB - Copy.mdb Question4_P.dproj
MarathonsDB.mdb Question4_P.res
Question2_P.dpr Question4_U.dfm
Question2_P.dproj Question4_U.pas
Question2_P.res
Question2_U.dfm
Question2_U.pas
Copyright reserved Please turn over
Information Technology/P1 4 DBE/November 2024
NSC Confidential
SECTION A
QUESTION 1: GENERAL PROGRAMMING SKILLS
Do the following:
Open the incomplete program in the Question 1 folder.
Enter your examination number as a comment in the first line of the
Question1_U.pas file.
Compile and execute the program. The program has limited functionality currently.
Example of the graphical user interface (GUI):
Complete the code for each section of QUESTION 1, as described in
QUESTION 1.1 to QUESTION 1.5 on the next page.
Copyright reserved Please turn over
Information Technology/P1 5 DBE/November 2024
NSC Confidential
1.1 Write code for buttons btnQ1_1_1 and btnQ1_1_2 as specified below.
1.1.1 Button [1.1.1 - Random]
Write code to do the following:
Generate a random number from 5 to 10, both numbers included.
Display the random number in the edit box edtQ1_1_1.
Example of output if the random number 5 was generated:
NOTE: The output may differ due to the nature of random numbers. (4)
1.1.2 Button [1.1.2 - Round up]
You have been provided with a constant NUMBER = 5.23247.
Write code that uses a mathematical function to display the value of
the constant, rounded up to the next whole number in the spin edit
spnQ1_1_2.
Example of output:
(3)
1.2 Button [1.2 - Surface area]
A right-angled solid cone is depicted in the image below.
The surface area of the cone is calculated using the following formula:
𝐴 = 𝜋𝑟(𝑟 + √ℎ2 + 𝑟 2 )
Write code to do the following:
Extract the values of r and h from the provided edit boxes edtQ1_2_r and
edtQ1_2_h respectively.
Use the values of r and h and appropriate mathematical functions to
calculate the surface area of the cone represented by A.
Display the value of A in the label lblQ1_2, rounded to TWO decimal
places.
Copyright reserved Please turn over
Information Technology/P1 6 DBE/November 2024
NSC Confidential
Example of input and output where r = 5 and h = 10:
Example of input and output where r = 7.9 and h = 22.4:
(8)
1.3 Button [1.3 - Read file]
A text file called Houses.txt contains the street address and the number of
bedrooms for each house in a suburban area.
The format of the content of the text file is as follows:
<street address>
<number of bedrooms>
Example of the first four lines from the Houses.txt text file:
61 Loop street
4
83 Church street
2
Code has been provided for the declaration of the text file variable tFile.
Write code to do the following:
Assign the text file Houses.txt to the variable tFile.
Ensure that reading from the text file starts from the first line in the text file.
Read through the text file using a loop and save the street address and
number of bedrooms into separate variables.
Display the street address and the number of bedrooms in the rich edit
redQ1_3 in the format below.
<street address> - <number of bedrooms> -bedroom house
Copyright reserved Please turn over
Information Technology/P1 7 DBE/November 2024
NSC Confidential
Example of output:
(9)
1.4 Button [1.4 - Add name]
Learners at a school are going on an excursion. Two rich edit components
redQ1_4_P and redQ1_4_NP have been provided to display the names of the
learners who have paid their fees and the learners who have not paid their
fees respectively.
The combo box cmbQ1_4 contains the names of all the learners going on the
excursion.
Write code to do the following:
Extract the name selected from the combo box cmbQ1_4.
If the 'Paid' check box chbQ1_4 is checked, the name of the learner must
be added to the redQ1_4_P component, otherwise the name must be
added to the redQ1_4_NP component.
Remove the selected name from the combo box cmbQ1_4.
Example of input and output if Bianca was selected and her excursion fees
were already paid:
Example of input and output if Godfrey was selected and his excursion fees
were not paid:
Copyright reserved Please turn over
Information Technology/P1 8 DBE/November 2024
NSC Confidential
Example of the content of cmbQ1_4 after Bianca and Godfrey were selected
and their names have been removed from the combo box:
(7)
1.5 Button [1.5 - Replace]
A password must be compiled for each learner attending the excursion.
The user must enter the name and surname of the learner in the edit box
edtQ1_5.
The following code has been provided:
The content of the edit box edtQ1_5 has been saved in the variable
sNameSurname.
A string sCharacters that contains six special characters
sCharacters := '@#$%^&';
Write code to do the following to create the password:
Reverse the characters and remove all the spaces in the
sNameSurname string.
Display the reversed string, without spaces, in the memQ1_5 output area.
Replace every third character in the reversed string with a special
character randomly selected from the provided sCharacter string.
Display the password in the memQ1_5 output area.
Example of input and output:
(9)
Enter your examination number as a comment in the first line of the program file.
Save your program.
Print the code if required.
TOTAL SECTION A: 40
Copyright reserved Please turn over
Information Technology/P1 9 DBE/November 2024
NSC Confidential
SECTION B
QUESTION 2: DATABASE PROGRAMMING
The organisers of athletic events require an application for running enthusiasts to
provide them with information about marathons and the locations.
A database called MarathonsDB.mdb, which contains information about marathon
names and the cities where they are held, has been developed. It allows users to find
marathons in their preferred cities.
The database contains two tables called tblLocations and tblMarathons.
NOTE: The data pages attached at the end of the question paper provide
information on the design of the MarathonsDB.mdb database and its
contents.
Do the following:
Open the incomplete project file called Question2_P.dpr in the Question 2 folder.
Enter your examination number as a comment in the first line of the
Question2_U.pas unit file.
Compile and execute the program. The program has no functionality currently. The
contents of the tables are displayed, as shown below on the selection of tab sheet
2.2 - Delphi code.
Copyright reserved Please turn over
Information Technology/P1 10 DBE/November 2024
NSC Confidential
Follow the instructions below to complete the code for each section, as described
in QUESTION 2.1 and QUESTION 2.2.
Use SQL statements to answer QUESTION 2.1 and Delphi code to answer
QUESTION 2.2.
NOTE:
The ꞌRestore databaseꞌ button is provided to restore the data contained in the
database to the original content.
The content of the database is password-protected, i.e. you will NOT be able to
gain access to the content of the database using Microsoft Access.
Code is provided to link the GUI components to the database. Do NOT change any
of the code provided.
TWO variables are declared as public variables, as described in the table below.
Variable Data type Description
tblLocations TADOTable Refers to the table tblLocations
tblMarathons TADOTable Refers to the table tblMarathons
2.1 Tab sheet [2.1 - SQL]
Example of the graphical user interface (GUI) for QUESTION 2.1:
Copyright reserved Please turn over
Information Technology/P1 11 DBE/November 2024
NSC Confidential
NOTE:
Use ONLY SQL statements to answer QUESTION 2.1.1 to
QUESTION 2.1.5.
Code to execute the SQL statements and display the results of the queries
is provided. The SQL statements assigned to the variables sSQL1,
sSQL2, sSQL3, sSQL4 and sSQL5 are incomplete.
Complete the SQL statements to perform the tasks described in
QUESTION 2.1.1 to QUESTION 2.1.5 below.
2.1.1 Button [2.1.1 - Low population]
Display all fields of the records in the tblLocations table with a
population of less than 200 000 people.
Example of output:
(3)
2.1.2 Button [2.1.2 - Runners United September runs]
Display the MarathonID, MarathonDate and Distance of all the
marathons organised by Runners United taking place during
September.
Example of output:
(4)
2.1.3 Button [2.1.3 - Marathon locations]
The location of each marathon is required by the organisers.
Concatenate the City field and the first three letters of the Province
field of all the locations in the tblLocations table, in a new field called
Location.
The content of the new Location field must be in the following format:
<City> - <First three letters of province>
Copyright reserved Please turn over
Information Technology/P1 12 DBE/November 2024
NSC Confidential
Example of output of the first five records:
(4)
2.1.4 Button [2.1.4 - Add city]
A city must be added to the tblLocations table. The details are
provided in the table below.
Field Value
LocationID 19
City Welkom
Province Free State
Altitude 1198
Population 423016
Example of output of the last five records after the city has been
added:
(4)
2.1.5 Button [2.1.5 - High prize money]
Display the city, the number of marathons and the total prize money
of all the marathons held in the city, only if the total prize money is
more than R50 000.
The new field for the number of marathons is NumMarathons and
the new field for the total prize money is Total Prize Money.
Example of output:
(7)
Copyright reserved Please turn over
Information Technology/P1 13 DBE/November 2024
NSC Confidential
2.2 Tab sheet [2.2 - Delphi code]
NOTE:
Use ONLY Delphi programming code to answer QUESTION 2.2.1 and
QUESTION 2.2.2.
NO marks will be awarded for SQL statements in QUESTION 2.2.
Example of the graphical user interface (GUI) for QUESTION 2.2:
2.2.1 Button [2.2.1 - Remove marathons]
Some organisers withdrew from the marathons and these marathonsꞌ
records must be removed as they will no longer take place.
The organiser's name must be entered by the user.
Code has been provided to extract and store the name of the
organiser, using an input dialog box. The name of the organiser is
stored in the variable sOrganiser.
Write code to remove the records from the tblMarathons table,
where the name of the organiser is the same as the name of the
organiser entered.
Copyright reserved Please turn over
Information Technology/P1 14 DBE/November 2024
NSC Confidential
Example of the first four records in the tblMarathons table before
the organiser, Active Events, is deleted:
Example of the first four records in the tblMarathons table after the
organiser, Active Events, is deleted:
(5)
2.2.2 Button [2.2.2 - Qualifying marathons]
The runners training for long-distance marathons must compete in
qualifying marathons to be eligible for entry. A qualifying marathon
is any marathon that is run over a distance of 40 km or more.
A city name must be entered using an input dialog box and then all
the qualifying marathons in that city must be displayed.
Code has been provided to:
Clear the content of the redQ2_2_2 component
Extract and store the city name that was entered in the variable
sCity
Use the redQ2_2_2 component to display the output.
Write code to do the following:
Display the marathon name and distance of all the qualifying
marathons from the tblMarathons table, for the city name that
was entered, using the input box provided.
Display a suitable message if the city name entered cannot be
found in the tblLocations table.
Copyright reserved Please turn over
Information Technology/P1 15 DBE/November 2024
NSC Confidential
Example of output if Paarl is entered as input:
Example of output if Sasolburg is entered as input:
(13)
Enter your examination number as a comment in the first line of the program file.
Save your program.
Print the code if required.
TOTAL SECTION B: 40
Copyright reserved Please turn over
Information Technology/P1 16 DBE/November 2024
NSC Confidential
SECTION C
QUESTION 3: OBJECT-ORIENTATED PROGRAMMING
You have been tasked by the World Marathon Association to assist with managing the
information of record holders in marathons.
Do the following:
Open the incomplete program in the Question 3 folder.
Open the incomplete object class MRecord_U.pas.
Enter your examination number as a comment in the first line of both the
Question3_U.pas file and the MRecord_U.pas file.
Compile and execute the program. The program has limited functionality currently.
Example of the graphical user interface (GUI):
Complete the code as specified in QUESTION 3.1 and QUESTION 3.2 that follow.
NOTE: You are NOT allowed to add any additional attributes or user-defined
methods, unless explicitly stated in the question.
Copyright reserved Please turn over
Information Technology/P1 17 DBE/November 2024
NSC Confidential
3.1 The provided incomplete object class (MRecord) contains the declaration of
five attributes, which describe a Marathon Record object.
The attributes for a Marathon Record object have been declared as follows:
Attribute Type Description
fMarathonName String The name of the marathon
fRecordHolder String The name of the person that currently
holds the record
fRecordDate String The record date in the format yyyy/MM/dd
fRecordTime String The record time in the format hh:mm:ss
fDistance Real The distance of the marathon
The following methods have also been provided:
A partially completed constructor method
The mutator methods setRecordHolder, setRecordDate and
setRecordTime
An auxiliary method toMinutes that receives a runnerʹs time as a string
parameter, in the format hh:mm:ss, and returns the record time in minutes
as a real data type
Complete the code in the object class as described in QUESTION 3.1.1 to
QUESTION 3.1.5 below.
3.1.1 The incomplete constructor method receives five parameters.
Write code to assign the parameters to the fMarathonName,
fRecordHolder, fRecordDate, fRecordTime and fDistance
attributes respectively. (3)
3.1.2 Write code for an accessor method called getRecordTime to
return the fRecordTime attribute. (2)
3.1.3 Write code for a method called checkRecord that receives a
runnerʹs time as a string parameter and returns a Boolean value.
The method should compare the current record time stored in the
fRecordTime attribute, with the time received as a parameter.
Return 'True' if the runner's time received as a parameter is less
than the fRecordTime attribute value and 'False' if not. (5)
Copyright reserved Please turn over
Information Technology/P1 18 DBE/November 2024
NSC Confidential
3.1.4 The runnerʹs pace is the speed at which a runner completes a
marathon, measured in minutes per kilometre.
The following formula can be used to calculate a runnerʹs pace:
𝑚𝑖𝑛𝑢𝑡𝑒𝑠
𝑝𝑎𝑐𝑒 =
𝑑𝑖𝑠𝑡𝑎𝑛𝑐𝑒
Write code for a method called calcPace that uses the provided
toMinutes method and the provided formula to calculate and
return the runnerʹs pace as a real value. (4)
3.1.5 Write code for a method called toString to return a string in the
following format:
<fMarathonName> - <fDistance> km: <fRecordHolder>
(<fRecordTime> on <fRecordDate>)
Example:
Karoo Marathon - 42.2 km: Sam Peterson (02:08:38 on
2024/06/13) (5)
3.2 An incomplete program has been supplied in the Question 3 folder. The
program contains code for the object class to be accessible and declares an
object variable called objMRecord.
Code has been provided in btnQ3_2_1, btnQ3_2_2 and btnQ3_3_3 to clear
the output area.
Write code to perform the tasks described in QUESTION 3.2.1 to
QUESTION 3.2.3 that follow.
3.2.1 Button [3.2.1 - Instantiate object]
Sam Peterson is the current record holder of the Karoo Marathon.
The current record information for the Karoo Marathon is recorded
as follows:
Marathon name Karoo Marathon
Record holder Sam Peterson
Date record was set 2024/06/13
Marathon record time 02:08:38
Distance of marathon 42.2 km
Code has been provided to extract the name of the marathon, the
name of the record holder, the date that the record was set and the
record time that was recorded from the relevant edit boxes.
Copyright reserved Please turn over
Information Technology/P1 19 DBE/November 2024
NSC Confidential
Write code to do the following:
Extract the marathon distance from the radio group rgpQ3_2_1
as a real value. The unit 'km' must not be saved as part of the
distance value.
Use the information extracted to instantiate the objMRecord
object.
Display the details of the object in the output area redQ3, using
the toString method.
Example of input and output:
(8)
3.2.2 Button [3.2.2 - Pace]
The pace of the record holder needs to be calculated.
Write code to call the calcPace method and display the result,
rounded to THREE decimal places, in the redQ3 component in the
following format:
Record holder’s pace: <Pace of record holder> min/km
Copyright reserved Please turn over
Information Technology/P1 20 DBE/November 2024
NSC Confidential
Example of input and output:
(4)
3.2.3 Button [3.2.3 - Check record]
The details of the current record holder object must be replaced if
another runner completes the marathon in a shorter time.
The user must enter the name and the time it took the new runner
to complete the marathon in the edit boxes edtQ3_2_3_Name and
edtQ3_2_3_Time respectively.
Write code to do the following:
Call the checkRecord method with the new runner's time as an
argument to determine if the new runner's time entered is less
than the current record time of the object.
If the new runner's time is less than the current record time:
o Update the current record object by using the following
methods and arguments:
Methods Arguments
setRecordHolder New runner's name
setRecordTime New runner's time
setRecordDate System date
o Display the updated object information in the output area
redQ3 using the toString method.
Copyright reserved Please turn over
Information Technology/P1 21 DBE/November 2024
NSC Confidential
If the new runner's time is more than the object's current record
time, display the current record time in the redQ3 component in
the following format:
The current record time remains: <Current record time>
Example of input and output if the new runner's time is more than
the current record time:
Example of input and output if the new runner's time is less than
the current record time:
(9)
Enter your examination number as a comment in the first line of the object class
and the form class.
Save your program.
Print the code in the object class and the form class if required.
TOTAL SECTION C: 40
Copyright reserved Please turn over
Information Technology/P1 22 DBE/November 2024
NSC Confidential
SECTION D
QUESTION 4: PROBLEM-SOLVING PROGRAMMING
Do the following:
Open the incomplete program in the Question 4 folder.
Enter your examination number as a comment in the first line of the Quest4_U.pas
file.
Compile and execute the program. The program has limited functionality currently.
Example of the graphical user interface (GUI):
The following arrays have been provided in the program:
An array, arrMarathons, which contains the names of ten marathons that have
been completed by a participant in the past. It must be noted that a participant may
have participated in a marathon more than once.
arrMarathons: array [1 .. 10] of String = ('Wally Hayward',
'Sasol','Soweto','Jacaranda City','Sasol','Durban City','Soweto',
'Soweto','Wally Hayward','Soweto');
Copyright reserved Please turn over
Information Technology/P1 23 DBE/November 2024
NSC Confidential
A two-dimensional array, arrChar, that stores alphabetical characters. The names
of nine different marathons are hidden in the rows of this array, amongst the other
characters.
arrChar: array [1 .. 14, 1 .. 14] of char = (
('u', 'x', 'v', 'm', 's', 'a', 's', 'o', 'l', 'f', 'k', 'j', 't', 'r'),
('u', 'm', 'g', 'e', 'n', 'i', 'w', 'a', 't', 'e', 'r', 'd', 's', 'e'),
('g', 'v', 'o', 'e', 't', 'v', 'a', 'n', 'a', 'f', 'r', 'i', 'k', 'a'),
('e', 'p', 'o', 'y', 'i', 'l', 'c', 'k', 'h', 'j', 's', 'd', 'f', 'd'),
('n', 'k', 'n', 'y', 's', 'n', 'a', 'f', 'o', 'r', 'e', 's', 't', 'u'),
('i', 's', 'y', 'd', 'b', 'c', 'r', 'g', 'h', 'k', 'c', 's', 'a', 'r'),
('w', 'a', 'l', 'l', 'y', 'h', 'a', 'y', 'w', 'a', 'r', 'd', 's', 'b'),
('a', 's', 'q', 'r', 't', 'n', 'n', 'j', 'h', 'e', 'r', 't', 'h', 'a'),
('t', 'o', 'e', 'r', 'y', 'b', 'd', 'r', 'h', 'k', 'l', 'g', 'd', 'n'),
('e', 'j', 'a', 'c', 'a', 'r', 'a', 'n', 'd', 'a', 'c', 'i', 't', 'y'),
('r', 'y', 'j', 'f', 'g', 'f', 'c', 'f', 'g', 'u', 'h', 'v', 'c', 'i'),
('k', 'h', 'h', 'l', 'p', 'h', 'i', 'l', 'l', 'c', 'r', 'e', 's', 't'),
('a', 'd', 'e', 'v', 'd', 's', 'o', 'w', 'e', 't', 'o', 'm', 'k', 'y'),
('p', 'd', 'u', 'r', 'b', 'a', 'n', 'c', 'i', 't', 'y', 'z', 'c', 'l'));
Complete the code for each section of QUESTION 4, as described in QUESTION 4.1
and QUESTION 4.2 below.
4.1 Button [4.1 - Count marathons]
Use the provided array called arrMarathons that contains the names of ten
marathons, which a runner has participated in over the past five years. The
runner took part in some of the marathons more than once, hence the
repetition of marathon names in the array.
Code has been provided for the alignment and to display the headings in the
redQ4_1 rich edit.
Write code to do the following:
Display the marathon name and the number of times the runner participated
in each marathon in the redQ4_1 component, as shown in the output below.
Example of output for the content in the array arrMarathons:
(11)
Copyright reserved Please turn over
Information Technology/P1 24 DBE/November 2024
NSC Confidential
4.2 A mystery word puzzle game was developed to create awareness of the
different marathons.
Example of the graphical user interface (GUI):
NOTE: Code has been provided for a method called display2D that displays
the array arrChar in the rich edit redQ4_2.
Combo box [cmbQ4_2]
The mystery word puzzle game uses characters placed in the provided
two-dimensional array called arrChar, containing 14 rows and 14 columns.
Nine marathon names are provided in the combo box cmbQ4_2 and these
names are also hidden among the characters in the rows of the array
arrChar. The hidden marathon names are placed horizontally in the rows of
the array arrChar from left to right.
Write code to do the following:
Extract the selected marathon name from the combo box cmbQ4_2.
Find the marathon name selected that is hidden in array arrChar.
Use the memQ4_2 to display the row and column values of the selected
word in the following format:
Row <Row index> @ column <Start col index> to <End col index>
Copyright reserved Please turn over
Information Technology/P1 25 DBE/November 2024
NSC Confidential
Change the characters of the selected marathon name in the array
arrChar to upper case.
Call the method display2D to display the array arrChar to show the
selected word in upper case.
Example of input and output if the marathon name 'knysnaforest' was
selected from the combo box cmbQ4_2:
(19)
NOTE: A Reset button was provided to reset the characters in the
two-dimensional array back to lower case.
Enter your examination number as a comment in the first line of the program file.
Save your program.
Print the code if required.
TOTAL SECTION D: 30
GRAND TOTAL: 150
Copyright reserved
Information Technology/P1 1 DBE/November 2024
NSC Confidential
INFORMATION TECHNOLOGY P1
DATABASE INFORMATION FOR QUESTION 2:
The design of the database tables is as follows:
Table: tblLocations
This table contains the details of each location.
Field name Data type Description
LocationID (PK) Number A unique ID that identifies a location
City Text (20) The name of the city where the location is
Province Text (15) The name of the province where the city is
located
Altitude Number The altitude of the location
Population Number The population of the city
Example of the first ten records of the tblLocations table:
Table: tblMarathons
This table contains information on the marathons available in each location.
Field name Data type Description
MarathonID (PK) Number A unique ID that identifies the marathon
MarathonName Text (30) The name of the marathon
MarathonDate Date/Time The date on which the marathon takes place
Distance Number The distance of each marathon
PrizeMoney Currency The prize money awarded to the winner of the
marathon
Organiser Text (25) The name of the organiser of the marathon
LocationID (FK) Number The ID of the location where the marathon takes
place
Copyright reserved Please turn over
Information Technology/P1 2 DBE/November 2024
NSC Confidential
Example of the first ten records of the tblMarathons table:
NOTE:
Connection code has been provided.
The database is password-protected; therefore, you will not be able to access the
database directly.
The following one-to-many relationship with referential integrity exists between the two
tables in the database:
Copyright reserved
Information Technology/P1 DBE/November 2024
NSC Confidential
PLANNING PAGE 1
Copyright reserved
Information Technology/P1 DBE/November 2024
NSC Confidential
PLANNING PAGE 2
Copyright reserved
Information Technology/P1 DBE/November 2024
NSC Confidential
Examination sticker
_______
150
INFORMATION TECHNOLOGY P1 – NOVEMBER 2024
INFORMATION SHEET (to be completed by the candidate AFTER the 3-hour exam session)
CENTRE NUMBER ______________________________________________________
EXAMINATION NUMBER _________________________________________________
WORK STATION NUMBER ________________________________________________
Version of Delphi used during the INFORMATION TECHNOLOGY NSC NOV 2024 Examination:
Mark appropriate Other:
box with a cross Delphi Delphi Delphi Delphi Delphi Delphi
(Specify)
(X ) 10 XE 10.3 Community 11 12
________
FOLDER NAME _________________________________________________________
Candidate must enter the file name(s) used for each answer. Tick if saved and/or attempted.
Marker
Question File name Saved Attempted Maximum Mark Initial/
number () () Mark Achieved Code
Question1_P.
1 dproj 40
Question2_P.
2 dproj 40
MRecord_U. 19
pas
3
Question3_P. 21
dproj
Question4_P.
4 dproj 30
TOTAL 150
Comment: (for office/marker use only)
__________________________________________________________________________
__________________________________________________________________________
Copyright reserved
Study this subject
Recommended for this subject

Memorandum
Information Technology Grade 12 P1 2024 Memo (Eng)

Question paper
Information Technology Grade 12 P1 NSC November 2023 QP

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2022 QP

Question paper
Information Technology Grade 12 P1 NSC November 2022 QP

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2021 QP

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2021 QP
More from Grade 12 Information Technology

Memorandum
Information Technology Grade 12 P1 NSC June 2025 Memo (Eng)

Memorandum
Information Technology Grade 12 P2 2024 Memo (Eng)

Memorandum
Information Technology Grade 12 P1 2023 Memo (Afr)

Memorandum
Information Technology Grade 12 P2 2023 Memo (Afr)

Memorandum
Information Technology Grade 12 P2 2023 Memo (Eng)

Memorandum