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
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.2 Requirement specification
4.3 About Microsoft Windows XP
4.4 Visual Basic 6.0 (front end)
4.5 Facilities incorporated in the front end
4.6 Special features
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.5 Normal forms (NF)
5.6 Rules of normalization
5.7 Database design
5.8 Tables
5.9 Data flow diagrams
6. System testing
6.1 Testing objectives
6.2 Types of testing used
6.3 Unit testing
6.4 Testing techniques
7. System implementation and maintenance
7.1 Implementation concept
7.2 System maintenance
7.3 Future scope
8. Conclusions
Research Objectives and Topics
The primary goal of this work is to modernize the operational management of the "THEKKAYIL JEWELLERY" store by replacing manual, paper-based processes with an efficient, computerized management system. The research focuses on streamlining core business activities to save time and reduce errors in handling high volumes of data.
- Development of a centralized digital database for jewelry management.
- Implementation of interactive data entry and automated reporting systems.
- Enhancement of data security and reduction of manual calculation risks.
- Systematic analysis of organizational requirements and technical feasibility.
- Rigorous testing and implementation strategies for system reliability.
Excerpt from the Book
3.2 Limitations of existing system
The existing system has limitations. They are:
In order to perform various operations, the staffs have to refer to various written documents and thus create several paper works.
The existing system is time consuming.
Large storage area is required.
Less reliable due to human errors.
Low processing speed.
There is a chance of redundancy.
Inaccuracy in calculations.
Current system does not provide any security.
Searching or modification of a record is very difficult.
Difficult in producing reports.
Summary of Chapters
1. Introduction: Provides an overview of the project and outlines the organizational background of THEKKAYIL JEWELLERY.
2. System study: Details the methodologies used to analyze the current manual operations, including observation and interviews.
3. Materials and Methods: Contrasts the existing manual system with the proposed computerized solution and highlights the specific advantages of the new software.
4. System analysis: Discusses the feasibility of the project and technical specifications, covering hardware and software requirements.
5. System design: Explains the architectural design of the system, including input/output design, database normalization, and the use of data flow diagrams.
6. System testing: Outlines the testing strategies, including unit and validation testing, to ensure software reliability and error-free operation.
7. System implementation and maintenance: Covers the conversion process from the old system to the new software and defines maintenance protocols.
8. Conclusions: Summarizes the success of the implemented software in achieving efficient shop management and meeting user needs.
Keywords
Data flow diagram, Databases, Jewellery, Visual basic, System analysis, Software engineering, Relational database, Normalization, System testing, Implementation, User interface, SQL Server.
Frequently Asked Questions
What is the core focus of this research?
The research focuses on the digital transformation of manual administrative tasks in a jewelry business environment to improve efficiency, security, and accuracy.
What are the primary themes of the project?
The key themes include systems analysis, database design, software development using Visual Basic, and the practical implementation of automated management tools.
What is the main objective of the proposed system?
The objective is to replace manual record-keeping with a computerized system that manages sales, purchases, customer data, and employee information to save time and reduce costs.
Which scientific methodology does the work employ?
The work follows a structured software development lifecycle, utilizing system study techniques like observation and questionnaires, followed by rigorous design, analysis, and unit testing phases.
What does the main body of the work cover?
It covers the transition from an existing manual system to an automated one, providing detailed insights into database design, normalization, system analysis, and the deployment of the software.
How would you describe the key terms of this study?
The work is defined by terms related to software engineering, database management systems (RDBMS), system testing, and business process automation.
Why is normalization important for this specific database?
Normalization is crucial to eliminate redundant data and maintain data integrity, ensuring that the database efficiently organizes information about items, debtors, and stock.
What future scope does the author identify for this software?
The author suggests potential for future enhancements such as integrating salary calculations, booking details management, and upgrading the database platform for increased security and capacity.
- Citar trabajo
- Dr. Prem Jose Vazhacharickal (Autor), Sunil K. Joseph (Autor), Reshma K. R. (Autor), Geethu Thomas (Autor), 2017, Jewellery management systems. Development of a system to computerize the major transactions in jewellery like, purchases, sales and bill preparation, Múnich, GRIN Verlag, https://www.grin.com/document/370371
