|
Papers > Technology > Vending Warehouse Database Design
Featured Papers from Direct Essays |
|||
1. Design
|
|||
This is a preview of a paper to view the full text you need to signup and login.
Vending Warehouse Database Design |
|||
|
Vending Warehouse Database Design Statement of Problem The “Snacks R Us” vending company is in trouble. ... Due to the financial strain they have had to reduce staff, specifically warehouse managers and route drivers, and because of this reduction in employees one person is being required to do the duties of many. ... The purpose of this project is to develop a system involving a database to track and report on the physical inventory and cash assets of the company. ... Scope of Problem There is a problem in the maintenance of the inventory of the Snacks R Us vending machine company. We have created a database to assist in the accurate recording and calculating of the flow of product and money to curb the unrestricted pilfering of merchandise. We have included the tracking the amount of goods coming in and going out of the warehouse. ... Overall Design Now that we have defined what the scope of the problem is, we will discuss our overall design of our vending machine database project. The tables we came up with for our database are Route, Route Detail, Employees, Vehicle, Load Detail, Daily Vehicle Inventory, Daily Reconciliation, Products, Order Detail, Orders Received, Distributions. The entity-relationship diagram for the database is shown below. ... The Daily Reconciliation table will track records on monies that are taken from the warehouse and from the vending machines. ... The Products table will track what product is removed from the warehouse. ... Detailed Design Distributors DistributorID is an autonumber field that will not be shown to the end user. ... RetailPrice is the price that is charged for the product in the vending machine. CurrentQuantity is the current number of units in the warehouse. OrdersReceived The OrderNumber will usually correspond to a purchase order number as issued by the vending company. ... DateReceived is the date that the order actually arrives at the warehouse. ... HireDate is the date the employee began work at the vending company. ... NumMachines contains the total number of vending machines that are serviced on the route. ... The CashIn is the total amount of cash that was retrieved from all the vending machines that were serviced. CoinOut is the total value of coins taken from the office to be used to refill the change mechanism of the vending machines. CoinUsed is the total amount of coins used to refill vending machines. ... This will hold information about the amount, cost, description or name of the product and the date received at the warehouse. ... The third form is to track the amount of goods that come out of the warehouse per truck. ... The report will also show a grand total of retail value for the entire warehouse. Warehouse Activity This report shows the flow of products in and out of the warehouse. The user will be able to pick a time period, usually a month or a quarter, and the report will show the total product put into vending machines. ... To eliminate this problem, a database has been implemented to track and report on physical inventory and cash assets of the company. The database was created on assumption that there will be no waste, no spoilage, or returned merchandise. |
|||
To link to this page, copy the following code to your site:
Paper Information |
|||||
Title: Vending Warehouse Database Design
|
|||||
Signup & Login |
|||||
If you don't currently have a login then Signup here |
|||||
| Pre-Written Papers | |||||
|
|||||
| Custom Papers | |||||
|
|||||
Copyright 2003-2008 doingmyhomework.com. All rights reserved.