Jewellery management systems. Development of a system to computerize the major transactions in jewellery like, purchases, sales and bill preparation

An overview

Scientific Study , 2017 , 41 Pages , Grade: 1.5

Computer Science - Applied

In this modern world, computer becomes more and more popular and important to our society. We can use computer everywhere and they are very useful and helpful to our daily life. Computerized systems can be used for scheduling the jobs, update the stock details, for complex calculations, and also used for preparing bills to customers. Here we developed a system to computerize the major transactions in jewellery like, purchases, sales and bill preparation. This software can be used for managing customers as well as employees associated with that shop in a short period of time. The minimum guarantee is that this system takes less time compared to all manual works, so we can save time and money also.

Table of Contents

• Table of contents
• Table of tables
• List of abbreviations
• Jewellery management systems: an overview
• Abstract
• 1. Introduction
  • 1.1 About the organization
• 2. System study
  • 2.1 Observation
  • 2.2 Interviews
  • 2.3 Questionnaires
  • 2.4 Discussion
• 3. Materials and Methods
  • 3.1 Existing system
  • 3.2 Limitations of existing system
  • 3.3 Proposed system
  • 3.4 Advantages of the proposed system
• 4. System analysis
  • 4.1 Feasibility of the study
    • 4.1.1 Technical feasibility
    • 4.1.2 Economic feasibility
    • 4.1.3 Behavioural feasibility
    • 4.1.4 Operational feasibility
  • 4.2 Requirement specification
    • 4.2.1 Hardware specifications
    • 4.2.2 Software specifications
  • 4.3 About Microsoft Windows XP
  • 4.4 Visual Basic 6.0 (front end)
  • 4.5 Facilities incorporated in the front end
    • 4.5.1 Standard EXE:
    • 4.5.2 ActiveX DLL:
    • 4.5.3 ActiveX EXE:
    • 4.5.4 ActiveX Control:
    • 4.5.5 ActiveX Document DLL:
    • 4.5.6 ActiveX Document EXE:
    • 4.5.7 Addlns:
    • 4.5.8 Microsoft SQL Server 2005 (back end)
    • 4.5.9 Microsoft SQL features
    • 4.5.10 SQL constraints
  • 4.6 Special features
    • 4.6.1 OLE Automation:
    • 4.6.2 Reusable Object and Collections:
    • 4.6.3 Enhanced Development Environment:
    • 4.6.4 Property Procedure:
    • 4.6.5 Object Browser:
    • 4.6.6 32 Bit Support & Conditional Compilation
    • 4.6.7 New Data Bounds Controls
    • 4.6.8 ActiveX Data Objects (ADO)
  • 4.7 Microsoft Access 2007
  • 4.8 Data access
  • 4.9 Jet database format
• 5. System design
  • 5.1 Input design
  • 5.2 Output design
  • 5.3 Database design
  • 5.4 Normalization
    • 5.4.1 Benefits
  • 5.5 Normal forms (NF)
  • 5.6 Rules of normalization
  • 5.7 Database design
  • 5.8 Tables
  • 5.9 Data flow diagrams
    • 5.9.1 Purpose
    • 5.9.2 Process
    • 5.9.3 Data stores
    • 5.9.4 Data flows
    • 5.9.5 Eternal entity
• 6. System testing
  • 6.1 Testing objectives
  • 6.2 Types of testing used
  • 6.3 Unit testing
  • 6.4 Testing techniques
    • 6.4.1 Integration testing
    • 6.4.2 Validation testing
• 7. System implementation and maintenance
  • 7.1 Implementation concept
  • 7.2 System maintenance
  • 7.3 Future scope
• 8. Conclusions
• Acknowledgements
• References

Objectives and Key Themes

This research project aimed to computerize the major transactions in a jewellery shop, including purchases, sales, and bill preparation. It sought to improve efficiency, accuracy, and security compared to the existing manual system. The project was developed specifically for Thekkayil Jewellery, Pravithanam, Kerala, India.

• Improving the efficiency of jewellery shop operations
• Reducing manual work and increasing speed of transactions
• Ensuring accurate data recording and calculations
• Implementing robust security measures to protect sensitive data
• Developing a user-friendly system for seamless interaction

Chapter Summaries

The paper provides a comprehensive overview of the development and implementation of a Jewellery Management System. It begins with an introduction to the organization and its current manual system, highlighting its limitations.

The system study section details the methods employed to analyze the existing system, including observation, interviews, questionnaires, and discussions. The Materials and Methods section describes the proposed system, its advantages, and the technologies utilized.

System analysis is conducted to ensure the feasibility of the project, considering technical, economic, behavioural, and operational aspects. The paper then delves into the system design, including input design, output design, database design, and data flow diagrams.

System testing is explained, covering unit testing, integration testing, and validation testing. Finally, the implementation and maintenance of the system are discussed, outlining the future scope for enhancements. The paper concludes with a summary of the project's achievements and its potential benefits for the organization.

Keywords

The main keywords and focus topics of the text include jewellery management, system design, database development, Visual Basic, SQL Server, data flow diagrams, feasibility analysis, and system testing. This project showcases the application of software engineering principles to address the specific needs of a jewellery shop, demonstrating the potential of technology to enhance business operations and efficiency.

• College: Mar Augusthinose College
• Grade: 1.5
• Authors: Dr. Prem Jose Vazhacharickal (Author), Sunil K. Joseph (Author), Reshma K. R. (Author), Geethu Thomas (Author)
• Publication Year: 2017
• Pages: 41
• Catalog Number: V370371
• ISBN (eBook): 9783668478268
• ISBN (Book): 9783668478275
• Language: English
• Tags: jewellery, development