# Information Technology Grade 12 P1 NSC November 2020 Memo

> Grade 12 Information Technology Paper 1 memorandum from the NSC November Exam 2020 (English), 24 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/it-p1-nov-2020-eng-rewrite-no-memo/6073fd46-587a-4f69-a19d-6654997e3dbb
- Updated: 2026-09-27
- Subject: Information Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2020
- Exam period: NSC November Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 24

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Information Technology](https://www.hlayiso.com/library/grade-12/information-technology) › [Information Technology Grade 12 P1 NSC November 2020 Memo](https://www.hlayiso.com/library/it-p1-nov-2020-eng-rewrite-no-memo/6073fd46-587a-4f69-a19d-6654997e3dbb)

## About this document

Information Technology · Grade 12 · NSC November Exam · 2020. Memorandum, 24 pages. Read online or download the PDF.

Read it free online on the page above; download the PDF from there.

## Document text

Text extracted from the PDF. Layout, diagrams and tables may not survive extraction.

### Page 1

Downloaded from hlayiso.com

                          SENIOR CERTIFICATE/
                      NATIONAL SENIOR CERTIFICATE

                                    GRADE 12

                        INFORMATION TECHNOLOGY P1

                                NOVEMBER 2020(2)

MARKS: 150

TIME: 3 hours

              This question paper consists of 22 pages and 2 data pages.

Copyright reserved                                                         Please turn over

### Page 2

Downloaded from hlayiso.com
Information Technology/P1                    2.                         DBE/November 2020(2)
                                           SC/NSC

INSTRUCTIONS AND INFORMATION

1.        This question paper is divided into FOUR sections. Candidates must answer
          ALL the questions in ALL FOUR sections.

2.        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.

3.        This question paper is set with programming terms that are specific to the
          Delphi programming language.

4.        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.

5.        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.

6.        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.

7.        Routines, such as search, sort and selection, must be developed from first
          principles. You may NOT use the built-in features of Delphi for any of these
          routines.

8.        All data structures must be defined by you, the programmer, unless the data
          structures are supplied.

9.        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.

10.       Make sure that your examination number appears as a comment in every
          program that you code, as well as on every event indicated.

11.       If required, print the programming code of all the programs/classes that you
          completed. You will be given half an hour printing time after the examination
          session.

12.       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

### Page 3

Downloaded from hlayiso.com
Information Technology/P1                    3.                          DBE/November 2020(2)
                                           SC/NSC

13.       The files that you need to complete this question paper have been given 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.

          NOTE: Candidates must use the file DataENGNovBackup2020.exe.

          Do the following:

              Double click on the password-protected executable file.
              Click on the extract button.
              Enter the following password: Ent&*%ain9

          Once extracted, the following list of files will be available in the folder
          DataENGNovBackup2020:

          SUPPLIED FILES:

          Question 1:
          HighScores.txt
          Question1_P.dpr
          Question1_P.dproj
          Question1_P.res
          Question1_U.dfm
          Question1_U.pas
          Rocket.bmp

          Question 2:
          ConnectDB_U.pas
          EntertainDB.mdb
          Question2_P.dpr
          Question2_P.dproj
          Question2_P.res
          Question2_U.dfm
          Question2_U.pas

          Question 3:
          Act_U.pas
          Qualify.bmp
          Question3_P.dpr
          Question3_P.dproj
          Question3_P.res
          Question3_U.dfm
          Question3_U.pas

          Question 4:
          Question4_P.dpr
          Question4_P.dproj
          Question4_P.res
          Question4_U.dfm
          Question4_U.pas

Copyright reserved                                                             Please turn over

### Page 4

Downloaded from hlayiso.com
Information Technology/P1                      4.                     DBE/November 2020(2)
                                             SC/NSC

SECTION A

QUESTION 1: GENERAL PROGRAMMING SKILLS

Do the following:

     Open the incomplete program for QUESTION 1 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 no functionality currently.
     The user interface used for QUESTION 1 displays four different sections called
      Question1.1 to Question1.4.

     Follow the instructions below to complete the code for EACH section as described
      in QUESTION 1.1 to QUESTION 1.4.

1.1        OnActivate event of the form

           Write code to do the following:

              Change the text on the panel pnlHeading to be displayed in bold.
              Load the Rocket.bmp image so that it fits in the image component,
               imgRocket.

Copyright reserved                                                          Please turn over

### Page 5

Downloaded from hlayiso.com
Information Technology/P1                   5.                        DBE/November 2020(2)
                                          SC/NSC

          Example of output when the program is executed:

                                                                                               (4)

1.2       Button [1.2 - Multiples of seven]

          The program must determine and display the multiples of seven between a
          range of integer numbers (excluding the lower and upper bound numbers).
          The user must enter the lower and upper bounds of the range of numbers in
          the edit boxes provided. Display the multiples of seven in the redQ1_2 rich
          edit component in one line.

          Example of output if the value of 12 was entered as the lower bound and 32
          was entered as the upper bound:

                                                                                               (12)

          Example of output if the value of 14 was entered as the lower bound and 49
          was entered as the upper bound:

1.3       List box

          Some celebrities replace their names on their dressing room doors with an
          encrypted version. The encryption is done by removing all the spaces and
          replacing the vowels in their names with the special characters shown below.

                             Vowel: a         e    i   o    u
              Replacement character: @        $    *   &    %

Copyright reserved                                                          Please turn over

### Page 6

Downloaded from hlayiso.com
Information Technology/P1                     6.                          DBE/November 2020(2)
                                            SC/NSC

          A list box, lstCelebrities, contains codes that represent the names of
          well-known celebrities, e.g. Ch@rl*zeTh$r&n, which represents the name
          Charlize Theron.

          The user must select a code from the list box. The program must decrypt the
          code and display the name in a dialogue box. The decryption must be done
          as follows:

             Replace all the special characters with the corresponding vowels.
             Each code starts with a capital letter. The next capital letter is that of the
              surname. Insert a space before the capital letter for the surname in the
              code.
             Display the decrypted name accordingly.

          Example of output if the code 'Ch@rl*zeTh$r&n' was selected:

                                                                                                    (12)

1.4       Button [1.4 - Highest score]

          A gamer saved the high scores that he achieved playing his favourite online
          game in a text file called HighScores.txt. The data is saved one score per
          line for each day of the week starting at day 1.

          Example of the contents of the text file:

          Write code to do the following:

             Read the data from the text file and determine the highest score
              achieved, as well as the number of the day of the week when this score
              was achieved.
             Display the highest score and the number of the day it was achieved on
              the label components provided.

          NOTE:       Hardcoding will NOT be accepted as the program must work for
                      any set of data contained in the text file.

Copyright reserved                                                               Please turn over

### Page 7

Downloaded from hlayiso.com
Information Technology/P1                7.                       DBE/November 2020(2)
                                       SC/NSC

          Example of output:

                                                                                           (12)

   Ensure that your examination number has been entered 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

### Page 8

Downloaded from hlayiso.com
Information Technology/P1                    8.                        DBE/November 2020(2)
                                           SC/NSC

SECTION B

QUESTION 2: DATABASE PROGRAMMING

A school is organising a cultural festival which will be held from 12 to 18 April 2021.
A variety of productions will be staged and tickets for the productions may be bought
during the festival.

A database called EntertainDB and an incomplete project called Question2_P
are provided in the Question 2 folder. The database contains two tables, namely
tblProductions and tblTickets with data related to the festival that will be held during
April 2021.

The data pages at the end of the question paper provide information on the design of
the 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 file.
   Compile and execute the program. The program has no functionality currently.

    The following user interface is displayed:

Copyright reserved                                                           Please turn over

### Page 9

Downloaded from hlayiso.com
Information Technology/P1                      9.                         DBE/November 2020(2)
                                             SC/NSC

     Follow the instructions below to complete the code for each section, as described
      in QUESTION 2.1 and QUESTION 2.2.
     Use SQL code 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. If you need to test your code on the original data,
      you may click this button to restore the data.
     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
      tblProductions        TADOTable        Refers to the table tblProductions
      tblTickets            TADOTable        Refers to the table tblTickets

2.1        Tab sheet [Question 2.1 - SQL]

           You may use ONLY SQL statements in this section 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 are incomplete.

           The following user interface is displayed:

Copyright reserved                                                               Please turn over

### Page 10

Downloaded from hlayiso.com
Information Technology/P1                       10.                       DBE/November 2020(2)
                                              SC/NSC

          Do the following:

          Complete the SQL statement for the given string variable named sSQL in
          each of the questions.

          2.1.1      Button [2.1.1 - Productions]

                     Display ALL the fields from the tblProductions table, sorted
                     according to duration in ascending order.

                     Example of output for the first five records:

                                                                                                   (3)

          2.1.2      Button [2.1.2 - Genre]

                     The user must enter the name of a genre in the edtGenre edit box
                     provided. Display the title and age restriction of the productions of
                     the genre that has been entered.

                     Example of output if the genre entered is 'Drama':

                                                                                                   (4)

          2.1.3      Button [2.1.3 - Average duration]

                     Display the average duration of all productions in the
                     tblProductions table, rounded to THREE decimal digits. Display the
                     calculated field with the heading 'AverageDuration'.

                     Example of output:

                                                                                                   (4)

Copyright reserved                                                              Please turn over

### Page 11

Downloaded from hlayiso.com
Information Technology/P1                      11.                        DBE/November 2020(2)
                                             SC/NSC

          2.1.4      Button [2.1.4 - Ticket sales]

                     Display the title and the total number of tickets sold for each
                     production. Use the heading 'Number of tickets sold' for the
                     calculated field.

                     Example of output for the first five records:

                                                                                                    (7)

          2.1.5      Button [2.1.5 - 25% discount]

                     The festival organisers declared that all tickets for seats in rows C,
                     D, E and F for any production during the show that starts at 10:00
                     must receive a 25% discount.

                     Complete the code to update the database to reflect the discounted
                     prices.

                     NOTE:     Indicate the time as 10.00 instead of 10:00, because using
                               time in SQL statements in Delphi requires the substitution
                               of the colon (':') with a full stop ('.').

                     Example of output of the first five records:

                     NOTE:     The date format may differ from the screenshot.
                                                                                                    (7)

2.2       Tab sheet [Question 2.2 - Delphi code]

          In this section only Delphi programming code may be used to answer
          QUESTION 2.2.1 to QUESTION 2.2.3.

          NO marks will be awarded for SQL statements in QUESTION 2.2.

          The user interface for QUESTION 2.2 is shown on the next page.

Copyright reserved                                                               Please turn over

### Page 12

Downloaded from hlayiso.com
Information Technology/P1                     12.                         DBE/November 2020(2)
                                            SC/NSC

          2.2.1      Button [2.2.1 - What is the title?]

                     Write code to replace the question mark ('?') in the label lblTitle to
                     display the title of the currently selected production in the
                     tblProductions table.

                     Example of output if the first record is currently selected in the
                     tblProductions table:

                                                                                                   (2)

          2.2.2      Button [2.2.2 - Update duration]

                     The user interface automatically displays the duration of the
                     production currently selected in the tblProductions table. When the
                     user clicks the button, provided code will request the user to enter
                     the new duration for the production in minutes using an input box.

                     Write code to change the duration of the production record currently
                     selected in the tblProductions table to the value that has been
                     entered.

Copyright reserved                                                              Please turn over

### Page 13

Downloaded from hlayiso.com
Information Technology/P1                     13.                        DBE/November 2020(2)
                                            SC/NSC

                     Example of input if the duration for the production Seriaas must be
                     100 minutes instead of 87 minutes:

                     Example of output after the duration of the selected production was
                     changed:

                                                                                                  (3)

          2.2.3      Button [2.2.3 - Display ticket sales]

                     The festival manager needs a report to show all the tickets sold for
                     a production on a specific day. The user must select the specific day
                     in April from the radio group named rgpWhichDay.

                     Write code to display the starting time, the seat number booked and
                     the price of each ticket sold for the selected production on the
                     selected day.

                     NOTE:
                      Code has been provided to display the headings.
                      The information must be displayed in neat columns below the
                       headings.
                      The prices of the tickets must be displayed in currency format.

                     Example of output if the production Hamlet was selected for
                     12 April 2021:

Copyright reserved                                                             Please turn over

### Page 14

Downloaded from hlayiso.com
Information Technology/P1                   14.                     DBE/November 2020(2)
                                          SC/NSC

                     Example of output if the production Half-leeg was selected for
                     16 April 2021:

                                                                                             (10)

   Ensure that your examination number has been entered 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

### Page 15

Downloaded from hlayiso.com
Information Technology/P1                    15.                      DBE/November 2020(2)
                                           SC/NSC

SECTION C

QUESTION 3: OBJECT-ORIENTATED PROGRAMMING

The results for the semi-final round for the Teenagers Got Talent show must be
captured to determine which acts qualify for the final round.

An act qualifies for the final round if more than 600 members of the audience voted for
the act or if the act received a special vote from the judges, which means that it
automatically qualifies for the final round.

Do the following:

   Open the incomplete program in the folder Question 3.
   Open the incomplete object class Act_U.pas.
   Enter your examination number as a comment in the first line of both the
    Question3_U.pas file and the Act_U.pas file.
   Compile and execute the program. The program has no functionality currently.

    The following user interface is displayed:

   Complete the code as specified in QUESTION 3.1 for the Act_U object class and in
    QUESTION 3.2 for the Question3_U form class.

Copyright reserved                                                          Please turn over

### Page 16

Downloaded from hlayiso.com
Information Technology/P1                      16.                         DBE/November 2020(2)
                                             SC/NSC

3.1       The incomplete object class (TAct) provided contains the following:

              Declarations of four attributes that define an Act object
              A completed toString method to display the attributes

          The attributes for the Act object have been declared as follows:

              Names of attributes      Description
              fActDescription          Description of the act
              fPreQualify              A Boolean value of 'true' indicating that the act
                                       prequalified for the final round or 'false' if not
              fAudienceSize            The total number of people in the audience
                                       attending the semi-final round
              fAudienceVotes           The number of votes received from members of
                                       the audience

          3.1.1      Write code for a constructor method that will receive the description
                     of the act, a Boolean value indicating whether the act prequalified for
                     the final round or not and the total number of members in the
                     audience as parameter values. Assign these values to the
                     respective attributes.

                     Set the number of votes received from the audience to zero.                     (5)

          3.1.2      Write code for an accessor method called getActDescription for the
                     attribute that describes the act.                                               (3)

          3.1.3      Write code for a mutator method called setAudienceVotes that
                     receives the number of audience members who voted for the act
                     and updates the relevant attribute.                                             (3)

          3.1.4      Write code for a method called checkStatus that will return
                     a Boolean value that indicates whether the act qualifies for the final
                     round or not.

                     An act qualifies for the final round if any one of the following
                     requirements are met:

                        More than 600 members of the audience voted for the act.
                        The act already qualified for the final round.                              (7)

3.2       An incomplete unit Question3_U has been provided and contains code for
          the object class to be accessible.

          The following code is provided:

              A globally declared object variable objAct
              A globally declared variable called iAudienceSize. A randomly generated
               value in the range 700 to 800 is assigned to iAudienceSize in the
               OnChange event of the combo box cmbActs.
              Code in the [Reset] button that will restore the properties of the
               components to its original state
Copyright reserved                                                                Please turn over

### Page 17

Downloaded from hlayiso.com
Information Technology/P1                        17.                       DBE/November 2020(2)
                                               SC/NSC

          Do the following to complete the                code   for   QUESTION   3.2.1    to
          QUESTION 3.2.3 in the main form unit:
          3.2.1      Button [3.2.1 - Instantiate act object]
                     The user must do the following:

                        Choose the description of the act from the combo box.
                        Select the chkPreQualified check box to indicate whether or not
                         the act already qualified for the final round.
                     Write code to do the following:
                        Use the description of the act, the audience size and the Boolean
                         value from the check box indicating whether the act prequalified
                         or not, and instantiate an Act object.
                        Display a message to indicate that the object has been
                         instantiated.                                                                (7)
          3.2.2      Button [3.2.2 - Cast votes]
                     Write code to do the following:
                        Extract the number of votes received from the audience for the
                         act.
                        If the number of votes received from the audience is more than
                         the total size of the audience, then display a message 'Invalid'
                         and return the focus to the edit box edtAudienceVotes.
                        If the number of votes is less or equal to the total size of the
                         audience, then use the setAudienceVotes method to set the
                         value of the attribute of the object.                                       (6)
          3.2.3      Button [3.2.3 - Result]
                     Write code to determine whether the act qualifies for the final round
                     using the checkStatus method.
                     NOTE: The panels, pnlQualify and pnlNotQualify, are the same
                           size and placed in the exact same position on the GUI.
                           Therefore, the one panel is hidden behind the other panel.
                     If an act qualifies for the final round:
                        Set the panel pnlQualify to be visible and hide the panel
                         pnlNotQualify.
                        Use the relevant accessor method to get the description of the
                         act and display it on the label lblQualify.
                     If an act does NOT qualify for the final round:
                        Set the panel pnlNotQualify to be visible and hide the panel
                         pnlQualify.
                        Display the information of the object in the redNotQualify output
                         area using the toString method.

Copyright reserved                                                                Please turn over

### Page 18

Downloaded from hlayiso.com
Information Technology/P1                      18.                          DBE/November 2020(2)
                                             SC/NSC

                     Example of input and output if an act qualified for the final round:

                     NOTE:     The total number of people in the audience is randomly
                               generated and may differ from the number shown on the
                               user interface when you execute the program.

                     Example of input and output if an act does NOT qualify for the final
                     round:

                                                                                                     (9)

   Ensure that your examination number has been entered as a comment in the first
    line of the object class and the form class.
   Save all the files.
   Print the code if required.

                                                                      TOTAL SECTION C:               40

Copyright reserved                                                                Please turn over

### Page 19

Downloaded from hlayiso.com
Information Technology/P1                    19.                      DBE/November 2020(2)
                                           SC/NSC

SECTION D

QUESTION 4: PROBLEM-SOLVING PROGRAMMING

The French Embassy is offering students an opportunity to participate in a cultural
event. The stage names and languages of all participants are stored in two parallel
arrays. The manager must be able to add the information of new participants at the
event.

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
    Question4_U.pas file.
   Compile and execute the program. The program currently has limited functionality.

    The following user interface is displayed:

Code has been provided for the declaration of the following global variables, the
OnCreate event handler and the btnDisplay button.

The following have been provided:
   arrLanguages, which contains the names of the three languages that may be
    used at the cultural event:
    arrLanguages: array[1..3] of String = ('French', 'Afrikaans',
    'Zulu');
   arrNames that can store a maximum of 100 names of participants:
    arrNames: array[1..100] of String;

Copyright reserved                                                          Please turn over

### Page 20

Downloaded from hlayiso.com
Information Technology/P1                      20.                       DBE/November 2020(2)
                                             SC/NSC

     arrLangCode that can store a maximum of 100 codes. A code is the first letter of
      the language that the participant has chosen, e.g. the language 'French' will be
      represented by the character 'F' in the arrLangCode array.
      NOTE: The language isiZulu is saved as Zulu in the arrLanguage array and is
            represented by the character 'Z'.
        arrLangCode: array[1..100] of char;
     A variable iSize to keep track of the current number of participants in the arrNames
      array:
        iSize: integer;
     The OnCreate event handler contains code to set the iSize variable to ten and to
      populate parallel arrays arrNames and arrLangCode with the names and codes of
      the current ten participants.
     The 'Display participants' button contains code to display the current data stored in
      the arrays arrNames and arrLangCode.
     The data in the arrNames array has been sorted to display the names of the
      participants in alphabetical order, grouped by their language.
     The language groups must always start with French, followed by Afrikaans and then
      Zulu.

Example of output for the onClick event of the btnDisplay button:

Write code to perform the tasks described in QUESTION 4.1 and QUESTION 4.2 below.

4.1        Button [4.1 - Count]

           Calculate and display the total number of participants per language.

           Example of output for the original data in the arrays:

                                                                                                     (11)

Copyright reserved                                                                Please turn over

### Page 21

Downloaded from hlayiso.com
Information Technology/P1                     21.                       DBE/November 2020(2)
                                            SC/NSC

4.2       Button [4.2 - Add participant]

          The information of a new participant must be added by entering the name in
          the edtName edit box and selecting the language in the cmbLanguage
          combo box.

          Code has been provided to do the following:

             Extract the name from the edit box edtName and convert the name into
              the correct format for it to be added to the array. The format of the names
              in the array has the first letter in uppercase and all the other letters in
              lowercase, e.g. Sam.
             Extract the first letter of the language selected from the combo box
              cmbLanguage.

          Write code to do the following:

             Insert the name of the participant extracted from the edtName edit box to
              the correct position alphabetically in the sorted array arrNames.
             Insert the first letter of the language of the participant in the correct
              position in array arrLangCode.

          NOTE:      The language group order must always be French, Afrikaans and
                     then Zulu. Inserting a new participant and language code should
                     NOT change the alphabetical and/or language group order.

          Example of output if the name entered is Garner and the language selected is
          French:

Copyright reserved                                                            Please turn over

### Page 22

Downloaded from hlayiso.com
Information Technology/P1                22.                      DBE/November 2020(2)
                                       SC/NSC

          Example of output if the next name entered is Tessa and the language
          selected is Afrikaans:

                                                                                         (19)

   Ensure that your examination number has been entered 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
i

Copyright reserved

### Page 23

Downloaded from hlayiso.com
Information Technology/P1                        1.                            DBE/November 2020(2)
                                               SC/NSC

                             INFORMATION TECHNOLOGY P1(2)

QUESTION 2: DATABASE INFORMATION

The design of the database tables is as follows:

Table: tblProductions

This table contains the data for the various productions that will be performed at the
festival.

Field name       Data type     Size             Description
ProductionID     Number        Long Integer     Unique number assigned to each production
Title            Text          25               The title of the production, e.g. Half-leeg
Genre            Text          15               The genre of the production, e.g. Drama,
                                                Comedy, etc.
AgeRestriction   Text          15               The age restriction imposed on the production,
                                                e.g. 2-16, All ages
Duration         Number        Integer          The duration of the production in minutes,
                                                e.g. 112

Example of data:

Table: tblTickets

This table contains the data on the tickets currently sold to attend the various
productions.

Field name       Data type      Size             Description
TicketID         Number         Long Integer     Unique number assigned to each ticket bought
ProductionID     Number         Long Integer     A number assigned to each production
SeatNum          Text           5                The number of the seat the ticket was bought
                                                 for, e.g. B2 – which indicates that the seat is in
                                                 row B, seat number 2
ShowDate         DateTime       ShortDate        The date when the production will be attended
                                                 during the week of 12 to 18 April 2021
StartingTime     DateTime       ShortTime        The time slot the production will be attended.
                                                 The possible options are: 10:00, 15:00, 17:00
                                                 and 20:00.
Price            Currency                        The price of the ticket

Copyright reserved                                                                   Please turn over

### Page 24

Downloaded from hlayiso.com
Information Technology/P1                   2.                         DBE/November 2020(2)
                                          SC/NSC

Example of data of the first seven records:

  NOTE:      The date format may differ from the screenshot.

The following one-to-many relationship with referential integrity exists between the two
tables in the database:

Copyright reserved

## Related documents

- [IT P1 Nov 2020 Afr REWRITE (NO MEMO)](https://www.hlayiso.com/library/it-p1-nov-2020-afr-rewrite-no-memo/50e776f8-b245-4554-9243-5cf350cf10d2) — Information Technology · Memo · 2020 · Afr
- [IT P1 Nov 2020 Memo Afr](https://www.hlayiso.com/library/it-p1-nov-2020-memo-afr/85279e2b-2e1a-44a8-a2ac-7db9df151ff7) — Information Technology · Memo · 2020 · Afr
- [IT P1 Nov 2020 Afr](https://www.hlayiso.com/library/it-p1-nov-2020-afr/379269e7-3731-4176-9d26-e4f9cf72c167) — Information Technology · QP · 2020 · Afr
- [IT P2 Nov 2020 Memo Afr](https://www.hlayiso.com/library/it-p2-nov-2020-memo-afr/2ee707a9-42d6-4dd2-839d-9fe4f1661d4a) — Information Technology · Memo · 2020 · Afr
- [Information Technology P1 Nov 2017 Memo Eng](https://www.hlayiso.com/library/information-technology-p1-nov-2017-memo-eng/5a6ed3b8-fff3-4502-bac4-5e1e988da4fc) — Information Technology · Memo · 2017 · Eng
- [Information Technology P1 Nov 2015 Memo Afr](https://www.hlayiso.com/library/information-technology-p1-nov-2015-memo-afr/ed0f17ad-2120-4f04-b0c6-56098d626046) — Information Technology · Memo · 2015 · Afr

## More from Grade 12 Information Technology

- [IT-P2-GR12 QP-Afr-SEP-2025 watermark](https://www.hlayiso.com/library/it-p2-gr12-qp-afr-sep-2025-watermark/569cc299-ae7c-4635-9514-cf03f9242ebc) — QP · 2025 · Afr
- [IT P2 QP GR12 SEPT 2024 AFR](https://www.hlayiso.com/library/it-p2-qp-gr12-sept-2024-afr/9016098b-e233-49f4-b1dc-f0838363c6af) — QP · 2024 · Afr
- [IT P2 QP GR12 SEPT 2024 English](https://www.hlayiso.com/library/it-p2-qp-gr12-sept-2024-english/83309154-2856-47f1-82cc-cc04c8ab38b1) — QP · 2024 · Eng
- [Information Technology P1 Nov 2024 Afr](https://www.hlayiso.com/library/information-technology-p1-nov-2024-afr/f4b19c44-77ce-482a-9f85-438813c25f87) — QP · 2024 · Afr
- [Information Technology P2 Nov 2024 Eng](https://www.hlayiso.com/library/information-technology-p2-nov-2024-eng/3afa20d1-1c0f-4969-8a56-d690e9b24d70) — QP · 2024 · Eng
- [Information Technology P1 May-June 2023 MG Eng](https://www.hlayiso.com/library/information-technology-p1-may-june-2023-mg-eng/f868554b-8f4f-4370-aa4e-cfa745fc806d) — Memo · 2023 · Eng

## Collection

- [Grade 12 past papers](https://www.hlayiso.com/grade-12/past-papers)

---

Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.
