Jewellery shops sells various types of Jewellery items and it is very difficult to categorize these items on the basis of their manufacturing dates, type of gold used to manufacture it such as either using 24K or 22K. Which items comes under the category of ISI Gold Mark and which items are of local brand. It is also very difficult to analyze the overall transaction for a particular period of time and which ornaments are not available in the shop. To solve these problems this system has been developed.
This system will follow the steps and rules to meet user requirements on demand and on time. Apart from this it will remove the difficulties faced by the admin to manage their shop and can be easily handled by the admin without any technical knowledge of the platform used and about the system. Through this system employees working under a particular shop can be easily managed and overall transactions of particular date and time can easily be viewed.
Shop managers can easily handle their shop and business transactions by accessing a single window. This system will have Utilities, Transactions and Report generations menus. Utilities section will deal with backing up databases either on daily basis, timely basis, monthly basis etc as set by the admin, adding new employee, deleting new employee, managing existing employee details, adding new customer, adding and deletions of new supplier, changing the password, categorize different Jewellery items etc.
Transaction will deal with financial accounting part of this business scenario. It will provide information on sales, purchase, Cash In and Cash Out associated with this business process.
Diagrams and Table Needed for this Project are:
- Data Flow
- ER Diagram
- Schema Diagram
- Use Case Diagram
- Gantt Chart
- Test Case