Tuesday, 9 August 2016

DATABASE PROJECT #12

Wholesale Management System Database Project

1.     Maintain the details of stock like their id, name, quantity
2.     Maintain the details of buyers from which manager has to buy stock like buyer id, name, address, stock id to be bought
3.     details of customers i.e. name, address, id
4.     defaulters list of customers who has not paid their pending amount
5.     list of payment paid or pending
6.     stock that is to be buy if quantity goes less than a particular amount.
7.     Profit calculation for a month.
Quantity cannot be sold to a customer if required amount is not present in stock and date of delivery should be maintained up to which stock can be provided.

No comments:

Post a Comment