Download store management for using python and more Study Guides, Projects, Research Information Technology in PDF only on Docsity!
Submitted by
SARAVANA KUMAR.S
in partial fulfillment of the requirements for the award of the Degree of Bachelor of Information Technology from Bharathiar University, Coimbatore.
Under the supervision of
Assistant Professor, School of Computer Studies, Rathnavel Subramaniam College of Arts and Science(Autonomous),
Sulur, Coimbatore -
School of Computer Studies, Rathnavel Subramaniam College of Arts and Science (Autonomous), Sulur, Coimbatore – 641 402.
June2019 - May 2022.
1U19IT
PMr.A. ARUL, MCA.,M.Phil. ,
STORE MANAGEMENT SYSTEM
RegisterNumber-1U19IT
RATHNAVEL SUBRAMANIAM COLLEGE OF ARTS AND SCIENCE
(Autonomous and Affiliated to Bharathiar University) NAAC Re Accredited with ‘A’ Sulur, Coimbatore-641 402.
SCHOOL OF COMPUTER STUDIES
Bonafide Certificate
This is to certify that the project work entitled “ Store Management System” done by
Saravana Kumar.s , during the period June 2019 to May 2022 in partial fulfillment of the degree
of B.Sc., Information Technology is submitted for the Project evaluation and Viva voce held at
the School of Computer Studies, Rathnavel Subramaniam College of Arts and Science, Sulur,
Coimbatore on
Internal Supervisor HoD-B.Sc.IT
Examiners: Internal Examiner :
External Examiner:
Certificate
This is to certify that the project entitled Store Management System , submitted to the School of
Computer Studies, B.Sc. Information Technology, Rathnavel Subramaniam College of Arts and
Science in partial fulfillment of the requirements for the award of the Degree of B.Sc., Information
Technology is a record of original project work done by Saravana Kumar.s with register number
1U19IT084 during the period June 2019 to May 2022 under my internal supervision and the
project has not formed the basis for the award of any Degree/Diploma/Associate ship/Fellowship
or other similar title to any candidate of any University.
Internal Supervisor
DECLARATION
ACKNOWLEDGEMENT
Acknowledgement
If words are considered as symbols of approval and tokens of acknowledgement, then the
words play the heralding role of expressing my gratitude to all who have helped me directly or
indirectly during my project work.
I express my sincere gratitude to the esteemed Managing Trustee of RVS Rathnavel
Subramaniam College of Arts and Science, Dr. K. Senthil Ganesh for allowing me to do my
project with his Moral support.
I will be ever graceful and thankful to Dr. H. Muhammad Mubarak, Secretary ,
Rathnavel Subramaniam College of Arts and Science for allowing me to do my project with his
moral support.
I will be ever graceful and thankful to Dr. T. Sivakumar, M.Sc., M.Phil., Ph.D.,
Principal , Rathnavel Subramaniam College of Arts and Science for allowing me to do my project
with his moral support.
It gives me immense pleasure to take this opportunity to express my gratitude and thanks
to Dr.P.Navaneetham, M.Sc., M.Phil., Ph.D., Associate Professor & Director
Administration, School of Computer Studies, Rathnavel Subramaniam College of Arts and
Science for his continuous encouragement and blessings.
I proudly feel graceful to Dr.M.Suganya, M.Sc., M.Phil., Ph.D., Associate Professor &
Head of the Department, B.Sc. Information Technology, School of Computer Studies ,
Rathnavel Subramaniam College of Arts and Science for providing me this opportunity and
extending a constant monitoring throughout the course of the project.
With my gratitude I would like to acknowledge the immense encouragement given to me
by Mr.A.ARUL, MCA.,M.Phil., Assistant Professor, School of Computer Studies, Rathnavel
Subramaniam College of Arts and Science who is my internal guide, for his/her valid
suggestions, and counsel, and ever willing to extend help. I am deeply obliged to his for the
encouragement and without him the project work would not have been successful.
Saravana Kumar.S
⮚ User friendly and interactive
INDEX
- Introduction i. Purpose ii. Scope iii. Project Overview
- Goals And Objective 4
- (^) Project Analysis
- Existing System
- Proposed System
- Hardware and Software Specification
- System Development Environment
- C sharp(C#)
- Design Goals
- Introduction About .Net
- DOT NET database connectivity(ADO.NET)
- RDBMS Concepts
- The SQL Language
- Project Designing
- Design Document
- Data Flow Diagrams
- Unified Modeling Language(UML)
- Screenshots 30 - 55
- Software Testing Strategies 56
- Conclusion 57
- Bibliography 58
Table Of Content Page No.
System Requirement Specification
System Requirement Specification
1. Introduction
Purpose:
The objective of Store Management System is to allow the administrator of any organization to add and edit the products details and allows the administrator and employees to keep sale and purchase record. It’ll also facilitate keeping all the records of employees, such as their id, name, address, phone number, job title etc. So all the information about an employee will be available in a few seconds.
Overall, it’ll make management of store an easier job for the administrator and the employees of any organization. It is intended to help any organization to maintain and manage its employee’s personal data and maintain sale and purchase record. The main purpose of this document is to illustrate the requirements of the project Store Management System.
Scope:
Without a Store Management System , managing and maintaining the details of the products and employees is a tedious job for any organization.
Store Management System will store all the details of the product including product id, name, category, price, company etc. It maintain purchase and sale record with an automatically maintained stock module. This project will also manage employee’s information apart from maintaining sale and purchase of products.
PROJECT OVERVIEW:
MODULE DISCRIPTION
Store Management System mainly consists of four modules...
- Login
- Home
- Sale Record
- Purchase Record
- Stock
- Employees details
- Registration
Login module :
Login module will help in authentication of user accounts. Users who have valid login id and password can only login into their respective accounts.
Home :
Store Management System maintains the sale and purchase record from which latest five entries from both sale and purchase record will be displayed to the user in this module.
Sale Record:
In Sale Record, the users are allowed to enters the details of the sale made. The users has to enters the details of the sale made such as price, units, etc. The user just has to select the product he wants to sale and enters minimum details to make a sale record. All the record of sale will be displayed in this module.
Purchase Record:
In Purchase Record, the users are allowed to enters the details of the products the user has purchased. The users has to enters the details of the purchase made such as price, units, etc to create a record. The user just has to select the product he wants to purchase and enter minimum details to make a purchase record. All the record of purchase will be displayed in this module.
Stock:
Stock is the most important module of Store Management System. This module will maintain the details of all the available stocks. It is maintained
GOALS AND OBJECTIVES
⮚ To make the jobs of User/admin easy and trouble free.
⮚ To make the application user friendly.
⮚ To reduce the errors those are occurred in the manual system.
⮚ To generate the reports as per the management requirements.
⮚ To provide maximum services to the users.
⮚ To manage the record of purchased products, sold products and stock
online.
⮚ To increase efficiency while managing products and sales.
⮚ To show the complete description of products.
⮚ To simplify adding, updating and deleting records.
⮚ To provide automatic management of stock.
⮚ To provide users anytime, anywhere managing of records.
⮚ To maintain complete details about the employees.
⮚ To provide users a simplest and efficient way to manage their business
records.
1. Project Analysis
Existing System
Present system is manual. The Project Metrics has to enter all the details of project, documents, and tasks. It also maintains the team information and also efforts estimation. For this purpose the organization maintain the huge amount of document, the information about team member’s details manually. Which is much of time consuming process and more importantly it was error prone.
Limitations of the Manual system
- It was time consuming
- It leads to error prone results
- It consumes lot of manpower to better results
- It lacks of data security
- Retrieval of data takes lot of time
- Percentage of accuracy is less
- Reports also maintained manually
Hence Computerization of the existing system is proposed. The new system completely removes all the burdens of manual task and provides efficient way to handle the system.
Hardware and Software Specifications:
SOFTWARE REQUIREMENT
OPERATING PLATFORM : WINDOWS 7/8/
BACK END : ORACLE DERBY DATBASE
SOFTWARE : JDK 7 or 8 with Netbeans IDE
FRONT END TOOL : NODE JS
RESOLUTION : 1366 x 768
WEB BROWSER : Chrome, Firefox, Explorer
HARDWARE REQUIREMENT
RAM : 512MB or Higher
HARD DISK : MINIMUM 20 GB or Higher
PROCESSOR : Dual Core CPU or Higher
MONITOR : 15” Color
1. System Development Environment
Angular
What is Angular?
Angular is an open source Model-View-Controller framework which is similar to the JavaScript framework. Angular JS is probably one of the most popular modern day web frameworks available today. This framework is used for developing mostly Single Page applications. This framework has been developed by a group of developers from Google itself. Because of the sheer support of Google and ideas from a wide community forum, the framework is always kept up to date. Also, it always incorporates the latest development trends in the market.
Angular Features
Angular has the following key features which makes it one of the powerful frameworks in the market.
- MVC – The framework is built on the famous concept of MVC (Model- View-Controller). This is a design pattern used in all modern day web applications. This pattern is based on splitting the business logic layer, the data layer, and presentation layer into separate sections. The division into different sections is done so that each one could be managed more easily.
- Data Model Binding – You don't need to write special code to bind data to the HTML controls. This can be done by Angular by just adding a few snippets of code.
- Writing less code – When carrying out DOM manipulation a lot of JavaScript was required to be written to design any application. But with Angular, you will be amazed with the lesser amount of code you need to write for DOM manipulation.
- Unit Testing ready – The designers at Google not only developed Angular but also developed a testing framework called "Karma" which helps in designing unit tests for Angular applications.
Angular Advantages
● Since it's an open source framework, you can expect the number of errors or issues to be minimal. ● Two-way binding – Angular.js keeps the data and presentation layer in sync. Now you don't need to write additional JavaScript code to keep the data in your HTML code and your data later in sync. Angular.js will automatically do this for you. You just need to specify which control is bound to which part of your model.
