A Web-Based Database-Driven Inventory System

Topics: SQL, Relational model, ColdFusion Pages: 33 (10746 words) Published: September 19, 2012
FLLMMCIS: A Web-based Database-driven Inventory System

Russell Pierce Major Professor: Dr. Homer Carlisle Auburn University Samuel E. Ginn College of Engineering Department of Computer Science and Software Engineering Master’s of Software Engineering (MSWE) Non-thesis Project

Abstract This project has produced a working inventory system for the Auburn University Department of Foreign Languages and Literatures Multimedia Center. The produced system is called the Foreign Languages and Literatures Multimedia Center Inventory System, abbreviated as “FLLMMCIS” or simply “IS” within the context of this document for brevity. The IS facilitates the Multimedia Center’s inventory lending activities. The system is a database-driven web site that has been written in ColdFusion backed by a MySQL database. This paper introduces readers to the system and details its development. In this paper an overview of the IS from a functional perspective is offered followed by the details of the project and a brief conclusion.

Table of Contents List of Figures ................................................................................................................................. 4 1. System Introduction and Walk-through.................................................................................. 5 1.1 Library Section..................................................................................................................... 5 1.1.1 Checking Out Items ...................................................................................................... 7 1.1.2 Viewing Item Details .................................................................................................... 9 1.1.3 Checking In Items ....................................................................................................... 10 1.1.4 Sending Overdue Notices ........................................................................................... 11 1.1.5 Adding, Editing, and Deleting Items .......................................................................... 12 1.2 Administration Section ...................................................................................................... 14 1.2.1 General Database Access............................................................................................ 14 1.2.2 Managing Users ........................................................................................................... 15 1.2.3 Reports ........................................................................................................................ 15 2. Project Details....................................................................................................................... 16 2.1 Customer Description ........................................................................................................ 16 2.2 Project Deliverables ............................................................................................................ 17 2.3 Requirements Collection and Refinement ......................................................................... 18 2.4 Modeling and Design......................................................................................................... 19 2.5 Testing, Deployment, and Maintenance ............................................................................ 19 3. Implementation ..................................................................................................................... 20 3.1 Technology Overview........................................................................................................ 21 3.2 Architecture........................................................................................................................ 21 3.3 User Interface..................................................................................................................... 22 3.4...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • A Web Based Management System Essay
  • Web Based Information System Essay
  • Web Based System Essay
  • Database Models and Legacy Systems Essay
  • Essay about Chapter I for Inventory System
  • Importance of Web Based Questionnaire System Essay
  • Web Based Parts Ordering System Essay
  • Computer Based Sales and Inventory System Essay

Become a StudyMode Member

Sign Up - It's Free