Information Technology
Practical Assessment Task
Grade 11
2017
Phase 2:
Design
Brandon Coetzee
Grade 11M1
Basic Solution Design
IPO Table
Component
Input
Processing
Output
cbbUser
sUserType
If sUserType = sPassword
Display frmGuest/frAdmin
cbbEvents
sEventName
sEventName = cbbEvents.getIndex
sEventName, lblSelectedEvent
edtTeamName
edtScore
sTeamName
iScore
arrTeams[sTeamName.ID] = iScore
memScores
sedChickenBurgers
iQuantityChickBurgers
rPrice = rPrice + (iQuantityChickBurgers x rChickBurgersPrice)
rPrice
sedCokes
iQuantityCokes
rPrice = rPrice = (iQuantityCokes x rCokePrice)
rPrice
TOE Chart
Task
Object
Event
Display relevant event details by retrieving data from a database
btnJoinEvent
Click
Display prices of all selected products and final price
btnCechkout
Click
Create event by setting appropriate variables via a database
btnCreateEvent
Click
Update or submit a teams score
btnSubmitScore
Click
Display relevant form if user password matches user type
btnLogin
Click
Data Dictionary
Data Structures
Arrays
• arrTeams
· How: Each array index will represent the teams ID, which will store the score of the team, in order to display the team with the highest score.
· Where: frmSetScores, frmViewScores.
• arrAds
· How: Storing ads as keywords in an array in order to cycle through varies ads.
· Where: frmGuest.
Text Files
• tfFoods
· How: By storing a food item and its price separated by a comma on one line of a text file to store the data of food items.
· Where: frmFoods.
• tfDrinks
· How: By storing a drink item and its price separated by a comma on one line of a text file to store the data of drinks.
· Where: frmDrinks.
• tfMerch
· How: By storing a drink item and its price separated by a comma on one line of a text file to store the data of merchandise.
· Where: frmMerch.
Variables
• sUserType
· How: Storing the user type as a variable in order to identify the user.
· Where: frmGuest.
• sGuestPassword
· How: Storing the password to access the guest form.
· Where: frmLogin.
• sAdminPassword
· How: Storing the password to access the admin form.
· Where: frmLogin.
• rPrice
· How: Storing the price of all selected items in order to calculate the final price.
· Where: frmFoods, frmDrinks, frmMerch.
• sEventName
· How: Storing the name of the selected event in order to verify that the data being used is from the correct event.
· Where: frmGuest, frmViewEvents, frmSeats, frmMerch, frmDrinks, frmFoods.
• Varies other variables in order to store values from a database.
Database Design
• Table: Ads – Which of the sponsors will display ads.
• Table: Drinks – Which drinks will be sold and at what price.
• Table: Events – Events that are taking placing containing all the event details.
• Table: Foods – Which food products will be sold and at what price.
• Table: Merchandise – What merchandise will be sold and at what price.
• Table: Scores – Storing the participating teams and their scores.
• Table: Seats – Storing which seats will be available dur...