CHAPTER THREE
DESIGN METHODOLOGY
3.1 DESIGN OVERVIEW
The system design procures a physical design of the bill of material processing. The physical design
describes the hardware, software and operating procedures that enables the bill of material processing
becomes feasible. This part will strictly spell out how to design the new system to ease the problem
encountered from the already existing one (system). All the input and output specifications, that is the
input and output file used in developing the new design system are detailed here, together with the system
architecture and system flowchart for the new system is also discussed here.
i. INPUT DESIGN: Input design is concerned with the procedure followed in entering data into
the beauty parlor management system. The input items are product name, product ID, product
manufacturing date, product expiry date, material name, and material quantities and so on. Since
the computer operates with “Garbage in garbage out” (GIGO) which means what it takes is what
it gives, the input design uses user-initiated interface in form of interactive question on the screen
of the computer whereas the output resides in the memory as a database for every product and
materials within the organization.
ii. OUTPUT DESIGN: Output Design is defined as a term that describes what come from the
computer system at user’s request. During an analysis and design of a system, output
requirements are first considered because its need determines what the input and processing will
be.
The outputs considered in this project work include product details, material details, product search
queries, and the bill of materials for each product when obtainable; details of how the output would be
generated would be discussed under the software.
iii. DATA DESIGN: The data design or data entry is the manner in which data queue initially
entered into the bill of material processing system. The new system uses On-Line real time
method of processing data when entered into the system through the terminal. The computer is
20
programmed to display menus of list of options as well as prompt that tells the user the type of
data to enter.
The three methods of data used in this design are:
i. INPUT CONTROL: This has to do with the inspection of detected error before or as the data is
being keyed into the system.
ii. PROCESS CONTROL: The data formats are checked to be of expected uniformity during
processing by the control programs.
iii. OUTPUT CONTROL: Control is taking to see that accurate output is produced.
3.2 INPUT – PROCESS – RELATIONSHIP
The login form is linked with to the admin table; the username and password are supplied through the
login interface and SQL query statement search for the corresponding username and password in the
admin table. When this is done and it is found, it disposes the login page and opens the main pages that
show a lot of control that link to other forms in the application. The diagram is shown below:
Query database for match
Login Main page with
Interface controls
Other forms
FIG 1: INPUT – PROCESS – RELATIONSHIP
21
3.3 INPUT, PROCESS AND OUTPUT SYSTEM
Input, Process and Output (Admin)
Input Process Output
Admin Login Admin Login Successful
Manage Products Product Added Successfully
Admin Login
Page Manage Materials Product Updated Successfully
Generate Bill Product Deleted Successfully
Material Updated Successfully
Material Deleted Successfully
Bill Generated Successfully
Fig 2: IPO (Admin)
22
3.4 SYSTEM ARCHITECTURE ON BILL OF MATERIAL PROCESSING
Process request via the internet
Web Server Internet
Login
Add Products
Add Materials
Manage Products
Manage Materials
Search Products
Review Bills
User Print / Download Bill
Logout
Send data to
the database Retrieve data from
the database
Database
FIG 3: BILL OF MATERIAL PROCESSING SYSTEM ARCHITECTURE
23
3.5 FLOWCHART ON BILL OF MATERIAL PROCESSING SYSTEM
START
ENTER USERNAME AND
PASSWORD
LOG IN
LOGIN VERIFICATION
Yes No
Manage Products /
Materials
Add Products /
Materials
View Products /
Materials
Delete Products /
Material
STOP
FIG 4: FLOWCHART ON BILL OF MATERIAL PROCESSING
24
