Noah David Moonsamy
11B
IT PAT
Task 1:
Page 1 Cover Page
Page 2 Table Of Contents
Page 3 Task 1
Page 4 Task 2
Page 5 Task 3
Page 6 Task 3
Page 7 Task 3
Page 8 Task 4
Page 9 Task 5
Task 1-
For my project I have decided to create a user-
friendly program, which allows the user to make
scheduling appointments with fitness trainers easy
and more assessable. I chose this idea for my
project as it encourages people to get more exercise
thus improving their lifestyle.
It will make it more accessible to the Trainers and
their clients. It will allow the Trainers to be more
time efficient, and it will be simpler for older people
to interpret and understand. Clients will be able to
create appointments quickly leaving them stress
free and giving them more time in their day.
ADMIN The Admin is able to manage all the
information which is collected from the
members and new users and is stored in
the database. They are also required to
input specialized login information.
MEMBER The Members can set appointments and
are required to enter their personal
password.
NEW USER The New Users can sign up to the
program and add their information to set
appointments.
Task 2-
TextFile:
1. I am using four textfiles which include, Admin
Login, New User Login, Member Login and
Logintrack. The Admin Login, New User Login
and Member Login which are used to store
either store login information for verification
when logging in or to store new login
information. The logintrack is used to store
who logged in and at what time and date.
Arrays:
1. I have 2 Arrays which are used in this project.
The first one is used to sort the information in
ascending order and the second one is used to
store certain information in them to be used by
the admin.
Array 1 will be called Arrhigh and Array 2 will be
called Arrstore
I will have a procedure connected to the information
in the database which will allow me to access it
whenever necessary, called ‘INFO’. I will have many
string, integer and real datatypes including, sline,
shigh, spass, suser, i, icount, ihigh, ravg, rmon.
Task 3
TblDoc:
Field Name Field Type Size/descri
ption
PK Doctor_Nu Short Text 50
mber
Doctor_Na Short Text 100
me
Number_Of Short Text 50
_Clients
TblPat:
Field Name Field Type Size/descripti
on
Client_Numb Short Text 50
er
Name Short Text 100
Cellphone_N Short Text 12
umber
ID_Number Short Text 13
FK Doctor_Nmu Short Text 50
ber
Relationship
Task 5
Input Processing/ Output Component
Validation
Admin Login Details The code retrieves If the details are Edit Box
the information correct a user-friendly
inputted and output message will
determines whether be shown, and the
it matches the one admin will be taken to
in the textfile to the form where they
validate it. can edit information.
Editing the selected Takes the field Changes the older Button
field on the table selected by the user information on the
and allows them to table to the newer
change one.
information(Admins
only).
Member Login The code retrieves If the details are Edit Box
the information correct a user-friendly
inputted and output message will
determines whether be shown, and they
it matches the one will be taken to a form
in the textfile to where they can only
validate it. modify their own
information
New User Login The code retrieves If the details are Edit Box
the information correct a user-friendly
inputted and output message will
determines whether be shown, and they
it matches the one will be taken to a form
in the textfile to where they can add
validate it. their personal details
the tables
