Develop a Wholesale Management System Database using Java for GUI and MySQL for database and create a report on it.
Budget: $10 – $30 USD
The system should:
• Maintain the details of stock like their id, name, quantity. Include 20 items in your DB
• Maintain the details of buyers from which the manager has to buy the stock like buyer id, name, address, stock id to be bought. Include 20 names in your DB
• Maintain the details of customers name, address, telephone number, id. Include 30 names in your DB
• Display a report with the Defaulter’s list of customers who have not paid their pending amount.
• Display a report with the List of payments paid
• Display a report with the List of payments pending.
• Display a report with the List of the stock that is to buy if quantity goes less than a particular amount (10 items).
• Display a report with the Profit calculation for a month.
• Produce a warning or error if the Quantity cannot be sold to a customer if the required amount is not present in stock and the date of delivery should be maintained up to which stock can be provided.
• Produce a warning if a customer who have not paid their pending amount is requesting more items.
• Produce a warning when the quantity of an item goes less than a particular amount.
Instructions:
• You are free to choose the name of your store and what you sell.
• Your store should be unique and is about something you like.
• Use MySQL to create your DBs.
• Use either Java or PHP to create a GUI for your system.
• Upload one Word document (zipped if size is large). It needs to be a word document .docx or .doc
• Document must consist of the following and divided to the following sections. The content of sections must be in the correct order
• Maintain the details of stock like their id, name, quantity. Include 20 items in your DB
• Maintain the details of buyers from which the manager has to buy the stock like buyer id, name, address, stock id to be bought. Include 20 names in your DB
• Maintain the details of customers name, address, telephone number, id. Include 30 names in your DB
• Display a report with the Defaulter’s list of customers who have not paid their pending amount.
• Display a report with the List of payments paid
• Display a report with the List of payments pending.
• Display a report with the List of the stock that is to buy if quantity goes less than a particular amount (10 items).
• Display a report with the Profit calculation for a month.
• Produce a warning or error if the Quantity cannot be sold to a customer if the required amount is not present in stock and the date of delivery should be maintained up to which stock can be provided.
• Produce a warning if a customer who have not paid their pending amount is requesting more items.
• Produce a warning when the quantity of an item goes less than a particular amount.
Instructions:
• You are free to choose the name of your store and what you sell.
• Your store should be unique and is about something you like.
• Use MySQL to create your DBs.
• Use either Java or PHP to create a GUI for your system.
• Upload one Word document (zipped if size is large). It needs to be a word document .docx or .doc
• Document must consist of the following and divided to the following sections. The content of sections must be in the correct order
Related categories:
PHP
Business, Accounting, Human Resources & Legal
Software Architecture
MySQL
Database Programming