_________________________________________________________________________
REMOTE LEARNING EXERCISES/WORKSHEETS
LEARNER EXERCISES
SUBJECT: IT
GRADE: 11 Term 3
TOPIC: Database connection
Prac Test 1 Data.zip
1
GRADE 11: INFORMATION TECHNOLOGY
(Database connection)
(Scenario and Database used from Eastern Cape September 2009 paper)
Scenario
The question deal with various aspects of a provincial hockey tournament taking place in
the Eastern Cape. The database, Data.mdb, supplied contains details of players and their
accommodation arrangements.
The database contains two tables named tblPlayers and tblVenues.
The tblVenues table stores data on the various venues where the players will be
accommodated during the tournament. The table consists of the following fields:
Field Name Type Description
VenueID Autonumber Primary key
Venue Text 50 Name of venue
Telephone Text 11 Venue telephone number
Beds Number Number of beds available
Booked Number Number of beds booked
The following table is an example of the data contained in the table named tblVenues:
Data about the players playing in the tournament are stored in the table tblPlayers. The
fields in this table are defined as follows:
Field Name Type Description
PlayerID AutoNumber Primary key
Player Text 40 Surname and initial of the player
DOB Date/Time Player’s date of birth
Cell Text 10 Player’s cell number
Team Text 3 Team of the player
Room Number Room number of the player
VenueID Number Venue of the player
The following table is an example of the first 10 records contained in the table named
tblPlayers:
2
Note the following:
▪ You have been supplied with an incomplete Delphi program with a unit named
Data_U and a project named Data_P.
▪ The program automatically connects to the supplied database Data.
▪ Complete the program by creating the necessary statements in the buttons named
btn1_1, btn1_2 etc. as indicated in QUESTIONS 1.1 – 1.6.
1 The program displays six buttons as well as two DBGrids and a RichEdit to use as
output components. Do the following:
1.1 Complete the code in the btn1_1 to display all the records from the team that the
user enters using an InputBox in the RichEdit. Example of the output if the user
enters the team as EC1:
(9)
1.2 Supply a list of players and their cell numbers of all the players that once stayed in
the Venue chosen from the provided ComboBox, cmbVenue. Display the list in
the RichEdit, redDisplay. Complete the code in the button named btn1_2.
Example of output if Zimbali Lodge was chosen:
3
(10)
1.3 Count the number of veterans competing in the tournament. Players are classified
as veterans if they turn 40 or older in the current year (2021). Complete the code
in the button named btn1_3 by displaying the number of veterans in a
Showmessage. Example of the output:
(12)
1.4 Some of the entries in the field named Team in the tblPlayers table are incorrectly
entered as 'WC3'. Complete the code in the button named btn1_4 by adding
statements to replace all entries of 'WC3' with 'WC2'. Display an appropriate
message when the data has been changed. (10)
1.5 The organisers want a list of the percentage of beds available at each of the
accommodation venues. Complete the code in the button named btn1_5 by
formulating statements to display the Venue, Beds and Booked fields as well as a
calculated field Free in the provided RichEdit, redDisplay. This field must display
the percentage of beds available, rounded to one decimal place. Example of the
first few lines of output:
(10)
1.6 The team ‘LP1’ decided to withdraw from the hockey tournament. Delete all (7)
entries of team ‘LP1’ from the table tblPlayers.
[58]
