Designing an Inventory Database System

1. Designing an Inventory Database System CS489 Research Project in Computer Science John Ahigian Advisor: Dr. Wang

2. 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.

3. Online Inventory • Managerial Administrative Options • Functions: • Adding Products • Removing Products • Edit Product • Search • Displaying Current Inventory

4. Project Overview /Images HTML Store Directory PHP File

7. My Database • Product / Description • Cost • Quantity

9. 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.

11. 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

12. 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.)

13. 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!

14. My Workspace