|
|
| Project Title
|
Inventory
Database Management System for a Supermarket
|
| Software
Requirements
|
Description
- A comprehensive software system to manage the inventory
database of supermarket.
- This database contains all relevant data such as item
code, quantity price etc.
|
Point-of-Sales
Tasks
- Decoding of item code from the bar-code reader and
extraction of data from the database.
- Computation/printing of bill for the customer and
accounting department.
- Updating of inventory after each process.
|
Back-End
Tasks
- Prediction of demand for a particular product. A
graph/visual aid to be created for the manager.
- Preparing purchase order forms (for appropriate
wholesales) for items based on demand analysis. It also
gives the manager an indication when stock levels of an item
fall below a certain number.
- Maintain tasks such as stock-disposal of perishables that
exceed expiry date and update of the inventory upon delivery
of various orders.
|
|