Abstract: Jewellery Shop Management is software which is concerned with the computerization of the records maintained in jewellery. In this project the details about the customer, agents and the staff are stored in separate tables. Customers’ details are stored in a single table by day to day process at the time of purchase. The agent details are stored indifferent tables based on the item purchased i.e., gold, silver, diamond etc. Then staff’s details can be classified into different categories according to their respective designations on the basis of which their salary is calculated. The standard rate of purchasing items such as gold, silver and diamond are stored in a separate table. Reports generation and billing can be done easily. As the market rates are volatile these rates can be changed as and when required. It is planned to design in such a way that a normal computer user even with account knowledge can use this software to maintain the resource flow. Addition, deletion and modification of the record are easy. These processes are done by entering the details and clicking on the respective place. Thus the project satisfies the entire needs of the jewelers in the process of maintaining these records and saves a lot of time.

Keywords: Data flow diagram, Databases, Jewellery, Visual basic

| DOI: 10.17148/IARJSET.2021.8408