Transcript Project Goal

Designing an Inventory
Database System
CS489 Research Project in Computer Science
John Ahigian
Advisor: Dr. Wang
Project Goal
 The project goal: to design a real time inventory
database online.
 Online Store in HTML / PHP (Hypertext
Preprocessor) / and MYSQL
 My website can help business owner(s) in two or
more different locations keep a product inventory in
sync.
Online Inventory
Managerial Administrative Options
Functions:
 Adding Products
 Removing Products
 Edit Product
 Search
 Displaying Current Inventory
Project Overview
Basic Overview of Project
Public_Html
CS489_Independent_Research_Files
3 main HTML Files
zeus.vwc.edu/~jhahigian
40+ Files
HTML / PHP Files
Directories: /store /images
HTML
PHP File
Store
13 Main / Files
over 10+ files in 4 Directories
Store Directory
Images
14 (.png's / .jpg's / .gif's)
/Images
My Database
 Product / Description
 Cost
 Quantity
SSH
SSH (secure file transfer) is what you need to
use in order to maintain your directories and
files on zeus.
FTP updated files and over write them in the
public_html directory.
Coded in HTML and PHP to communicate with
the database written in MySQL.
Why an Online Store?
Manager and Staff
Best way to show Inventory real time in order
for business to run properly
Customers can see Manager / Staff changes
instantly after being edited
Searching for Products
Manager / Staff can search by vendor name
separated with a hyphen.
Customers can search by brand name or
product
(Inventory entered in already) Apple,
Hardware, Software, Phones, Cameras (etc.)
Conclusion
 Online Store is best way to prove an Inventory
Database works because you need one.
 My Inventory Database that is managed by staff can
be accessed privately by them
 Publishes real time for customers to see updates.
 Added mailing list database for subscribers
 Check it out!
My Workspace