





























Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
The problems faced by Akram Traders & Super Store while making bills manually and the solution proposed to automate the process. The new system would be more organized, user-friendly, and less time-consuming. details about the input, processing, and output of the new system, along with the data structure, validation tests, flow diagram, and program code. It also includes technical documentation on password protection and security measures.
Typology: High school final essays
1 / 37
This page cannot be seen from the preview
Don't miss anything!






























Akram Traders & Super Store has been in the field for the last four years. Mr.
Muhammad Akram successfully runs it. The store deals in every kind of product &
accessories. Muhammad Akram is also helped by five of his workers.
The store is run quite nicely but sometimes the problems of calculations occur as registers
and hard calculations are maintained so sometimes when making large bills a lot of time
may be consumed and as a result the customer may become irritated. Also due to
negligence wrong prices may be used due to which miscalculation may occur.
The processing would also take a lot of time as the customers would want a certain amount
of discount on the product so a lot of time will be consumed. Also there would not be any
record of transaction due to which the workers can alter the accounts.
The output would be a piece of paper on which the bill details would be written manually
in which errors can occur.
The new system would be a lot more organized and user-friendly. It would also be less
time consuming. The list of data input in the new system would be:
The processing would take place automatically and only the prices and quantity would be
input and the system would produce the results automatically.
The output would be in the form of a computerized printed receipt, which would be
having every single detail of the transaction.
Head &
Shoulder
DATA Structure
Field Type Size in
characters
Size in bytes Remarks
Receipt no. Numeric 4 Primary key
Date Date 8
Name Text 20 20
Product Text 15 15
Quantity Numeric 4
Price Numeric 4
Total Numeric 4
Discounts Numeric 4
Grand Total Numeric 4
Size of a single record 67 bytes
For 1000 records 67 x 1000 = 67000 = 67 KB.
Flow Diagram
Input of
transaction &
related items
Validation
Passwor
d
BILL File Calculation of
Bills
Screen
Corre
ct
CHAPTER 3
IMPLEMENTATION CODE
Features of Visual Basic
I used VB professional edition version 6.00 because file handling in Visual Basic is easier
for not only programming, but for users.
This is because it is the object orientated programming, and since it is in the GUI (Graphical
User Interface) format, it is much easier for the users. It is also easy to develop a solution
in visual basic. Modular solution can also be created with the help of this.
Method of creating a Solution
Objectives Procedure
Search System Using an “If” condition and “Do While”, I created a counter through
which if the text in the text field is the same as a record in the text file,
then it will display the data in the text fields.
Next/Previous
Buttons
The next and previous buttons work through a simple “If” statement to
ensure that it does not reach the end of file, and a simple counter that
will decrease or increase depending on whether it is going to the next or
previous record.
Create Button In the “Form Load”, a file is created and opened, the create button
simply, makes a space in the text file using a counter, while when the
button is pressed clicked upon, the counter adds 1 to itself giving new
space for the entry of data.
Save Button This button simply takes the data in the text fields and inserts them in
the text file where all the other records are.
Password
Verification
The verification simply takes place through an “If” statement, if the text
in the text field is equal to “Project”, it will allow the user to pass to the
next form, else it will present an error message.
New Button This button will display the new bill and will automatically display a
new receipt number and the date at which the transaction is made.
Presence
Check
Here, “If” statements were used to check if any data was entered in the
fields, otherwise it would pop an error message telling the user that the
text fields are empty.
First/Last
Button
Takes the user to the first and last record of the file.
Create Button In the “Form Load”, a file is created and opened, the create button
simply, makes a space in the text file using a counter, while when the
button is pressed clicked upon, the counter adds 1 to itself giving new
space for the entry of data.
Print Button This button simply prints out the bill receipt to the customer.
Data Structure
Proof of Files
This is the picture of the
text file where the record
will be saved
Viewing the records in the text
file through notepad
Searching in the bill Form for the Customer Name
All the output,
or all the bill
details of the
desired person
will be shown
on original add
member Form
Inputting the
data to
search
Press this
button to open
the search box
Add a Bill Record
Will use Alpha Testing, this is where I the Programmer.
Put Presence Check on the following fields: Customer Name, Product, Price, Discounts
Type “Dumb Data” as to perform Black Box Testing, in the following fields to check
for normal, abnormal, and extreme data.
Put Character Checks on all the fields.
Type “Dumb Data” as to yet again perform black box testing, in the following fields to
check for normal, abnormal, and extreme data.
Perform white box testing on the form. This is where I will check the coding syntax
and logistics of the coding for any possible errors.
If there are any errors during the white box testing, then I will repeat the previously
stated steps, until the form has no errors.
Search Customer Record
test the project myself.
appropriate detail of its respective search button, which already exists in the text
file. If it works then my testing is complete.
and over again until the coding is completed.
Next / Previous Buttons
proves unsuccessful, I will do the coding again until it is right.
saved to see if the data it shows, actually matches to the next or previous
record.
First / Last Buttons
done again until it comes right.
see if the data it shows, actually matches to the first or last record.
Field
Name
Reason of
Validation
Normal,
Abnormal,
Extreme
Proof/
coding
Problems or Comments Expected
Result
Actual
Result
Name Character
Check
Normal
Umar
Samuel
Ali
17/29 Placing a character check was
quite a difficult task for me, I
had made reference to books
on Visual Basic to guide me.
Message
Box
rejecting
invalid data
Message
Box
rejecting
invalid data
Abnormal
Extreme
Alkjdlkajdl
JlakdsjfKlS
ajsldk@(!
Product Character
Check
Normal
Shampoo
Chocolate
Biscuits
18/29 Placing a character check was
quite a difficult task for me; I
had made reference to books
on Visual Basic to guide me.
Message
Box
rejecting
invalid data
Message
Box
rejecting
invalid data
Abnormal
Extreme
Adfadfadf
KAKAjkja
Field
Name
Reason of
Validation
Normal,
Abnormal,
Extreme
Proof/
coding
Problems or Comments Expected
Result
Actual
Result
Discoun
ts
Character
Check
Normal
19/29 Placing a character check was
quite a difficult task for me; I
had made reference to books
on Visual Basic to guide me.
Message
Box
rejecting
invalid data
Message
Box
rejecting
invalid data
Abnormal
dssaa
Extreme
Name Presence
Check
Normal
Ahmed
Omar
John
20/27 The Presence check did not
have much problem with at all
since I’ve placed presence
checks before, using Visual
Basic.
Message
Box
rejecting
invalid data
Message
Box
rejecting
invalid data
Abnormal
(Blank)
Extreme
(Any word up to 20
characters long)
Field
Name
Reason of
Validation
Normal,
Abnormal,
Extreme
Proof/
coding
Problems or Comments Expected
Result
Actual
Result
Product Presence
Check
Normal
Shampoo
Surf
Toffees
20/27 The Presence check did not
have much problem with at all
since I’ve placed presence
checks before, using Visual
Basic.
Messagebox
rejecting
invalid data
Messagebox
rejecting
invalid data
Abnormal
(Blank)
Extreme
(Any word of 15
characters)
Price Presence
Check
Normal
20/27 Message
box
rejecting
invalid data
Messagebox
rejecting
invalid data
Abnormal
(Blank)
The presence check was rather
simple to place.
Extreme
(Any 5 numbers)
Quantity Presence
Check
Normal
20/27 The Presence check did not
have much problem with at all
since I’ve placed presence
checks before, using Visual
Basic.
Message
Box
rejecting
invalid data
Message
Box
rejecting
invalid data
Abnormal
(Blank)
Extreme
(Any 4 numbers)
Field
Name
Reason of
Validation
Normal,
Abnormal,
Extreme
Proof/
coding
Problems or Comments Expected
Result
Actual
Result
Price Length
Check
Normal
2212
92
151
21/29 The length check was also
easy to place since I am
familiar with placing this type
of validation check.
Message
Box
rejecting
invalid data
Message
Box
rejecting
invalid data
Abnormal
65755
Extreme
96793792798
99999999999
0
Quantity Length
Check
Normal
22
9
1515
21/29 The length check was also
easy to place since I am
familiar with placing this type
of validation check.
Message
Box
rejecting
invalid data
Message
Box
rejecting
invalid data
Abnormal
33344
Extreme
98798798798
99999999999
1
Discoun
ts
Length
Check
Normal
The length check was also
easy to place since I am
familiar with placing this type
of validation check.
Message
Box
rejecting
invalid data
Message
Box
rejecting
invalid data
Abnormal
Extreme
3454343557645656454
56456
BILL FORM
Character Check Name