Skip to content

Information Technology Grade 12 P1 November 2024 NSC QP

Question paperInformation TechnologyGrade 12202430 pages

Grade 12 Information Technology Paper 1 question paper from the November 2024 NSC (English), 30 pages. Read online or download the free PDF.

Free to read online, no sign-up needed

Answer online

Loading document…

Loading document…

Questions in this paper

Document textSearch extracted text and jump to a page.
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
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

More from Grade 12 Information Technology

View all