| This
program is designed for a tailor shop. They
have two computers; The first one only the
boss uses it (which is located in the cabin
inside the shop). The second computer is for
the salesman. |
| |
| |
| |
| This
shop is going to be opened soon, which means
that there are no customers as yet. Therefore,
we will begin with the inventory. |
| |
|
|
It
is linked by a cable wire |
|
|
| |
|
| STOCK
(in) |
Article
Number
Description Color
Yards In Cost
Total Stock Available |
Input
of stock, is done
by Computer 1 only |
|
STOCK
(Out) |
Order
No.
Order Date
Article Number
Description Color
Available Yards
Yards Out |
Extra
Yards Remarks |
|
CLIENT
INFORMATION |
Order
No.
Order Date
First Name
Last Name
Reference
Address
Country
City
Email
Phone (Home,Fax,Office)
Mobile
Website
Satisfied / Unsatisfied |
|
|
| |
|
| Computer
1 is a Supervisory Computer, therefore
one can see call fields. |
| |
As
for Computer 2, they will
be able to view only these fields: Order No.
/ Order Date / Article Number / Description
Color / Available Yards / Yards Out / Extra
Yards / Remarks.
First Name / Last Name / Reference / Address
/ Country /
City / Email / Phone (Home, Fax, Office) /
Mobile / Website
Satisfied / Unsatisfied
Unless and only the supervisor grants rights. |
| |
| Anyone
who access Computer 1 before opening this
program, it should ask for password. (The
password should be able to change by the user). |
| |
| STOCK
(in) (input is done by Computer 1) |
|
Example
of Article Number: Shark-skin Material
= BL001 (The field should allow user
to type in the article number). |
|
Cost, should also
be encrypted by a password |
|
| |
|
| *
Article No. should not be deleted in the database
even though the stock = 0 *. (Only Computer
1 can update the stock of the Article
No. Please give a warning / alert, if one
attempts to delete an existing Article No. |
| |
|
| CLIENT
information : It means that when
a customer / client orders. |
| |
|
| STOCK (out)
: Means that the material is being cut and
sent to the tailor to stitch. |
|
|
Order
No. should be a running number as well
as it can be edited. (For example: 0001,
0002, 0003,….) |
|
Order Date should
automatically show today’s date as well
as it can be modified or changed to
yesterday. |
|
| |
|
| CLIENT
information |
| |
Reference
For Example: Last year the customer
bought some clothes. The salesman (who
is using Computer 2), should be able
to keep the all Order No. of the same
customer (as a reference of what Article
No. / Color / Description one ordered)
Reference: 112, 212, 312 |
|
| |
|
| STOCK
(out) [The measurement system is
usually in meters & yards.] (Example) |
| |
Yards
out: 2 yd. |
 |
Extra Yard: ½
yd. |
|
Remarks: The tailor
takes 2 yd. and later comes back after
5 hrs, says this particular cloth is
not sufficient. I would like another
½ yd. |
|
| |
|
| *
One Customer / One Order No. is able to select
more than one Article No. (Multiple Article
No.) * |
| |
|
SEARCH:
CLIENT Database |
First
Name
Last Name
City
Country
Email
Phone |
| Order
No. should show automatically
after the details are entered. |
|
| LABEL/REPORT:
CLIENT Database |
First
Name
Last Name
City
Country
Email
Phone |
The
program should allow the user
to select required fields to print
and the size of the paper.
(Usually a label is: 2 ½
x 1 ½ ) |
|
|
| |
|
SEARCH
: For Cloth |
Article
No.
Color
Total Stock Available
Description |
| (Customizable) |
|
| REPORT |
| (All
fields - Customizable) |
Order
No.
Order Date
First Name
Last Name
Reference
Address
Country
City
Email
Phone (Home, Fax, Office)
Mobile
Website
Satisfied / Unsatisfied
Article Number Description Color
Yards In Cost
Total Stock
Yards Out
Total Stock Available |
| Extra
Yards Remarks |
|
|
