SECTION B: DESIGN
CONSIDERATION OF ALTERNATIVE METHODS.
ALTERNATIVE 1
Using Off-The-Shelf Software.
Define what Off-The –Shelf software is.
Briefly describe how it can be made use of as an alternative solution for example you can say Tables
will then be created to store records of the system………………etc.
Advantages
Give 5 advantages of using Off- The-Shelf software
Disadvantages
Give 5 disadvantages of using off the shelf software.
ALTERNATIVE 2
Consider Buying or Renting/ Hiring a system/software being used by a similar organisation.
Give a brief description of how that would be done five to eight lines.
Advantages
Give 5 advantages of buying or renting a system being used by a similar organisation.
Disadvantages
Give 5 disadvantages of buying or renting a system being used by a similar organisation.
ALTERATIVE 3
Using Tailor made /Bespoke Software – made with any other programming language which is not
VB.Net.
Briefly explain that you are going to be using which particular programming language and that the
software or system will be as per the user’s requirements.
Advantages:
Give 5 advantages of using that particular programming language to develop the system.
Disadvantages:
Give 5 disadvantages of using that particular programming language to develop the system
JUSTIFICATION OF METHOD OF SOLUTION.
On this part you are simply specifying that you are going to be using VB.Net and Microsoft Access as the
final solution for your system. This should be explained or described in at least 7 lines.
eg I opted for a Tailor made software as the one I will implement ………system. I will built the software
using Visual basic.net to create the interface or the frontend and Microsoft Access to create the backend,
where the database is going to be created. This is due to the several benefits it has over the alternative
solutions given above:
Advantages of the Justified Solution.
Give 10 advantages why you have opted to use this as the final solution.
Nb. Justified Solution is the one that is going to be used to solve the problem at hand that creation of
your system (project).
You give the advantages of a Tailor made/Bespoke software applied to your system.
1
INPUT DESIGN
Below are sample data capture form and its corresponding screen layout you need four of data
capture forms and their corresponding screen layouts that are relevant to your system(project)
Data capture forms
CUSTOMERS DETAILS FILE
Customer ID
Customer Name
Customer Last
Name
Customer Cell
Number
Screen Layout
2
Data structures or file design
At least 3 Tables with field name/variable name data type, field size.
Table in design view (1mark per each field)
format or validation included on the table [1]
Validation rule
CAR PURCHASES FILE
FIELD NAME DATA FIELD SIZE FORMAT VALIDATION
TYPE
Supplier ID Short Text 5 mc999 Any valid ID number
Supplier Name Short Text 15 Alphabetic letters only Alphabetic letters only
Receipt Number Short Text 8 MT999999 Digits only
Order ID Short Text 4 9999 Digits only
Car Registration No Numeric 8 Alphanumeric text Alphanumeric text
Date of Delivery Date/Time 8 dd/mm/yyyy Date from 2018 to date()
Total Cost Currency 8 999999.99 >1000.00
CAR SALES FILE
FIELD NAME DATA FIELD SIZE FORMAT VALIDATION
TYPE
Receipt Number Short Text 8 99999999 Digits only
Customer ID Short Text 5 99999 Digits only
Car Brand Name Short Text 10 Alphabetic letters only Alphabetic letters only
Car Model Short Text 20 Alphabetic letters only Alphabetic letters only
Car Registration No Short Text 8 Alphanumeric text Alphanumeric text
Car Price Currency 8 999999.99 >1000.00
Relationships/file linkages
3
Overall plan
Tree structure/Description of the plan of action/Linked tables/Data flow diagram.
Evidence of exiting
Evidence of exiting to previous menus
SUPERMARKET
Main menu
Inventory Inventory Inventory Inventory Exit Car TS
requisition deliveries stocking sales rental system
Requisition Wholesale Inventory Wholesaler Exit to main
form form requisition requisition menu
report
report
Inventory
Delivery form Delivery Suppliers’ Delivery Exit to
report delivery report summary menu
report
Inventory
stock
Inventory form Inventory Inventory Current Exit to menu
stock report stock sales inventory level
report rport
Inventory
sales
4
Sales input Sales Weekly sales Exit to main
form report report menu
Output design
You will need 3 reports from the system and that you will do it here together. Will be instructing you on
what to do.
Black-box Testing
Define Black-box testing
Then mention that Black box testing will include use of Standard/Normal , Extreme and Abnormal Data.
Advantages
Give 3 advantages of Black-box testing
Define Standard/Normal, Extreme and Abnormal Data.
Testing for Standard Data:
Give three Standard data that can be input and should be accepted eg
Form/File Test field Test data Validation Expected Results
User addition Date of Birth 12/02/2018 Must contain numbers only Accepted
Testing For Extreme Data:
Give three Extreme data that can be input and should be accepted eg
Form/File Test field Test data Validation Expected Results
User addition Date of Birth 1/02/2018 Must be in the range. Accepted
Testing For Abnormal Data:
Give three Abnormal data that can be input and should not be accepted eg
Form/File Test field Test data Validation Expected Results
User addition Date of Birth 1/02/2018 Must be in the range. Accepted
5
THIS SECTION IS DUE ON 28/01/22
