Technology
MiniZone is a catalog sales business, in transition to an online business, which retails books, compact disks and DVDs. Although MiniZone's current database system is manually intensive, it was satisfactory in fulfilling previous catalog orders. However, statistical projections suggest that, within four years, MiniZone's online business will require a 200% increase of the current order fulfillment. In support of this anticipated growth, MiniZone requires an automated inventory tracking system. This document outlines the proposed business requirements and data structure for MiniZone's tracking system. Additionally, it includes the database problem definition and proposed solutions for accurate management of inventory levels.The current MiniZone inventory management system is antiquated and largely manual. It requires a significant amount of physical paperwork to connect the other record keeping systems in the company. For example, whenever a customer places an order, the order department enters the order, then prints out a "pick list" for the warehouse(s). Once the order has been shipped, the warehouse personnel deplete the inven
MiniZone's inventory consists of three types of media: book, audio compact disc, and movie DVD. The inventory is divided and housed in several warehouses, scattered throughout the country. The database model must include the ability to track, update, and search the inventories at all locations. tory count of the items shipped, and then send a copy of the pick list with shipping notes back to the customer relations department. Each order requires at least three separate manual forms, routed between three different departments. Since all of these systems are fully functional, the inventory tracking system will not attempt to duplicate the information that these systems provide. The database schema focuses on inventory information. The other systems will link to the new inventory system by using inventory IDs as foreign keys wherever it is necessary to link inventory and customer information together. Because we will use the current system's inventory IDs, this linking should not be particularly onerous. When MiniZone was supported exclusively through catalog sales, we were able to sustain this process without considerably delaying our shipments. However, now t
Some common words found in the essay are:
Business Opportunity, Requirements MiniZone's, Conclusion MiniZone, DVDs MiniZone's, Abstract MiniZone, inventory management, tracking system, inventory tracking system, inventory management system, management system, inventory tracking, business opportunity, database system, title ·, pick list, · information, automated inventory tracking, stock hand, title · perform,
Approximate Word count = 796
Approximate Pages = 3 (250 words per page double spaced)
|
