+The Flower BoxPoint of sale system1) AbstractThis project is regarding the point of sale system. This project explores about new ideas and functionalities during the completion of the system. It is a great opportunity to improve the different level of programming ability, planning, scheduling, testing skills and analyzing the project. And this also helps to understand the deep concept about VB.Net, MySQL.This is an offline application which helps the owner and the cashier to record the details about the customers, employers and the products/plants. MySQL is used to create the database to store data which is known as backend, while VB.Net is utilized front end of the system.This project mainly consists of two modules. The first module is the admin and the second module is the cashier. The admin module explores about the recordings of the customers, products and employers. Furthermore, this module has the ability to back up the system and weekly profit report. The cashier module contains about the invoice of the product and the rental products.Contents1) Abstract2) Acknowledgment3) Introduction3. A) Current system of the project (Problem Statement)3. B) Drawbacks of the existing system3.C) The Proposed System3. C.1) Benefits of proposed system3. D) Aims, objectives, scope & architecture3. D.1) Aims3. D.2) Project Scope4) System Analysis4. A) Fact finding methods4. B) Analysis specification4. C) Requirement Specification4. D) Functional Requirements4. E) Non-functional requirements3. F) High level architecture3. G) Risk analysis5) System design5. A) Approach & Development Methodology5. A. 1) Benefits of agile development5. B) Data model5.C) Structural Model5. C.1) Initial class diagram5. C. 2) In-details class Diagram5. D) Behavioral model5. D.1) Use case diagram5. D.2) Activity Diagram5. D. 3) Sequence Diagram5. E) Graphical user interface designs6) Testing6. A) Test plan6. B) Black Box Testing6. C) White box Testing2) AcknowledgmentI would like to convey my appreciation to all those who support me in order to complete this project with encouragement, suggestions and with proper guidance. I give this special gratitude to final year project supervisor Mrs. Samantha Gamage, Miss Himali Wickramasinghe for the support and guidance for the project and Mr. Trevin Motha, the encouragement throughout this completion of project.Furthermore I like to thank all teachers and friends who supported and motivate towards the project. Without their help and guidance all the efforts could have been short sighted. Also, I would like to thank my parents, friends and for being with me motivating me to do this quality report. I would like to thank every single person who at least helps me with a word to make this report a success.3) Introduction 3. A) Current system of the project (Problem Statement)According to the situation of the business, the owner faces difficulties with the current system as Mrs. Dias (Owner) follows a manual system to update the records of the products and weekly profit. The owner hired one employed as a cashier and Mrs. Dias (Owner) didnt include any details about the employer to the manual system as its a small scale of business. Within the time, the owner is struggling to manage the manual system as the profit increased and she had to hire another few employees too. Considering these reasons, the owner decided to maintain the record of profits, products (Plants), detailed record of employers, detailed record of customers who are renting the plants and print the receipt or the bill on a point of sale system.This business consists of two types of purchasing methods as in selling and renting. Selling based on day today customers and renting based on hotels and restaurants.The new system which is proposed has the potential of storing data about the detailed record of products/plants, employers, customers. Also, it provides report of weekly profits, seasonal items, and rental items and print the bill/receipt for the customer.3. B) Drawbacks of the existing systemTime Consuming & inconvenientA major drawback in the current system is time consuming. As proof all the records must be composed in the register book as further reference which is inconvenient. Goods cannot be purchased simultaneously as the current system cannot perform parallel transactions as there is only one payment terminal at the store. During peak hours, the customers have to wait in queue for a quite long time to process their payment. It has come to the attention of the founder and employees that they are discontented and uncomfortable during peak hours as they feel packed in the small area.Locale LimitationsAs its a small scale business and due the lack of branches of the flower box floral, the business can only reach a limited number of customers in the local areas.Lack of BackupsSince the bills provided by the founder, Proper backups are not been maintained such as reports and transactions. This can lead to financial breakdowns of the company.Lack of proper database managementThe current system has manual system for the transaction, every transactions are stored in accounts book.Human made errors and data duplication:Since all the transactions are written in book it may cause errors such as accidental repeating records or incorrect dates of the transactions or incorrect calculation errors.3.C) The Proposed SystemIn order to reduce the burden of such problems mentioned above, an offline system is created to increase the efficiency and effectiveness of the system. This will gradually lead to lessen problems the customers face while shopping in the Flowerbox Floral and make them to be attracted and have more interest to visit the shop again. Hence, it also reduces time consumption and inconvenience making the shopping system more efficient. How the above mentioned proposed system can be generated as mentioned below.3. C.1) Benefits of proposed systemConvenience & EasinessOnce the customer or buyer selects his or her species of plant, the cashier will provide a bill or receipt with all the information including the date, price, time and number of items of the same species selected about the plant. At the same time, the system database will show how many plants of the selected item has been sold out and how many are still available in the Floral shop that makes it convenient for the cashier or the founder to sum up the last account records . As a major advantage, an information card is given to the buyer in relation to the rules and regulations of how to care and maintain the plant according to its species unlike other floral shops.Generate reportsOwner can view and generate list for the seasonal items and annual report for profits and losses every week automatically.Comprise maintenance Information cardAn information card is given comprising of all the details such as the optimum temperature, life span recommended shelter by the plant, water and sunlight consumption, whether the plant can be kept as an indoor or outdoor plant and many more useful information is provided by the user friendly Flowerbox Floral shop regarding the plant. This can be followed by the buyer in order to maintain a healthy plant.Keep a record on the customers buying habitKeeping a record of customers buying the products must be recorded carefully. As a privilege for the customers a discount card can be permanently given and whenever they buy the product a discount can be given. Hence, this card will be given for customers who purchases plants of more than 2500/= this will attract the customers and make them more satisfied to buy more plants as they are sure to be given a discount for whatever the species of plant that are bought after the purchased card. This can be done in order to improve more customer visits to the floral shop and also to keep an ongoing rapport and at the same time to build up intense long-lasting relationship.CompetenceSetting up this manual system can cost very low, resulting in a high profit since there are no other online advertisements available. To have a good start for the business with less employees and training them in a way to know the manual billing system and most of all to satisfy customers needs is the main target rather than taking many employees and expanding the business in a minute which can result in loss of business.Boost Brand AwarenessAccording to the new proposed system, new customers will want to try our goods as individual care is given to each and every species of orchid family they are willing to buy. This can increase the sales, increasing awareness in the market and also helping the business.Decrease in CostsAdvertising and Marketing CostThe small scale business does not have to spend money on business on advertising and marketing as social media traffic, which is the best way to increase sales can be expected rather than spending huge amount of money on advertising and marketing as mentioned above.Offer Huge InformationTraining a handful of employees well, giving them the knowledge of each and every species of plant available in the store, can lead the customers to be more satisfied with the product that he/she is going to purchase according to their needs. Rather than machines providing answers to the customers doubts they become more content and carefree with which product they have to buy when an employee talking to them face to face providing a favorable reply to their doubts.ScalabilityWith this solution, the organization can grow and scale easily to meet the customer requirements as well the market demand.3. D) Aims, objectives, scope & architecture3. D.1) AimsThe aim of the proposed system is to create a manual offline system as this is not an expanded business.In the near future, it is expected to open more branches around the world where customers can always visit and meet their desires. Unlike an online system, the customer can have a careful look and observe the product they are going to purchase, rather than purchasing the goods looking at an advertisement or a website which will not be the true image displayed. Species that are displayed online can never be thought to be the perfect plant the customer desires and there will be no exchange or a receipt purchased and therefore they will not be able to return the product if they are not satisfied. Hence it will be complicated for the customer to send his or her feedback regarding the plant as online systems may take few days to reply for their feedbacks.The small scale business can be financially benefitted as there is no money spent for advertisements. Unlike online systems, there will not be any sort of breakdown in the system where the customers will be irritated if the systems are not functioning well. There can also be a doubt if the online system is being updated daily regarding the plants sold and also the plants currently available at the store.3. D.2) Project ScopeThe main target of this project is to fulfill the customers desires and needs according to what they wish for and making it more realistic in todays world. For customers those are clueless about the different types of orchids will have a thorough background information from the employees as they are well trained for different types of species. More attention is given to customers to show the hidden truth about the orchid family and making them more concern in how to bring up their plants. The customers have the ability to contact us, whatever the situation is. To train the few employees under the founder is very crucial. This wont be a complicated task as there are only a handful of employees. Rather than having a huge staff, its more realistic to have few staff members and give them more them knowledge about the specific field and to pay them a favorable salary.The technologies used for the development of this e-Commerce are as follows:-VB.Net is an Object Oriented programming language is used create applications.MySQL is used to connect with the database and it is an open source database.4) System AnalysisSystem analysis defines as a procedure of collecting actual data to identify the problems, process of the system and to enhance the system. This involves feasibility study as in economical, technical, and social in order to maintain disclosure with the client to complete the system and its functions properly.4. A) Fact finding methodsFact finding is gathering information about the existing and proposed system. That helps to identify the requirements which business needs and flows of the existing system. Interviews, observations and questionnaires are fact finding methods.InterviewMeeting can take as a discussion between two individuals with a specific end goal to gather appropriate data to the system. Interview helps to create quality system by answering questions in regards to the system, business and the requirements. There are five sorts of meetings. 1. Personal interview, telephone interview, focus group interview, depth interview, projective technique.QuestionnaireQuestionnaire defines as predefined questions which used to collect information from the employees. Questionnaires includes open question questionnaires (which is help to produce unexpected results as in original and valuable), multiple choice questions (these type of questions have set of answers for the question.), Dichotomous Questions (these type of questions contain only 2 options), Scaling Questions (these questions refers as ranking questions)ObservationObservation consider as certainty discovering strategy which recognize data through perception, hearing, touch and so on. This discovers important data to the system.4. B) Analysis specificationAnalysis specification is understanding the requirements of the customer and the system in a specification document. The necessities which are distinguished arranged into two segments functional and non-functional requirements. Functional requirement defines as what the system should do according to the user where as non- functional requirement defines as behavior of the system according to the certain functions.MoSCoW approach is organizing requirements and objectives of a framework. This strategy separated into four classifications. M stands for Must have, S stands for Should have, C stands for Could have, W stands for Wont have.4. C) Requirement SpecificationAdmin Dashboardadmin loginadmin logout add product Update productDelete productSearch product View seasonal productView weekly report Back up the databaseregister employeeview employee detailsdelete employee detailsupdate employee detailsregister customerview customer detailsdelete customer detailsupdate customer detailscashier2.1 cashier login2.2 cashier logout2.3 view product2.4 search product2.6 register employee2.7 view employee details2.8 delete employee details2.9 update employee details2.10 register customer2.11 view customer details2.12 delete customer details2.13 update customer details2.14 view rent items2.15 generate an invoice4. D) Functional RequirementsRequirementsMoSCow prioritizationProductAddUpdateDeleteViewMust haveShould haveShould haveShould haveviewCashier detailsCustomer detailsRented itemsSeasonal itemsShould haveShould haveShould haveCould haveSearchProductCashier detailsShould haveShould haveCashier managementCashier registrationCashier loginCashier logoutMust haveMust haveMust haveAdmin managementAdmin loginAdmin logoutMust haveMust haveGenerate InvoiceGenerate invoiceMust haveGenerate reportWeekly reportShould have4. E) Non-functional requirementsUsabilityUsability defers as making the system easier to use and also meet the user requirements. At this stage the scope of this system is small and it is easy to maintain the usability throughout the system. Usability effects the effective and efficiency of the system.User friendlinessUser friendliness thoroughly maintain with the system. At this stage the consistency of the in each and every window, the readability of the content and use of appropriate windows appearances in related sections.3. F) High level architectureThis is use in the agile development methodology to clearly understand the activities witch in the system. In other words at this stage the flow of activities within the system are clearly displayed based on the activities.3. G) Risk analysisRisk analysis characterizes as a method of distinguishing issues and oversee it which debilitate the business system or the venture. It perceives the shortcomings or dangers amid the procedure of venture with the goal that it will deal with those issuesRisk analysis defines as a procedure of identifying problems and detects the weaknesses of the business strategy or the project.it helps to recognize the weaknesses or threats during the process of project so that it will help to handle those problems.RiskLikelihood(low medium high)Impact(low medium high)actionsThe stages in the project exceed the time limit.mediumhighWhen concerning about the time management leave extra time for necessary situations.Confusion when enhancing the user friendliness of the system.LowMediumRefer to similar to system in order to get effective ideas about user friendliness.Errors during the development of the system.MediumHighRefer necessary materials to be acknowledge about avoiding errors and solving errors during certain situations.Issues when creating the data structure in the database management systemMediumHighRefer resources when creating the data structures.The scope to be tested not clearly identified.LowMediumRefer the project scope before carrying out testing.5) System designThis is the stage where that system is built with all the functions. This includes hardware, software, graphical user interfaces, and structure of the network. The purpose of this stage is to make sure that to clarify the misconception in input, output and process as documented.5. A) Approach & Development MethodologyApproach & Development Methodology is programming strategy which is utilized to give quality venture or frameworks to the client. This depends on iterative improvement which can coordinate with extensive complex framework. There are separate spry procedures, for example, scrum, incline, kanban and so on.Scrum normally utilized for complex frameworks which can break into segments and work as indicated by it.5. A. 1) Benefits of agile developmentIterative process improve to add new features to the system to cooperate with existing elements.Agile methodology gives a good quality product by testing which is breaking in to section to focus on each section carefully.5. B) Data modelThe data model is a diagram which is easy to understand the logical structure of a database. ERD (Entity Relationship Diagram) used to show relationship between the entities.5.C) Structural ModelStructural model provides the perspective of the system with the includes of objects, relationships, attributes and operations.5. C.1) Initial class diagram5. D) Behavioral modelBehavioral model is model which shows the dynamic behavior and the flow of the logic of the system. This recognizes the parts in the framework and how it impact to the framework.5. D.1) Use case diagramUse case diagram outline graphical representation which present interactions between elements of a system.Initial use case diagramUse case ID:001Use case Name:ProductCreated by:Dinithi DiasLast updated byDinithi DiasDate Created:13/05/2017Last Created by13/05/2017ActorsAdmin, CashierDescriptionAdmin can register product and also edit product details, can view seasonal items, product details, weekly report and also back up the databaseCashier can view the product details and generate the invoiceIncludes_Extends_Special Requirements_Assumptions_Use case ID:002Use case Name:RegistrationCreated by:Dinithi DiasLast updated byDinithi DiasDate Created:13/05/2017Last Created by13/05/2017ActorsAdmin, CashierDescriptionAdmin and cashier can register customer and cashier and also edit product details, can view the details of customer and cashierIncludes_Extends_Special Requirements_Assumptions_In detail use case diagram Use case ID:001Use case Name:Registration (in detail Use case Diagram)Created by:Dinithi DiasLast updated byDinithi DiasDate Created:13/05/2017Last Created by13/05/2017ActorsAdmin, CashierDescriptionAdmin and cashier can register customer and cashier and also edit product details, can view the details of customer and cashierIncludesInsert data to cashier details- first name, last name, username, password, email, contact numberInsert data into cashier details- first name, last name, location, location name, email, contact numberExtends_Special Requirements_Assumptions_Use case ID:001Use case Name:ProductCreated by:Dinithi DiasLast updated byDinithi DiasDate Created:13/05/2017Last Created by13/05/2017ActorsAdmin, CashierDescriptionAdmin can register product and also edit product details, can view seasonal items, product details, weekly report and also back up the databaseCashier can view the product details and generate the invoiceIncludesInsert data in product details- name, variety, color, quantity, price seasonExtendsBefore update need to register the productSpecial Requirements_Assumptions_5. D.2) Activity DiagramActivity diagrams are the diagrams which shows representations of the flow of one activity to another activity. Activity Diagram for Admin loginActivity Diagram for cashier LoginActivity Diagram for Product Activity Diagram for cashier Registration Activity Diagram for invoice 5. D. 3) Sequence DiagramSequence diagrams define as interactions between classes by passing messages overtime.Sequence Diagram for View Product Sequence diagram for update productSequence Diagram for Delete productSequence Diagram for search product Sequence Diagram for Add Product5. E) Graphical user interface designsMain formCashier login admin LoginCashier Dashboard Admin Dashboard Cashier DetailsCustomer Details Product details View ProductView weekly ReportView seasonal items View cashier Details View customer detailsView rented items Invoice form6) TestingThe main purpose of testing stage is to check whether the code works as expected. Black Box testing and White Box testing are used to test the code.6. A) Test plan6. B) Black Box TestingTest Case IDFunctionality TestProcedure for testingExpected outcomeB1Enables admin to login to the systemAllows to access the systemEnter user ID and Password.Click login buttonAfter the user enters an ID and Password to the system and retrieved when the user click loginB2Validate the availability of the login fieldsAllows to access the systemClick Login button without entering a user ID and PasswordA message box should display for the fields which credentials did not entered.The System will check the availability of the form fields during the login process.B3Validate the availability of the login fields for correct password and ID1) Allows to access the system2) Enter wrong user ID and Password.Click login buttonA message box should display for the fieldsThe System will check the availability of the form fields during the login process.B4Enables cashier to login to the systemAllows to access the systemEnter user ID and Password.Click login buttonAfter the user enters an ID and Password to the system and retrieved when the user click loginB5Validate the availability of the login fields of cashier formAllows to access the system Click Login button without entering a user ID and PasswordA message box should display for the fields which credentials did not entered.Database will check the availability of the form fields during login process.B6Validate the availability of the login fields for correct password and ID1) Allows to access the system2) Enter wrong user ID and Password.3) Click login button4) A message box should display for the fieldsThe system will check the availability of the form fields during the login process.B7Register cashier detailsAllows to register details about the employeeFill the credentials in the formClick Add buttonDisplay a message to show added successfullyAfter user fill the fields to the form and click add button, it stores in the database.B8Validating to check whether fields are empty or not.1) Allows to register details about the employee2) Click Add button without entering data in the fields3) Display a message for the fields which is not a field.Checks all the fields are filled to register.B9Validation to check whether first name is characters or numbers1) Allows to register details about employee first name2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B10Validation to check whether last name is characters or numbers1) Allows to register details about employee last name2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B11Validation to check whether user name is characters or numbers1) Allows to register details about employee user name2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B12Validation to check whether telephone number is characters or numbers1) Allows to register details about customer contact number2) Enter some characters values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its numbers not characters.B13Register customer detailsAllows to register details about employeeFill the credentials in the formClick Add buttonDisplay a message to show added successfullyAfter user fill the fields to the form and click add button, it stores in the database.B14Validating to check whether fields are empty or not.1) Allows to register details about employee2) Click Add button without entering data to the fields3) Display a message for fields which is not field.Checks all the fields are filled to register.B15Validation to check whether first name is characters or numbers1) Allows to register details about customer first name2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B16Validation to check whether last name is characters or numbers1) Allows to register details about customer last name2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B17Validation to check whether location is characters or numbers1) Allows to register details about location name2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B18Validation to check whether quantity is characters or numbers1) Allows to register details about quantity2) Enter some character values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B19Register product detailsAllows to register details about productFill the credentials in the formClick Add buttonDisplay a message to show added successfullyAfter user fill the fields to the form and click add button, it stores in the database.B20Validating to check whether fields are empty or not.1) Allows to register details about employee2) Click Add button without entering data to the fields3) Display a message for fields which is not field.Checks all the fields are filled to register.B21Validation to check whether product name is characters or numbers1) Allows to register details about product name2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B22Validation to check whether variety is characters or numbers1) Allows to register details about product variety2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check whether its characters not numbers.B23Validation to check whether Color is characters or numbers1) Allows to register details about product color2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B24Validation to check whether quantity is characters or numbers1) Allows to register details about product quantity.2) Enter some character values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its numbers not characters.B25Validation to check whether price is characters or numbers1) Allows to register details about product price2) Enter some character values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its numbers not character.B26Validation for search to check whether variety is characters or numbers1) Allows to search about product variety2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B27Validate the invoice formAllows to generate invoice.Fill the credentials in the formClick Add buttonDisplay a message to show added successfullyAfter user fill the fields to the form and click add button, it stores in the database.B28Validating to check whether fields are empty or not.1) Allows to register details about employee2) Click Add button without entering data to the fields3) Display a message for fields which is not field.Checks all the fields are filled to generate the invoice.B29Validation to check whether product name is characters or numbers1) Allows to generate the invoice2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its characters not numbers.B30Validation to check whether quantity is characters or numbers1) Allows to register details about product variety2) Enter some numerical values to the field.3) Click Add button.4) Display a perspective message to the field.Vb.net used to validate to check weather its numbers not characters.B31Update products details to the system by admin1) allows to access the product form2) Select the product variety which need to be update from the table in the form.3) fill the fields which need to change4)click update button5) A message will display to show it successfully updated.The required product variety data will be retrieve and update the databaseB32Update cashier details to the system by admin1) allows to access the cashier details form2) Select the cashier id which need to be update from the table in the form.3) fill the fields which need to change4)click update button5) Message will display to show it successfully updated.The required product variety data will be retrieve and update the databaseB33Update customer details to the system by admin1) allows to access the customer details form2) Select the customer details which need to be update from the table in the form.3) fill the fields which need to change4)click update button5) Message will display to show it successfully updated.The required product variety data will be retrieve and update the databaseB34Delete products details to the system by admin1) allows to access the product form2) Select the product variety which need to be delete from the table in the form.3) fill the fields which need to change4)click update button5) Message will display to show it successfully deleted.The required product variety data will be retrieve and delete from the databaseB35Delete customer details to the system by admin1) allows to access the customer form2) Select the customer Id which need to be delete from the table in the for
Recent Comments