Information and Computer Science Department

Information and Computer Science Department

ICS324: Fundamentals Database Systems

Warehouse Management System (101)

Project Description

Team members:-

Submission Date: 30th November, 2010

Project Requirement Guidelines

1. On a daily basis, new groceries are brought in by truck drivers and are admitted into the

warehouse. The new groceries naturally have the highest level of freshness and are

therefore stored towards the back of the warehouse by warehouse laborers, giving

older groceries the priority to be taken out and delivered to the mega‐stores first.

2. On a daily basis, the warehouse receives requests for new groceries from the three

mega‐stores. Based on these requests, the required groceries are loaded onto trucks by

warehouse laborers and shipped to the mega‐stores. The amount of groceries loaded

must be determined and approved by a floor manager. Truck drivers then deliver the

groceries to the mega‐stores. To maintain the highest level of freshness, the oldest

groceries located at the front of the warehouse are loaded onto the trucks. Newer

groceries are in turn pushed to the front of the warehouse, by warehouse laborers, to

replace the loaded groceries.

3. Inventory levels are checked on daily basis and reviewed by the floor manager. The

company has preset threshold “stock levels” in the warehouse for each type of grocery

product. If a stock level goes under the threshold level, the floor manager sends a

request to bring in more stock of that type the next day.

4. Freshness levels are also checked on a daily basis. The freshness check involves

determining how long each grocery item has been sitting in the warehouse. The

company has preset “number of days” thresholds for each type of grocery product. If a

grocery item remains in the warehouse beyond the preset threshold level, then the item

is disposed by garbage men and newer groceries are moved in front to replace it by the

warehouse laborers.

5. The warehouse system should also allow the executive manager the ability to adjust the

price of each type of grocery item. Price is adjusted based on the following:

a. Freshness of grocery item.

b. Stock level of a grocery type.

c. Daily demand on a grocery type.

d. Seasonal adjustments (i.e. the availability of a given grocery item in a given

season).

6. Any activity in the warehouse affecting its stock levels must be updated in the system

immediately.