Designing an inventory database system
Download
1 / 16

Designing an Inventory Database System - PowerPoint PPT Presentation


  • 59 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Designing an Inventory Database System' - vladimir-reyes


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Designing an inventory database system

Designing an Inventory Database System

CS489 Research Project in Computer Science

John Ahigian Advisor: Dr. Wang


Project goal
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
Online Inventory

  • Managerial Administrative Options

  • Functions:

  • Adding Products

  • Removing Products

  • Edit Product

  • Search

  • Displaying Current Inventory


Project overview
Project Overview

/Images

HTML

Store Directory

PHP File


My database
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
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
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
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!



ad