A Web-Based Database-Driven Inventory System

Only available on StudyMode
  • Download(s) : 646
  • Published : September 19, 2012
Open Document
Text Preview
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...
tracking img