A Project Report on BookToBook In partial fulfilment for the award of the degree Of BACHELOR OF ENGINEERING In INFORMATION TECHNOLOGY Submitted By Group ID: GIT_IT_18_39 Nisarg Patel (150120116064) Viren Panchal (150120116044) Himani Patel (160123116007) Guided By Mr. Akash Mehta Assistant Professor Information Technology Department GANDHINAGAR INSTITUTE OF TECHNOLOGY Moti-Bhoyan, Gandhinagar 2018-2019 Acknowledgement We have done this project but it is not possible without help of our internal guide. He guide us in right way and due to our affords we make this without any problems.
We are very thankful to Prof. Akash Mehta and his guidance for providing constant guidance to us. We take this opportunity to thank all my friends and colleagues who started me out on the topic and provided extremely useful review feedback and for their all-time support and help in each and every aspect of the course of my project preparation. We are grateful to my college Gandhinagar Institute of Technology, Gandhinagar for providing me all required resources and good working environment. We would like to express our gratitude towards Head of Department, Prof Rahul Vaghela and Director, Dr N M Bhatt for their kind co-operation and encouragement which helped us in this project. Nisarg Patel (150120116064) Viren Panchal (150120116044) Himani Patel (160123116007) Abstract BookToBook BookToBook is a Java Based E-comers website.
Book 2 Book shopping is the process where by consumers directly buy books in real-time, without an intermediary service, over the Internet . Here, consumers have different types of categories to buy a book like they can purchase new as well old book also. Another benefit for user is. They also can sell book in this website. Furthermore, one module called Donation will be used to help our society who need free book to read. This website can be open through mobile and computer.
PLATINUM FOUNDATION MANAGED GANDHINAGAR INSTITUTE OF TECHNOLOGY (Affiliated to Gujarat Technological University) Khatraj-Kalol Road, At: MotiBhoyan, Tal: Kalol, Dist: Gandhinagar Website: www.git.org.inCERTIFICATE This is to certify that the work of Industrial Defined Project entitled “BookToBook” has been carried out by Nisarg Patel Dilipbhai(150120116064) under my guidance in partial fulfilment for the degree of Bachelor of Engineering in Information Technology 7th Semester at the Department of Information Technology, Gandhinagar Institute of Technology, Moti-Bhoyan, Gandhinagar, Gujarat, during the academic year 2018-2019 and her work is satisfactory. This student has successfully completed all the activity under my guidance related to Industrial Defined Project for 7th semester. Internal Guide, Mr. Akash Mehta, Assistant Professor, Information Technology Department. Prof.
Rahul Vaghela, Head of Department, Information Technology, Gandhinagar Institute of Technology PLATINUM FOUNDATION MANAGED GANDHINAGAR INSTITUTE OF TECHNOLOGY (Affiliated to Gujarat Technological University) Khatraj-Kalol Road, At: MotiBhoyan, Tal: Kalol, Dist: Gandhinagar Website: www.git.org.inCERTIFICATE This is to certify that the work of Industrial Defined Project entitled “BookToBook” has been carried out by Viren Panchal Jitendrakumar (150120116044) under my guidance in partial fulfilment for the degree of Bachelor of Engineering in Information Technology 7th Semester at the Department of Information Technology, Gandhinagar Institute of Technology, Moti-Bhoyan, Gandhinagar, Gujarat, during the academic year 2018-2019 and his work is satisfactory. These students have successfully completed all the activity under my guidance related to Industrial Defined Project for 7th semester. Internal Guide, Mr. Akash Mehta, Assistant Professor, Information Technology Department. Prof.
Rahul Vaghela, Head of Department, Information Technology, Gandhinagar Institute of Technology PLATINUM FOUNDATION MANAGED GANDHINAGAR INSTITUTE OF TECHNOLOGY (Affiliated to Gujarat Technological University) Khatraj-Kalol Road, At: MotiBhoyan, Tal: Kalol, Dist: Gandhinagar Website: www.git.org.inCERTIFICATE This is to certify that the work of Industrial Defined Project entitled “BookToBook” has been carried out by Himani Patel Rajeshkumar(160123116007) under my guidance in partial fulfilment for the degree of Bachelor of Engineering in Information Technology 7th Semester at the Department of Information Technology, Gandhinagar Institute of Technology, Moti-Bhoyan, Gandhinagar, Gujarat, during the academic year 2018-2019 and his work is satisfactory. These students have successfully completed all the activity under my guidance related to Industrial Defined Project for 7th semester. Internal Guide, Mr. Akash Mehta, Assistant Professor, Information Technology Department.
Prof. Rahul Vaghela, Head of Department, Information Technology, Gandhinagar Institute of Technology GUJARAT TECHNOLOGICAL UNIVERSITY UNDERTAKING ABOUT ORIGINALITY OF WORK *Attach this certificate with Department/Guide /industry copy We hereby certify that we are the sole authors of this IDP project report and that neither any part of this IDP project report nor the whole of the IDP Project report has been submitted for a degree by other student(s) to any other University or Institution. We certify that, to the best of our knowledge, the current IDP Project report does not infringe upon anyone’s copyright nor violate any proprietary rights and that any ideas, techniques, quotations or any other material from the work of other people included in our IDP Project report, published or otherwise, are fully acknowledged in accordance with the standard referencing practices. Furthermore, to the extent that we have included copyrighted material that surpasses the boundary of fair dealing within the meaning of the Indian Copyright (Amendment) Act 2012, we certify that we have obtained a written permission from the copyright owner(s) to include such material(s) in the current IDP Project report and have included copies of such copyright clearances to our appendix. We have checked the write up of the present IDP Project report using anti-plagiarism database and it is in the allowable limit. In case of any complaints pertaining to plagiarism, we certify that we shall be solely responsible for the same and we understand that as per norms, University can even revoke BE degree conferred upon the student(s) submitting this IDP Project report, in case it is found to be plagiarized.
Team Id: 19980 Enrolment number Name Signature 150120116064 Nisarg Patel 150120116044 Viren Panchal 160123116007 Himani Patel 6142990-889000 Place: _______________________Date: _______________________ Name of Guide __________________________________ Signature of Guide _______________________________Contents Acknowledgement 1 Abstract 2 Certificate from College (As per suggested format) 3 Completion certificate generated from PMMS GTU portal 4 Plagiarism Certificate 5 Undertaking Form 6 Contents 7 List of Figures 8 List of Tables 9 Symbols And Abbreviations 10 Chapter 1 Introduction 1.1 Organization Profile 12 1.2 Project Detail 13 1.2.1 Project Profile 13 1.2.2 Project Definition 13 1.3 Purpose 14 1.4 Scope 14 1.5 Objective 14 1.6 Tools and Technology 15 1.7 Literature Review 15 Chapter 2 Design: Analysis, Design Methodology and Implementation Strategy 2.1 AEIOU Summary framework 15 2.2 Empathy Mapping Canvas 16 2.3 Ideation Canvas 18 2.4 Product Development Canvas 19 Chapter 3 About The System 3.1 System Requirement Specification 21 3.2 Feasibility Study 27 3.3 Project Planning 29 2.3.1 Project Development Approach 29 2.3.2 Project Plan 31 Chapter 4 Analysis 4.1 E-R Diagram 32 4.2 Data Flow Diagram 32 4.3 Use Case Diagram 35 4.4 Sequence Diagram 37 4.5 Activity Diagram 38 4.6 Class Diagram 39 Chapter 5 Design 5.1 System Flow Diagram 41 5.2 Data Dictionary 41 5.3 Relationship Of Table 47 Chapter 6 Conclusion ; Future Work 6.1 Conclusion 48 6.2 Future Work 48 References 48 List of Figures Figure Number Description Page Number Figure 3.1 Incremental model 30 Figure 3.2 Gantt Chart 31 Figure 4.1 E-R Diagram 32 Figure 4.2.1 DFD Level-0 32 Figure 4.2.2 DFD Level-1 33 Figure 4.3 Use Case Diagram 35 Figure 4.4.1 Sequence Diagram (Registration) 36 Figure 4.4.4 Sequence Diagram (User Login) 37 Figure 4.4.5 Sequence Diagram 37 Figure 4.5 Activity Diagram 38 Figure 4.6 Class Diagram 39 Figure 5.1 System Flow Diagram 40 Figure 5.3 Relationship of Table 47 List of Table Table Number Description Page Number Table 5.2.1 User Registration 42 Table 5.2.2 User Login 42 Table 5.2.3 Forget Password 43 Table 5.2.4 Book Upload 43 Table 5.2.5 Add to cart 44 Table 5.2.6 Order Details 44 Table 5.2.7 Payment 45 Table 5.2.8 Internet Banking 46 Table 5.2.9 COD 47 Table 5.2.10 More Setting 47 Table 5.2.11 Admin Loin 47 Symbols and Abbreviations Symbol Description OCR Optical Character Recognition SRS Software Requirement Specification ER Entity Relationship MTBF Mean Time Between Failures MTTR Mean Time to Repair DFD Data Flow Diagram Chapter-1 Introduction Project Detail Project Profile In present era, due to technology people do many thing easily and online just surfing a website. So many website is introduced to make life easier and therefore online purchasing book site developed. There are many website which are currently selling books, but we looking for new trend. There is no website who sell old book and many people looking for old book to read like in engineering, student have to read book for half year and then they have to purchase new book so we developed this site for mainly students.
Therefore, we decided to develop a website which would help people by saving time and low cost books. Project Definition Everyone is familiar to the word “Digital Technology”. The same we are going to apply in developing the application. In this website, people can buy old as well as old books.
In addition , they can also sell their books in this website also. One module for donating book to help our society. Purpose Currently, There are No website that providing old book to purchase so idea was simple to make e comers website that can help to buy new as well as old book and we can donate funds to help our society Scope The BookToBook website is supposed to have the following features: User can purchase books by different searching options. It utilizes GPS system to find user location as well as it can store user information on smart phone. User can give feedback.
User can add/delete contacts. User can edit the saved information. The system is completely automated so it reduces the human effort. Admin can add/delete contacts.
Admin can see the feedback. The features that are described in this document are used in the future phases of the software development cycle. The features described here meet the needs of all the users. The success criteria for the system are based in the level up to which the features described in this document are implemented in the system.
Objective To provide users to purchase book online. To add/delete user, manage their accounts. To reduce user ‘s searching time. To provide great discount over purchasing. To provide wide collection of book ranges.
To provide user friendly environment. To provide facility of user feedback. Tools & Technology we are developing a website in Java, we will be using Java technology along with Android and required database. Java Android applications are written in a well-respected programming language: Java. Java is a general-purpose computer programming language that is concurrent, class-based and object-oriented. Java code can run on all platforms that support Java without the need for recompilation.
ANDROID Android is an open source & license free mobile operating system developed by Google, based on the Linux kernel and designed primarily for touchscreen mobile devices such as smartphones and tablets. Android’s open nature has encouraged a large number of developers to develop smart applications .Everyday millions of developers searches for android java code ; fixes the errors .Survey says that Android’s graphical user interface is more effective & modern than other Platforms. Neither developers nor mobile phones manufacturers pay royalties or license fees to develop for the platform. Literature Review BookToBook It is a digital book purchasing website It is providing different types of purchasing and selling options. People can directly search books by its ISBN number, book name and author name. User can payment in various ways like card payment, paytm etc.
User can selling book with higher cashback. Chapter-2 Design: Analysis, Design Methodology and Implementation Strategy AEIOU Summary Canvas Activities Registration: firstly user is going to register to use this website. Searching: People can search different types of books to purchase. Filter: user can also apply filter to search books according to their requirements. AddToCart: if users want to purchase product then they will save items in their cart.
Payment: Users payment to website if they want to buy product. Cancelation: if user change his/her mind to cancel then this is done by her/him. Feedback: After purchasing any product if they want to give feedback then can give it. Environment Internet: If user want to use this website then first then need proper internet because it is purely based on online. Laptops/Smartphones: This is used to use this website.
Interactions BookStores Charity Organizations Real Users Objects Smart Phone Internet GPS servers Users Company: To enhance their business by selling book in this web. Students: To search for books in various categories. visitors: this types of user just visiting this site for getting knowledge. Sales Man: They use this website to sell books. Admin: he/she observe users, companies and their sell during time-periods. Scanned Copy of AEIOU Summary Canvas Empathy Mapping Canvas User Company: To enhance their business by selling book in this web.
Students: To search for books in various categories. visitors: this types of user just visiting this site for getting knowledge. Sales Man: They use this website to sell books. Admin: he/she observe users, companies and their sell during time-periods.
Stakeholders Admin: To handle all the management and updating tasks. Users: To request for different operation on the application. Companies: Providing books to sell in this website Activities Registration: firstly user is going to register to use this website. Searching: People can search different types of books to purchase. Filter: user can also apply filter to search books according to their requirements. AddToCart: if users want to purchase product then they will save items in their cart.
Payment: Users payment to website if they want to buy product. Cancelation: if user change his/her mind to cancel then this is done by her/him. Feedback: After purchasing any product if they want to give feedback then can give it. Story Boarding Happy: My name is baron carpin. I have to tell something about online book purchasing. Around one year ago, I had a research up on a particular topic of science.
So I want to gain depth knowledge of it. But I can’t get any book related to it near my house. So went to online purchasing and luckily I get many book for my research and I purchase it. Sad: My name is Elizabeth lewis. I had a bad experience of online shopping because they delivered me wrong product so I apply for return and I also fill return policy form to get refund. After doing this process.
Still I get my refund after around 28 days. Scanned copy of Empathy mapping canvas Ideation Canvas People Company: To enhance their business by selling book in this web. Students: To search for books in various categories. visitors: this types of user just visiting this site for getting knowledge.
Sales Man: They use this website to sell books. Admin: he/she observe users, companies and their sell during time-periods. Activity Registration: firstly user is going to register to use this website. Searching: People can search different types of books to purchase. Filter: user can also apply filter to search books according to their requirements. AddToCart: if users want to purchase product then they will save items in their cart.
Payment: Users payment to website if they want to buy product. Cancelation: if user change his/her mind to cancel then this is done by her/him. Feedback: After purchasing any product if they want to give feedback then can give it. Location/Situation/Context Purchasing Books Selling Books Charity Payment Donation Props/Possible Solutions Purchase old book/new book Sell old book Get notification On new arrivals Donation Scanned Copy of Ideation Canvas Product Development Canvas Purpose Varity of book availabilities charity Time Saving People Company: To enhance their business by selling book in this web.
Students: To search for books in various categories. visitors: this types of user just visiting this site for getting knowledge. Sales Man: They use this website to sell books. Admin: he/she observe users, companies and their sell during time-periods. Product Experience Easy to use Less Time Consuming More Searching option Product Features Purchase book Gateway Payment Search Security Components Old books New books Debit card/credit card Google Account One time Password Scanned Copy of Product Development Canvas Chapter-3 About The System Software Requirement Specification (SRS)IntroductionIn present era, due to technology people do many thing easily and online just surfing a website.
So many website is introduced to make life easier and therefore online purchasing book site developed. There are many website which are currently selling books, but we looking for new trend. There is no website who sell old book and many people looking for old book to read like in engineering, student have to read book for half year and then they have to purchase new book so we developed this site for mainly students. Therefore, we decided to develop a website which would help people by saving time and low cost books. PurposeThe purpose of Software Requirements Specification (SRS) document is to describe the external behavior of the BookToBook.
Requirements Specification defines and describes the operations, interfaces, performance, and quality assurance requirements of the Business Card Reader Application. The document also describes the nonfunctional requirements such as the user interfaces. It also describes the design constraints that are to be considered when the system is to be designed, and other factors necessary to provide a complete and comprehensive description of the requirements for the software. The Software Requirements Specification (SRS) captures the complete software requirements for the system, or a portion of the system. Requirements described in this document are derived from the Vision Document prepared for the BookToBook. ScopeThe Software Requirements Specification captures all the requirements in a single document.
The BookToBook that is to be developed provides the users with many facilities. The BookToBook is supposed to have the following features: The system provides logon facility to the users. One time registration is required when the application is installed. The system provides the members with the option to edit their account and/or change their options like password of the account whenever needed. User can purchase books by different searching options. Users can sell their old books in this website.
Different payment option available in this like card payment, paytm etc. User can provide feedback as required. Definitions, Acronyms and AbbreviationsCPU – Central processing Unit PIN – Personal Identification Number IDE – Integrated Development Environment JAVA – Java is a general-purpose Object Oriented Programming language developed by James Gosling at Sun Microsystems. OS – Operating System GUI – Graphical User InterfaceOverviewThe SRS will provide a detailed description of the BCR-Business Card Reader. This document will provide the outline of the requirements, overview of the characteristics and constraints of the system.Overall DescriptionProduct Perspective BookToBook website is providing good features to user like purchase and sell books. The application provides easy navigation and less time consuming .
Product Functions The application provides the purchasing products. The Product functions are more or less the same as described in the product perspective. The functions of the system providing different type of services are: It extracts all information of book like as Name, author name, ISBN No, product description , and many more. The users are provided with different categories list which allows them to choose product easily. The users are provided with interfaces to add/delete the book.
The users can donate books in this website to help society. User characteristics The users of the system are Admin department who manages the system. The users that include students, Employees, company, Salesperson, etc. The administrators of the system to have more knowledge of the internals of the system and is able to rectify the small problems that may arise during purchasing process and other catastrophes to maintain the system.
The proper user interface, user manual, online help and the guide to install and maintain the system must be sufficient to educate the users on how to use the system without any problems. Constraints The information of all contacts must be stored in the contact list. The users access the Application from any Android Phone that has the camera with high resolution for capturing the image. The Phones must be compatible to the application as it uses the OCR technology for scanning. Assumptions and dependencies The users have sufficient knowledge of Android Phones and computers.
The technology should be such that it does not harm the phone. The users know the English language, as the user interface will be provided in English.Specific RequirementsThis section describes in detail all the functional requirements.FunctionalityLogon CapabilitiesThe system shall provide the users with logon capabilities.Mobile DevicesThis wensite is supported on mobile devices such as cell phones and computers.AlertsThe system can alert the User or the administrator in case of any problems.Usability This website shall allow the users to access the system from any device. Since all users are familiar with the general usage of Android Phones and computers, no specific training is required.Reliability The system has to be very reliable due to the importance of data and the damages incorrect or incomplete data can do.AvailabilityThe system is available 100% for the user and is used 24 hours a day and 365 days a year. The system shall be operational 24 hours a day and 7 days a week.Mean Time Between Failures (MTBF)The system will be developed in such a way that it may fail once in a year. Mean Time to Repair (MTTR)Even if the system fails, the system will be recovered back up within an hour or less. AccuracyThe accuracy of the application is limited by the accuracy of the speed.
Maximum Bugs or Defect Rate. Not specified. Access ReliabilityThe system shall provide 100% access reliability. PerformanceResponse TimeThis website will be accessed in less than a minute.
The system shall respond to the user in not less than two seconds from the time of the request submittal with is sufficient and adequate enough for user. The system shall be allowed to take more time when doing large processing jobs. AdministratorThe system shall take as less time as possible to provide service to the administrator. ThroughputThe number of times application installed is directly dependent on the number of users, the users may be students, Employees, company. CapacityThe system is capable of handling thousands of users at a time. Resource UtilizationThe resources are modified according to the user requirements.SupportabilityThe system designers shall take in to considerations the following supportability and technical limitations.
Internet ProtocolsThe system shall be comply with the TCP/IP protocol standards and shall be designed accordingly. Information Security RequirementThe system shall support the standard security rules so that no harm can be done to the application. MaintenanceThe maintenance of the system shall be done as per the maintenance contract. StandardsThe coding standards and naming conventions will be as per the American standards.Design ConstraintsSoftware Language UsedThe languages that shall be used for developing the website is JAVA.
Development ToolsWill make use of the available Java Development Tool Kit (JDK) and Software Development Tool Kit (SDK) . Class LibrariesWill make use of the existing Java libraries available for website and we will develop other programs as needed. On-line User Documentation and Help System RequirementsOnline help is provided for each of the feature available with the BookToBook. All the website provide an on-line help system to assist the user. The nature of these systems is unique to website development as they combine aspects of programming (hyperlinks, etc.) with aspects of technical writing (organization, presentation).
Online help is provided for each and every feature provided by the system. The User Manual describes the use of the system to all our users on mobile systems and desktops. The user manual should be available as a hard copy and also as online help. Purchased ComponentsThe System Administrator will need to purchase the storage to handle products and user information InterfacesUser InterfacesThe user interface for the website shall be compatible with the Android Phones and desktops which a user can access easily. Hardware InterfacesThis is an website and will be designed to interface with the hardware present in the Android Phones and desktops. Software InterfacesThe website will connect remotely to a SQLite database.
A software framework will be utilized for use of buttons and other functions to be carried out in the website. Communications InterfacesBeing an website, it will communicate with the Database to keep the application updated. Licensing RequirementsNot applicable Legal, Copyright, and Other NoticesThe website will display the necessary copyright issues and disclaimers. Applicable StandardsIt will be according to the industry standard.Supporting InformationRefer the following documents for more support: Use Case Diagram, Project Plan, Structural and Behavioral Diagrams Feasibility Study A feasibility study determines whether the proposed solution is feasible based on the priorities of requirements of the organization. The study begins by classifying the definition.
It helps you to evaluate the cost-effectiveness of the system. During this phase, various solutions to the existing problems were examined. A system that passes the feasibility tests is considered a feasible system. The systems analyst needs to decide whether it is possible to solve the problem, using a system known as “TELOS”. T – Technical: Is the project technically possible? E – Economic: Can the project be afforded? Will it increase profit? L – Legal: Is the project legal? O – Operational: How will the current operations support the change? S – Scheduling: Can the project be done in time? Technical Feasibility Technical feasibility is a study of function, performance and constraints that may affect the ability to achieve an acceptable system. During technical analysis, the analyst evaluates the technical merits of the system along with performance, reliability, maintainability and productivity.
It is frequently the most difficult area to access. Technology Required: We will be using Android Technology for developing our application. Assessing System Performance: It involves ensuring that the system responds to the user queries and is efficient, reliable, accurate and easy to use. It satisfies the performance requirement with 512 GB RAM. Economic Feasibility The concept of economic feasibility deals with the fact that a system that can be developed and will be used on installation must be profitable for the organization. For declaring the system economically feasible, the benefits from the project should exceed or at least equal to the cost of development.
Cost-Benefit Analysis: The objective is to find out whether it is economically worthwhile to invest in the project. If the returns on investment are good, then the project is considered economically worthwhile. Legal Feasibility It determines whether the proposed system conflicts with legal requirements. The objective is to ensure that the project is legally doable, to facilitate risk management indicating the risks and obstacles that need to be addressed within the technical analysis and to avoid major problems in the project’s development and implementation.
Operational Feasibility Operational Feasibility is a measure of how people feel about the system. It is dependent upon determining human resources for the project. If the system is well liked and comfortable to the users and they see no problem with its continuance, then resistance to its operation will be zero. Our project is operationally feasible since there is no need for special training of staff member and whatever little instructions are required can be done easily. This project is being developed keeping in mind the common people who have little knowledge about the computer operation but can access the application easily. Schedule Feasibility Schedule feasibility is a measure of how a project is to be completed within its scheduled time limits.
It means estimating how long the system will take to develop, and if it can be completed in a given time period or not. Factors considered: Schedule of the project. Time by which project has to be completed. Reporting period.
Project Planning Project Development Approach We have used the Incremental Model approach for the Project Development. Fig.3.1 Incremental Model In Incremental model the Project requirements are divided into multiple modules and each module is developed separately. Finally developed modules are integrated with other modules. As each module is standalone application and there is no dependencies on other modules so we can deliver the project with initial developed feature and other features could be added on incremental basis with new releases. Incremental process goes until all the requirements fulfilled and whole system gets developed. Incremental Model helps to deliver the sequence of releases in incremental basis which speeds up the progress of development of each functionality.
Each developed functionality gets delivered to the end users one after another. First increment is always a base feature and other features added in next increments with new releases in case client requests to add the any new feature after review of first release. This process is carried out till the complete product is developed. Project Timeline A timeline is a way of displaying a list of events in chronological order, sometimes described as a project Artifact.
It is typically a graphic design showing a long bar labeled with dates alongside itself and usually events labeled on points where they would have happened. Figure 3.2 Gantt chart Chapter-4 Analysis E-R Diagram Figure 4. STYLEREF 3 s iv. SEQ Figure * ARABIC s 3 1 E-R Diagram Data Flow Diagram Figure 4.2. STYLEREF 3 s iv.
SEQ Figure * ARABIC s 3 2 DFD Level 0 Use Case Diagram Figure 4.3 Use Case Diagram Figure 4.3.1 Use Case Diagram 54345325336500Sequence Diagram Figure 4.4.1 Sequence Diagram (Registration) 670560254000Figure 4.4.2 Sequence Diagram (User Login) Figure 4.4.3 Sequence Diagram Activity Diagram Figure 4.5 Activity Diagram Class Diagram Figure 4.6 Class Diagram Chapter-5 Design System Flow Diagram Figure 5.1 System Flow Diagram Data Dictionary Name of Table: USER ( Registration ) Description of table: Sr. No Column name Data Type Size Constraints Description 1 USER_ID Varchar 20 Primary Key Define Unique identity of the user 2 FIRST_NAME Varchar 20 First name of the user 3 MIDDLE_NAME Varchar 20 Middle name of the user 4 LAST_NAME Varchar 20 Define the last name of the user 5 GENDER Varchar 6 Define the gender 6 ADDRESS Varchar 50 Define the address of the use 7 CITY Varchar 20 Define the city 8 STATE Varchar 20 Define the state 9 COUNTRY Varchar 20 Define the country 10 ZIPCODE Varchar 10 Zipcode of the user address 11 EMAIL_ID 50 Define the Email of the user 12 MOBILE NO. Integer 10 Define the mobile no of user 13 PASSWORD Varchar 20 Define the password 14 CONFORM PASSWORD Varchar 20 Define the conform password 15 DATE OF BIRTH Integer 8 Define the birth day of the user Name of Table: USER ( Login ) Description of table: Sr. No Column name Data Type Size Constraints Description 1 EMAIL_ID / PHONE_NO Varchar 50 Private Key Email id or mobile no. 2 PASSWORD Varchar 20 Password of the user Name of Table: USER ( Forget Password ) Description of table: Sr.
No Column name Data Type Size Constraints Description 1 EMAIL_ID/PHONE NO Varchar 50 Private Key Email id or Mobile no of the user who already register 2 OTP Integer 6 OTP which Get by user 3 NEW_PASSWORD Varchar 20 Create a new Password of the user 4 CONFORM_PASSWORD Varchar 20 Conform the password Name of Table: BOOK UPLOAD( User / Company ) Description of table: Sr. No Column name Data Type Size Constraints Description 1 ISBN_NO Varchar 15 Private key ISBN number of the book 2 BOOK_NAME Varchar 20 Name of the book 3 AUTHOR_NAME Varchar 20 Name of the Author 4 PUBLICATION Varchar 20 Publication of the book 5 EDITION Integer 8 Edition year of the book 6 BOOK_IMAGE Integer Image of the book 7 DESCRIPTION Integer 1500* Description of the book 8 ABOUT_AUTHOR Integer 1500* Information about the book author 9 PRICE Integer 8 Price of the book 10 NEW_BOOK Name of the new book 11 BOOK_TYPE 50 Type of the book Name of Table: BOOK ( Add to Cart ) Description of table: Sr. No Column name Data Type Size Constraints Description 1 BOOK_ID integer 15 Private key Define the unique id of the book 2 BOOK_NAME Varchar 20 Name of the book 3 PRICE integer 8 Amount of the book 4 QUANTITY integer 8 Number of quantity of the book Name of Table: Order-Details Description of table: Sr. No Column name Data Type Size Constraints Description 1 ORDER_NO integer 20 Private Key Define the number of the order 2 BOOK_ID Integer 20 Foreign Key Define the unique id of the book 3 QUANTITY Integer 18 quantity of the book 4 PRICE Integer 8 Amount of the book 5 TOTAL_AMOUNT Integer 8 Total Amount of the book 6 ADDRESS Varchar 50 Address of the user who order the book 7 CITY Varchar 20 City of the user 8 ZIPCODE Integer 10 Zipcode of the user 9 STATE Integer 20 State of the User Name of Table: Payment Description of table: Sr.
No Column name Data Type Size Constraints Description 1 DEBITCARD/CREDITCARD_NO Integer 20 Number of the Credit card or Debit card 2 CARD_HOLDER_NAME Varchar 20 Name of the card holder 3 CARD_TYPE Varchar 10 Type of the card 4 CVV_NO Integer 3 CVV number of the Credit card or debit card 5 EXPIRY_DATE Date 4 Expiry date of the Credit card or debit card 6 PIN_NO / UPI_NO Integer 8 Pib or UPI number of card 7 OTP Integer 4 OTP number which received by holder Name of Table: Internet Banking Description of table: Sr. No Column name Data Type Size Constraints Description 1 USER_ID integer 20 Private key Define unique id of the user 2 PASSWORD Varchar 20 Password of the user Name of Table: COD Description of table: Sr. No Column name Data Type Size Constraints Description 1 USER_NAME Varchar 20 Define name of the user 2 MOBILE_NO Integer 10 Mobile number of the user 3 EMAIL_ID Varchar 20 Email address of the user 4 ADDRESS Varchar 50 Address of the user 5 STATE Varchar 20 Define state of the User 6 CITY Varchar 20 Define city of the user 7 PINCODE Integer 10 Pin number of the user address 8 COUNTRY Varchar 20 Country name of he user 9 ALTERNET_MOBILE_NO Integer 10 Another mobile number of the use Name of Table: Cash On Delivery Description of table: Sr. No Column name Data Type Size Constraints Description 1 ORDER_NO Integer / Varchar 20 Define the number of the Order 2 USER_NO Varchar 20 Define the number of the user 3 ADDRESS Varchar 50 Address of the User 4 CITY Varchar 20 City of the user 5 STATE Varchar 20 Define the state of the user 6 ZIP_CODE Integer 10 Zipcode of the User 7 COUNTRY Varchar 20 Define the name of country 8 EMAIL_ID Varchar 20 Name of the email of user 9 AMOUNT Integer 8 Amount of the user 10 TRANSACTION_ID Integer 8 Define the unique Transaction id 11 ORDER_NAME Varchar 20 Define the name of the order 12 QUANTITY Integer 8 Quantity of the order 13 ORDER_DATE Date 4 Define the date of the order Name of Table: More Setting Description of table: Sr. No Column name Data Type Size Constraints Description 1 PROFILE_IMAGE Varchar 20 Define the image of the profile 2 DISPLAY_NAME Varchar 20 Display the name 3 EMAIL_ID Varchar 20 Define the email id 4 MOBILE_NO Integer 10 Define the mobile number of the user Name of Table: Admin Login Description of table: Sr. No Column name Data Type Size Constraints Description 1 ADMIN_ID Varchar 50 NOT_NULL Define the id of the Admin 2 PASSWORD Varchar 20 NOT_NULL Password of the admin 3 EMAIL_ID Varchar 50 Email address of the admin Name of Table: Admin Registration Description of table: Sr.
No Column name Data Type Size Constraints Description 1 QUALIFICATION_DETAIL Varchar 150 Describe the qualification of the order Relationship of Table Figure 5.3 Relationship of Table Chapter-6 Conclusion & Futurework Conclusion In this span of time, we have learned many new technology and gained wide knowledge. It helped us to manage time, maintain good team spirit and even having the positive on our behavior. To conclude, this project was a great experience for us. We are thankful to our guides and colleagues for helping us in every moment as this would have not been possible without their support. Future Work During this implementation period, we concentrated on the process of purchasing and conversion along with development of website.
In future, we will try to revert back the process by providing the functionality of selling book through the application. Along with this, we will try to build the application as efficient and useful as possible. References http://www.aui.ma/sse-capstone-repository/pdf/The%20Optical%20Capture%20Recognition.pdfhttps://www.ijarcsse.com/docs/papers/Volume_3/7_July2013/V3I7-0414.pdf https://www.google.co.in/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=flipkarthttps://patents.google.com/patent/US5683243A/en?q=custimhttps://www.teamviewer.com/
