FLOWER SHOP MANAGEMENT SYSTEM A report of the mini project work submitted in partial fulfillment of the requirement for the award of Degree of BACHELOR OF COMPUTER APPLICATIONS
SUBMITTED BY SHEEJA JOSEPH (REG. NO. 111560 63)
Under the guidance of Mr. SHIBU KALLARACKAL MCA (Lecturer Department of Computer Science)
DEPARTMENT OF COMPUTER SCIENCE MAR AUGUSTHINOSE COLLEGE (Affiliated to Mahatma Gandhi University) RAMAPURAM- 686576 2011-2014
MAR AUGUSTHINOSE COLLEGE RAMAPURAM (Affiliated to Mahatma Gandhi University)
CERTIFICATE This is to certif y that this project work entitled “FLOWER SHOP MANAGEMENT SYSTEM ” is a bonafied project done by NAYANA MOHAN (Reg. No.111560 41) during the academic year 2011 -2014 for the partial fulfillment for the award of the Degree of bachelor of Computer Applications from Mahatma Gandhi University, Kottayam.
Mr.Prakash Joseph , MCA Head of the Department
Viva-Voce Examination conducted Augusthinose College, Ramapuram.
Internal Examiner
Place :Ramapuram Date :
Mr.Shan Augustine M.Sc. Project Guide
on……………………….. at Mar
External Examiner
DECLARATION
I hear by declare that the project work entitled MANAGEMENT SYSTEM” submitted requirements Computer
for
the
award
in of
partial the
“FLOWER SHOP fulfillments
bachelor
the
degree
in
Application from Mar Augusthinose College, Ramapuram, is
record of bonafied work done
guidance of Mr.Shan Augustine, Lecturer in
the Department of Computer Science.
Place: Ramapuram Date:
of
NAYANA MOHAN
ACKNOWLEDGEMENT I take this opportunity to express our gratitude & sincere thanks to all who help us to complete this project work successfully. First of all I would like to thank the God almighty who has been a constant support in every walk of our and the source of strength to perform this project work.
I would like to express our sincere gratitude to
Dr.V.J.Joseph
M.Com,FCA, principle, Mar Augusthinose College, Ramapuram, for giving us to an opportunity for this project.
I express our immense gratitude to Mr.Pkakash Joseph,MCA, Head of the Department of computer science, for his valuable guidance, valuable suggestions and encouragement to complete this project work and I also extend our special thanks to Mr.Shan Augustine M.Sc. for providing necessary details and guidance.
I wish to express our sincere thanks to all our friends for their kind cooperation and moral support. Once again I thank one and all who had helped us directly or indirectly in the successfully completion of the project.
NAYANA MOHAN
CONTENTS 1. INTRODUCTION 1.1. About the system 1.2. About the organization 1.3. Synopsis 2. SYSTEM STUDY 2.1. Existing System 2.2. Proposed System 2.3. Organization Chart 3. SYSTEM ANALYSIS 3.1. Feasibility Study 3.2. Visual Basic 6.0 3.3. MS SQL 3.4 . System Requirements 4. SYSTEM DESIGN 4.1. Introduction 4.2. Input Design 4.3. Output Design 4.4. Data Flow Diagram 4.5. Table Structures 5. TESTING AND IMPLEMENTATION 6. CONCLUSION AND FUTURE SCOPE 7. BIBLIOGRAPHY 8. SCREEN LAYOUTS
INTRODUCTION
1.1 ABOUT THE SYSTEM The project titled “FLOWER SHOP MANAGEMENT SYSTEM” is a comprehensive system which co-ordinates various operations in flower shop. This includes a variety of collections of flowers and flower made products such as flower arrangements, flower bouquets etc .This project deals with the booking of various flower products to the various customers, updating and editing of flower products rates and searching for employees, customers and calculation of bills. We first check the availability of the particular flower. Then if available sale it to the particular customer. The objective of the project is to make good software with an overall performance. The software should be easy to work. The software should be able to extract information from databases and make the reports very easily. The software and its operations should be safe and unauthorized access should not be allowed.
1.2 ABOUT ORGANIZATION The organization selected for the project is “KIRAN FLOWER SHOP” in Palai. It is incorporated as a private firm in 1995 and at Palai, Kottayam district. Many people are employed in the shop. All the transactions are done manually. Aim of this organization is maximum customer satisfaction.
1.3 SYNOPSIS The aim of developing and implementing the software titled “FLOWER SHOP MANAGEMENT SYSTEM” is to automate the complete system of FLOWER SHOP through computer with maximum user interactions.
The system is designed using VB6.0 as front end & MS SQL as backend in WINDOWS XP operating system. The developed software is easier and flexible to handle. Computerization can give fast services to the customers. The system because more efficient and cost effective and manual errors lessened. The software is user friendly and completely based on menu driven. I will selected the flower shop in pala , named “KIRAN FLOWER SHOP”. The flowers are supplied by various distributers. Customers can order flowers & flower products before 2 or 3 days , when they are actually wanted.
SYSTEM STUDY
EXISTING SYSTEM
The existing system is a manual system. The proposed system tries to simplify the difficulties encountered in manually handling the information about the books, stocks and sale. In this case the details of sales, books and stocks in hand are stored in one or more registers.
The existing system needs number of staff and a lot of time consumption for the process. When we compare the existing system with the proposed system, there are many drawbacks for the existing system.
DISADVANTAGES OF THE EXISTING SYSTEM
The system under study is a non-computerized system. The main drawbacks of existing system are: The existing system needs a number of registers for handling the records. This leads to tedious manual labor. The calculations require a large amount of clerical time. Generation of various reports is very difficult and time consuming. The system is less reliable due to the possibility of human errors that occur while entering data and during calculations. Number of employees is required for the processing of entering data into different record. Low accuracy. Updating of written records is very difficult. Data processing is very low. Accessing previously stored records is a time consuming task.
PROPOSED SYSTEM
The main objective of the proposed system is to overcome the drawbacks of the existing manual system. The need for computerized system arises as the manual maintenance and handling of process becomes more and more tedious and complex .The computerization of the system helps to save a lot of time. It is very difficult to maintain all the details of each of the record manually. Also reference to a particular record leads to consume more time whereas the computerized system rectifies most of these drawbacks. The calculations are done in a few seconds and with the help of various reports generated several conclusions can be drawn easily. The wide use of computers as they offer valuable facilities is difficult to stimulate in any other way.
The facilities are given below:-
Greater Processing Speed: Since computers process data very quickly there inherent speed is one reason why people seek in the development of system project. Accuracy and Improved Consistency: The management will benefit from system consistency and better accuracy. Faster Information Retrieval: The information is being located and retrieved from storage at a faster rate than the manual system. Security and Privacy: Data can be made accessible only to persons having authorization thereby preventing illegal users. Reduced Cost: Using computing capability data can be process lower cost than the other system while maintaining accuracy and performance level.
Reports available in the computerized system are expandable to any future developments hence ability to interact with the future needs exists in the
computerized system. Also protection of data can be achieved in the computerized system. There for security and privacy can be ensured. By all means the computerized system is quite feasible.
ADVANTAGES OF PROPOSED SYSTEM
The proposed system has got several benefits as compared to that of the existing one. Those benefits are as follows:• Time delay for any process is reduced. • Cost of establishment and maintenance are lower than a manual system. • Faster and more accurate retrieval of information. • Generation of various reports is made easy. • Number of employees is reduced. • Simple and easy to manage. • Storage spaces for registers are not possible. • More efficient and reliable than the existing system • Unauthorized accessing is not possible.
SYSTEM ANALYSIS
3.1 FEASIBILITY ANALYSIS
System that meets the performance requirements at Feasibility study is performed to choose the least cost. The most essential task performed by the feasibility analysis is the identification and the description of the new system, evaluation of the new system and selection of the best new system. In general, feasibility study of a system means checking whether the system proposed is practically possible or not.
Many feasibility studies are desirable for both users and analyst. First, the study often opposes that when the feasibility document is being prepared, the analyst is in the position to evaluate the solution .Second most studies tend to overlook the confusion inherent in the system development.
FEASIBILITY CONSTRAINTS
In feasibility analysis, there are three key considerations and they are as follows: Economic feasibility, feasibility and operational feasibility.
1. Economic Feasibility
Economic is the most frequently used method for the effectiveness of a new system .The more commonly known as cost/benefit analysis, the procedure is to determine the benefits and savings that are expected from a candidate system them with costs.
2. Technical feasibility
Feasibility is performed to check whether the proposed system is technically feasible or not. Technical feasibility centers on the existing computers. This proposed system is technically feasible. All data are stored in database table. The interfaces designed are user-friendly. 3. Operational feasibility Operational feasibility is done to check whether the system is operationally feasible or not. Using commend button throughout the application program enhances operational feasibility. So maintenances and modification found to be easier.
3.2 VISUAL BASIC 6.0 Microsoft Visual Basic 6.0 is a language rapid application development environment that gives you fast, easy, and intuitive tools to quickly develop Windows application. Using Visual basic, You can develop simple utilities or sophisticated applications .Data access features allow to create databases, frondend application and scalable server-side components for most popular database format .ActiveX technologies allow you to use the functionality provided by the application and even automate applications and objected created using the professional or Enterprise editions of Visual Basic . Internet capabilities make it easy to provide access to documents and applications
across the Internet or
Internet from within your application, or to create Internet server applications.
3.3 SQL SERVER 2000 Microsoft SQL Server is a full- featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. In this article, we will cover six of the more frequently used tools: Enterprise Manager, Query Analyzer, SQL Profiler, Service Manager and Data Transformation Service Let’s take a brief look at each: Enterprise Manager is the administrative console for SQL Server installation. It provides you with a graphical “birds –eye” view of all of the SQL Server installation on your network. You can perform high–level Administrative Functions that affects one or more servers, schedule common maintenance task or create and modify the structure of individual databases. Query Analyzer offers a quick and dirty method for performing queries against any of your SQL Server databases. Its great way to quickly pull information out of a database in response to a user request, test queries before implementing them in other application, create/modify stored procedure and execute administrative task. SQL profiler provides a window in to the inner working of your database. You can monitor many different event types and observe database performance in real time. SQL profiler allows you to capture the replay system “traces” the log various activities. It’s a great tool for optimizing database with performance issues of troubleshooting particular problem. Service Manager is used to control the MSSQL Server (the main SQL Server process), MSDTC Microsoft Distributed transaction coordinator) and SQL Server Agent process. An icon for this service normally resides in the system try of machines running SQL Server .you can use service Manager to start, stop or pause any one of these services.
Data Transformation Services (DTS) provide an extremely flexible method for importing and exporting data between a Microsoft SQL Server installation and a large variety of other formats. The most commonly used DTS application is the “Import and Export Data “wizard found in the SQL Server program group.
3.4 SYSTEM REQUIREMENT The Software Requirement Specification is produced at the culmination of the analysis task. The function and performance allocated to software as a part of system engineering are refined by establishing a complete information description, a detailed functional description a representation of system behavioral indication of performance requirements and design constraints, appropriate validation criteria, and other information pertinent to requirements. The introduction of the software requirements specification states the goal and objectives of the software, describing in the context of the computer-based system. The information Description provides a detailed description of the problem that the software must solve. Information content, flow and structure are documented. Hardware, software and human interfaces are described for external system elements and internal software functions. A description of each function required to solve the problem is presented in the function Description. A processing narrative is provided for each function, design constraints are stated and justified, performance characteristics are stated, and one or more diagrams are included to graphically represent the overall structure of the software and interplay among software functions and other system elements.
The behavioral Description section of the specification examines the operation of the software as a consequence of external events and internally generated control characteristics Validation criteria is probably the most important and, ironically, the most often neglected section of the Software Requirement Specification of validation criteria acts as an implicit review of all other requirements. Finally, the specification includes a bibliography. The bibliography contains references to all documents that relate to the software.
SYSTEM DESIGN
4.1 INTRODUCTION In the design phase the detailed design of the system selected in the study phase is accomplished. Major steps in design are; 1. Output to be produced. 2. Method of the data captures and data input. 3. Modification to be done to convert the existing system to be proposed system 4. Operation to be performed to produce output and maintain the file. 5. Design input and output forms
System design goes through physical and logical stages of development. Logical design reviews the present physical system, prepares input and output specifications make edit security and control specification. The physical design maps out the details of physical system plan the system, implementation, device test, post implementation and species new hardware and software. System design is a transaction from a user oriented documents oriented to programmer or database personal. It is a creative activity in both art and technology. It involves the following procedures they are:1. Database design 2. Input design 3. Output design 4.2 INPUT DESIGN Input design is the process of converting the user originated input into a computer based format. The input data are collected and organized to make date entry easy, logical, and error free. Each area in the input form should be identified and should be specified for the user what to write and where to write.
The objective in the input design is to ensure that the data which will be processed by the system is collected and inserted in to the system efficiently according to the specified requirements, and with the minimum errors. The basic design consideration that would satisfies the user requirements were as follows.
A) Easier and congenial usage of field names to make them user friendly . B) The same sequence for displaying fields as in the source Document
Regular interaction with the user was made to ensure the acceptability of inputs. The human aspect of data input was taken in to account. Common representations were followed and above all the simplicity of inputs was maintained.
4.3 OUTPUT DESIGN Output is a process that involves designing the necessary output that have to be given to various users according to their requirements .Efficient, intelligible output design should improve the system relationship with the user and help and in decision making. A major form of the output is the hard copy from the printer. The output devices are selected by considering the response time requirements print quickly etc... The print formats and edition for the final printout are very much considered during output design.
DATABASE DESIGN It is a process of designing the database files, which is the key source of the information in the system. The objective of database design is to provide storage and it contributes to the overall efficiency of the system. The file property designed and planned for collection, accumulation, editing and retrieving the required information.
TESTING AND IMPLEMENTATION
TESTING METHODS During the development of a new system the whole program is divided in to modules. The coding of these modules is done independently and in the end all the modules are linked together to form the running unit. The system is implemented after it is tested and corrected. Testing is carried out in the stages: 1. Unit testing 2. Integration testing 3. System testing
TEST PLAN ACTIVITIES 1. UNIT TESTING This is the first level of testing. A number of test runs are conducted. For each test run there is a list of condition tested, the test data used and the result expected .Each and every form in the project Brilliant Administration System was tested using sample data occurred during test run. 2. INTEGRATED TESTING Integrated testing is the second stage in system testing .This testing is also called link, sub system or level one testing because it is an intermediate step between testing each program in isolation and testing the whole system. The purpose of integration testing is to test the interfaces between programs in the same functional area. Integration testing was carried out in the project and ensures that the interface between different programs is working efficiently.
3. SYSTEM TESTING System testing is done to ensure the quality of
the system developed.
During System testing each condition and combination of condition is tested. The purpose of system testing is to test the whole system exhaustively. SYSTEM IMPLIMENTATION Implementation is that stage in the project where the theoretical design is turned into working system. The most crucial in achieving a new successful system and in giving confidence in the new system and effectively. The first step in implementing the system is in getting the approval from the system manages. The data entry, various menus and the mark list that the system is capable of producing are shown to examine. This is done in view of any last minutes, changes that will be necessary in the format.
CONCLUSION
CONCLUSION AND SCOPE FOR FUTURE ENHANCEMENT
The software package for the new system has been designed and is found to be functioning well and error free. This system is a user friendly system that can be operated by any person with no prior knowledge about the system. All the necessary validations are carried out in this project so that any kind of user can make use of this software. The process of preparing planes has been totally new experience .This helped a lot in later phases of the project .Great effort has to be taken to make the system user friendly and simple as possible. For Maximum utilization of the system , users should make sure that all the data entries are made in time and care should be taken in checking whether the entries are completed. This project work is not without any drawback even though it is unique in its nature .A very good experience has been gained during the time of project.
BIBLIOGRAPHY
BIBLIOGRAPHY
1.Guide to visual basic 6.0
Peter Norton
2.System analysis and design
Alias M.Award
3. An introduction to database management
C J Dale
4.Database management System
James Martin
1. Login :- Used by the owner and employees for login purpose
Column name
Data Type
Length
Description
Constraint
lid
Varchar
4
Login id
Primary key
username
Varchar
20
User name
password
Varchar
20
Pass word
2. Distributor :- To register the flower distributor details
Column name
Data Type
Length
Description
Constraint
did
Varchar
4
Distributer id
Primary key
dname
Varchar
20
Distributer name
dlocation
Varchar
20
Distributer Place
dphone
Varchar
12
Distributer Phone No.
3. Item:- About the flower items
Column name
Data Type
Length
Description
Constraint
IID
Varchar
4
Item id
Primary key
Iname
Varchar
20
Item name
4. Flower :- About the flower types Column name
Data Type
Length
Description
Constraint
fid
Varchar
4
Flower Id
Primary key
iid
Varchar
4
Item Id
Foreign key
fname
Varchar
20
Flower name
fcolour
Varchar
20
Flower colour
fprice
int
4
Flower price
season
Varchar
8
Season
did
Varchar
4
Distributor Id
Foreign key
5. Flower Item :- Details about the flower items
Column name
Data Type
Length
Description
Constraint
fiid
Varchar
4
Flower Item Id
Primary key
finame
Varchar
20
Flower Item name
fid
Varchar
4
Flower id
Foreign key
iid
varchar
4
Item id
Foreign key
int
4
Flower item price
fiprice
6. Order :- To enter the order details
Column name
Data Type
Length
Description
Constraint
Oid
Varchar
4
Order Id
Primary key
IID
Varchar
20
Item Id
Foreign key
FIID
Varchar
4
Flower Item id
Foreign key
FID
varchar
4
Flower Item id
Foreign key
CID
Varchar
4
Customer id
Foreign key
Odate
varchar
8
Order date
Ddate
varchar
8
Delivery date
int
4
Advance amount
AAmount
7. Customer :- To enter the customer details
Column name
Data Type
Length
Description
Constraint
cid
Varchar
4
Customer Id
Primary key
cname
Varchar
20
Customer name
clocation
Varchar
20
Customer location
cphone
varchar
20
Customer Phone No
8. Stock :- Stock Details
Column name
Data Type
Length
Description
SID
Varchar
4
Stock id
FID
Varchar
4
Flower id
Quantity
Varchar
4
Quantity
Date
varchar
4
Date
Constraint
Foreign key
9. Sale:- To enter the sales details
Column name
Data Type
Length
Description
SID
Varchar
4
Sale id
OID
Varchar
4
Order id
D/N
Varchar
4
Delivered note
Constraint
Foreign key
10. Payment :- To enter the payment details
Column name
Data Type
Length
Description
PID
Varchar
4
Payment id
OID
Varchar
4
Order id
P Amount
int
4
Advance Amount
R Amount
int
4
Remaining
Constraint
Foreign key
Amount
11. Employee :- To enter employee details
Column name
Data Type
Length
Description
EID
Varchar
4
Employee id
Ename
Varchar
20
Employee name
Egender
Varchar
4
Employee gender
EAge
Varchar
4
Employee Age
EDesignation
Varchar
20
Employee designation
EHName
Varchar
20
Employee House name
Eplace
Varchar
20
Employee place
Ephone
Varchar
20
Employee phone number
EDistrict
Varchar
20
Employee district
Estate
Varchar
20
Employee state
Constraint
12. Salary :- About the Employee Salary details
Column name
Data Type
Length
Description
SAID
Varchar
4
Salary id
EID
Varchar
4
Employee id
Date
Varchar
8
Salary date
int
4
Amount
Amount
Constraint
Foreign key
