WebBased Inventory Database Application By Gar Seigla Overview

Web-Based Inventory Database Application By: Gar Seigla

Overview • • • Project Description and Intended Use Technical Overview Deliverables Design Protocols Conclusions and Recommendations Summary of Key Ideas

Project Profile and Intended Use • Designed to replace a legacy, DOS-based application • Assists the IT department in tracking vital component information • Offers the ability to search and view records • Offers the ability to Add, Change and Delete records

Continued………… • Simplifies the process of inputting and extracting information • Globalizes access to vital information

Back-End Flowchart HTML, Java. Script, ASP and Active. X ADO WEB CLIENT ODBC Data Source Name using SQL Server Client/Server Protocol WEB SERVER RDBMS SERVER

Front-End Flowchart Add Forms Login Help Call About Add Machine Other Hardware Employee Edit Reports Drives Service Machine Request Search Machine Employee Contents Employee Other Hardware Employee IP Address Drives Service Request Machine Location Total Service Cost

Technical Elements • Hardware – Dell Power. Edge 2500 Server – APC Back-UPS C 350 $4, 039. 00 89. 99 • Software – – SQL Server 2000 Backup Agent for SQL Server Norton Antivirus Software Diskeeper 6. 0 Server Total Cost 499. 00 535. 00 49. 99 259. 95 $5, 472. 93

Deliverables • A SQL Server 2000 back-end database • A dynamic front-end interface developed in HTML, ASP and Java. Script • Authentication for administrative users • A general navigation bar for easy navigation • Customized forms and reports • The ability to Add, View and Update devices and their associative information • The ability to Search for devices on multiple criteria • Learn basic application mannerisms through the Help section

Design Protocols

Conclusions & Recommendations • The application meets project deliverables • Recommend reviewing and restructuring access security • Recommend converting entire application to. NET • Recommend developing a maintenance plan for the back-end SQL Server

Summary of Key Points • • • Project Description and Intended Use Technical Overview Deliverables Design Protocols Conclusions and Recommendations

Web-Based Inventory Database Application By: Gar Seigla