Transcript قسم الدراسات الإسلامية والعربية

King Fahd University of Petroleum & Minerals
College of Industrial Management
Accounting & MIS Department
System Analysis & Design II – MIS 401
Section # 2
Term Project
Group # 2
Saud Al-Abboush
Jassem Al-Ansari
Rakan Rashwan
Omar Al-Khalaf
910813 (GL)
959023
967461
981079
Introduction
 Organization:
Department of KFUPM Stores. It is responsible for storing
and distributing stationary and other office equipment
supporting tools like: paper, pens, tapes, etc.. to the other
departments.
Contact Person:
Mr. Mansour Al-Utaishan, Deputy Director - KFUPM Stores.
 Current System:
In order to receive stationary each department
must fill out a form stating the following:
1. Item description
2. Unit
3. Quantity
4. Item stock number
5. Purpose of the request
Also, these details must be provided:
1. Name of the department
2. Cost center
3. Location
4. Telephone number
5. Name of the person
6. Name of the department chairman or director
7. Date of the request
8. Items must be given a serial (001, 002, 003 …..)
This form must be typed with a typing machine,
handwriting is not accepted. All items mush be
ordered in the form by the its ascending stock
number. Then the form is mail using the regular
KFUPM post office. These forms are received and
checked by the concerned person. After that the
approved form is sent to the delivery person who
collect the requested and approved items form the
main store and deliver it to the concerned
department. No computerized system is used.
 Problems with the current system.
This way takes lots of time and efforts by the
department when requesting stationary. And
also, it takes lot of time and effort by the stores
to check and update their inventory, and all that
is done manually, which increase the chance of
human errors.
 Project description
We built a database with each and every item used
by the departments, and a database with the
different departments in KFUPM. Then constructed a
web page so user (department) can access it from
his office with a unique user name and password.
And then he can view all items offered by the stores
(obtained automatically from the database). Then he
can select items (use check box) and state the
quantity and click a preview button to review the
selected items, after that he clicks a submit button.
Then the administrator checks the requested
items and he can delete or change any items
and approve it. After he approve any item the
system automatically detects the approved
quantity from the main inventory. After that an
electronic form is generated with the approved
items including the department details, which
will be used to deliver the items. And as a
document.
The Tools Used to Develop the System
 MS Access & SQL to develop the databases.
 FrontPage & HTML to develop the WebPages.
 ASP to read from and write to the database.
 System Environment: Online (Intranet).
Why choosing this project
 This project is a real time system (applicable).
 Easy to understand, not very complex.
 Challenging.
 Simplicity and elegancy.
 Acquires coding techniques (ASP, HTML, SQL).
 Direct benefit to the university.
End of our show.
Thanks for listening.