A Web-Based Database-Driven Inventory System - 10756 Words

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†¦show more content†¦25 4.1 User Interface...................................................................................................................... 25 4.2 Database............................................................................................................................. 28 4.2.1 Database Design.......................................................................................................... 28 4.2.2 Database Migration................................... .................................................................. 31 4.2.3 Database Tables .......................................................................................................... 31 4.2.3.1 Authorization and Access Control Tables ............................................................... 32 4.2.3.2 Inventory Tables .................................................................................................. 32 4.2.3.1 Inventory Tracking Tables................................................................................... 33 4.3 Object Library.................................................................................................................... 33 4.3.1 FormTable................................................................................................................... 33 4.3.2Show MoreRelatedWeek 5 Assessment Essay1645 Words   |  7 Pagesï » ¿Please: 1. Read the Case Study. All of the questions and MS ®Project ® schedule will be based on the facts of the included Case Study. 2. Read each question. Note the Question # and a brief heading above your written response to each question. Use subheadings to help organize your thoughts and comments. Use enough narrative for the sake of clarity. Use bullet points for elements that lend themselves well to lists. 3. When done, submit your document, and the Project ® mpp file to the AssessmentRead MoreCis207 Week 3 Riordan Proposal Essays1284 Words   |  6 PagesRiordan System Proposal 2013 Team B CIS/207 April 8, 2013 David Sysowksi Proposal After careful assessment of the infrastructure and inventory systems used at Riordan Manufacturing, our team has identified these systems are outdated and unable to effectively manage the day to day processing. As a global leader in the manufacturing of plastic products, the performance and reliability of the infrastructure is crucial to the continued success and growth of your company’s operationsRead MoreDatabase Enviroment1227 Words   |  5 PagesTHE DATABASE ENVIRONMENT: A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. PROBLEMSRead MoreERP Paper1545 Words   |  7 PagesIntroduction The research will be based on ERP systems Web Distributed Business Solutions. This report will discuss the concept, architecture, process and application of the system solution. There will also be examples given on how industrial businesses implement this technology into their daily operations and how it has benefitted them. Concept ERP stands for Enterprise Resource Planning. ERP is one complete system to rationalise processes and data across the whole organisation, so businessRead MoreInformation Technology And The Business Model1517 Words   |  7 PagesEbay Inc. 1. Introduction EBay Inc is a worldwide online retailer and auction industry that operates a web-based marketplace for all individuals to buy or sell anything online. EBay operates a consumer to consumer (C2C) platform in its business model where it allows individuals to communicate with each other interactively. EBay uses information technology to perform and operate its business model. EBay was very successful in using information technology in its business model as an online retailerRead MoreSoftware System Architecture Essay1730 Words   |  7 PagesSoftware System Architecture Essay 03/04/2008 Once a business need is established, software system architecture is formulated to meet this business need. To properly formulate the software system architecture we must employ proven strategies, such as diagrams that illustrate the parts of the system and how they work together. These subsystems collaborate intelligently to support the functionality of the whole system. Project managers must be aware of the system architecture involvedRead MoreAn Inventory Management Model Within Mobile Commerce3204 Words   |  13 PagesAn Inventory Management Model in Mobile Commerce Introduction An inventory management system is the management of goods in the industry. The goods consist of raw material to finished products. Thus an inventory management system controls the entire storage of material flow in the industry. In this journal, the author focuses on the Inventory management model in mobile commerce. In earlier days ledger books were used to maintain the inventory control. Later computers were deployed in this work,Read MoreAnalysis Of Vivek762 Words   |  4 Pagesinfrastructure is his top priority. He explained that upon his hire in 2016, there were many components of the infrastructure that needed a fixative. Since then, he has been aggressively reorganizing and refreshing hardware, software, applications, and systems development initiatives to remedy any pending issues. In the past, Zones has updated software monthly, servers (every 5-7 years) and other hardware (every 6 years). Their environment is heterogeneous, running Linux and Windows servers on premisesR ead MoreChapter 2 Organizing and managing information 7945 Words   |  32 Pages2--Enterprise Systems Student: ___________________________________________________________________________ 1.  One of the primary goals of implementing an ERP system is to standardize systems across multiple locations and multiple divisions.  Ã¢â‚¬ ¨True  Ã‚  Ã‚  Ã‚  False    2.  Large multilocation and multidivision companies are challenged to see the greatest benefits from ERP systems.  Ã¢â‚¬ ¨True  Ã‚  Ã‚  Ã‚  False    3.  Early adopters of ERP systems were in the business of making products.  Ã¢â‚¬ ¨True  Ã‚  Ã‚  Ã‚  False    4.  ERP systems have provedRead MoreSupply Chain Business Intelligence Technologies, Issues and Trends9649 Words   |  39 PagesStefanovic1 and Dusan Stefanovic2 Zastava Automobiles, Information Systems Department, Kragujevac, Serbia nenad@automobili.zastava.net, www.zastava-automobili.com 2 Faculty of Science, University of Kragujevac, Serbia dusans@kg.ac.yu, www.pmf.kg.ac.yu 1 Abstract. Supply chains are complex systems with silos of information that are very difficult to integrate and analyze. The best way to effectively analyze these disparate systems is the use of Business Intelligence (BI). The ability to make and