sNDIRA GANDHI NATIONAL OPEN UNIVERS ITy MCSP — 232 ONLINE BOOK SHOP MANAGEMENT SYSTEM by Chandrakala gusain Enrolment No: 2354010179 Under Guidance Submitted to the School of Computer and Information sciences, IGNOU in partial fulfilment of the requirements For the award of the degree MASTER OF COMPUTER APPLICATIONS (MCA) 2025 Indira Gandhi National Open University Maidan Garhi New Delhi — 110068.SYNOPSISCONTENTS NUMBER TOPIC PAGE NO. 1 TITLE OF THE SYNOPSIS. 1 2 INTRODUCTION AND OBJECTIVES. 2 3 PROJECT CATEGORY, TOOLS/PLATFORM, 3-5 4 ‘SYSTEM ANALYSIS 6-16 -Preliminary Investigation Feasibility Study -Problem definition SRS -Project Planning & Scheduling DEDs at least up to school level, ER Diagrams etc. as per the project requirements 5 Acomplete structure which includes: 17-22 - Number of modules and their description to provide an estimate of the student’s effort on the project. - Data structure as per the project requirements for all the modules. - Testing/Reports, Security Mechanism 6 Limitation of the Project 23 7 Future scope of the Project 23 8 Bibliography 24TITLE OF THE PROJECT ONLINE BOOK SHOP MANAGEMENT SYSTEMINTRODUCTION An Online Book Shop that allows users to check for various book Products available at the online store and purchase online. Online Book Shop is being developed with the help of programming language HTML, CSS, JAVA SCRIPT, PHP and “MYSQL.” The PHP is being used as Back-end and MYSQL as the Database. The project consists of list of book products displayed in various Categories. The user may browse through these items as per Categories. > User register and order the book. > Admin display the order and add new books. OBJECTIVES OF THE PROJECT The online book shop management system will be computerized so that it has less paper work to do and it will save both the money and the time. It will also reveal book to the outside environment. > To enable customers to order book. > To enable customers to have a visual confirmation that the order was placed correctly > Improve efficiency > Eliminate paper work and increase level of accuracy > Increase speed of service, sales, volume and customer satisfaction.Project Category FRONT END: What is HTML? HTML is a language for describing web pages. > HTML stands for Hyper Text Markup Language > HTMLis not a programming language, it is a markup language > Amarkup language is a set of markup tags > HTML uses markup tags to describe web pages Cascading Style Sheet (CSS) CSS is just a way of formatting the web page layout, text, fonts, images and almost everything you put on the web page. Java Script JavaScript is a scripting language developed by Netscape Communications Corporation. It is simple to learn, easy to use, general purpose scripting language. JavaScript is commonly used in web pages to improve the design, validate forms, detect browsers, create cookies, and much more which helps in making the web pages interactive and powerful. JavaScript is supported by all the major browsers such as Internet Explorer, Mozilla etc. Function display() { Alert(“Welcome”) }BACK-END: What is PHP? PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. It is among one of the first developed server-side scripting languages that is embedded into a HTML source document, rather than calling an external file to process data. Ultimately, the code is interpreted by a web server with a PHP processor module which generates the resulting web page. It also has evolved to include a command-line interface capability and can be used in standalone graphical applications. PHP can be deployed on most web servers and asa standalone shell on almost every operating system. PHP was originally created by Rasmus Lerdorf in1995. The main implementation of PHP is now produced by The PHP Group and serves as the formal reference to the PHP language. PHP is free software released under the PHP License. While PHP originally stood for “Personal Home Page”, it is now said to stand for “PHP: Hypertext Preprocessor”. Basic PHP Syntax PHP code is executed on the server, and the plain HTML result is sent to the browser. A PHP scripting block can be placed anywhere in the document. It always starts with . echo “Welcome”; >  MySQL The MySQL Database powers the most demanding Web, E- commerce and Online Transaction Processing (OTLP) applications. It is a fully integrated transaction-safe, ACID compliant database with full commit, rollback, crash recovery and row level locking capabilities. MySQL delivers the ease of use, scalability, and performance that has made MySQL the world’s most popular open- source database. Some of the world’s most trafficked websites like Facebook, Google, ticketmaster, and eBay rely on MySQL for their business-critical applications. TOOLS/PLATFORM USED HARDWARE SPECIFICATION PROCESSOR : 64 BIT, Core i3 RAM : 4GB HARD DISK : 500 GB MONITOR : SVGA Monitor (1366*768 RESOLUTION) SOFTWARE SPECIFICATION OPERATING SYSTEM —: Windows 2007 FRONT END : HTML, CSS, JAVA SCRIPT LANGUAGE DATABASE : MySQL SERVER : WAMP-SERVER IDE : VS CODESYSTEM ANALYSIS The first step in the system development life cycle is the preliminary investigation to determine the feasibility of the System. The purpose of the preliminary investigation is to evaluate project requests. It is neither a design study nor does it include the collection of details top describe the business system in all respect. Rather, it is collecting of information that helps committee members to evaluate the merits of the project request and make an informed judgement about the feasibility of the proposed project. FEASIBILITY Study This is an evaluation and analysis of the potential of the proposed project which is based on extensive investigation and research to support the process of decision making. It assesses the operational, technical, and economic merits of the proposed project. The fea study is intended to be a preliminary review of the facts to see if it is worthy of proceeding to the analysis phase. From the systems analyst perspective, the feasibility analysis is the primary tool for recommending whether to proceed to the next phase or to discontinue the project. Technical Feasibility This assessment is focused on gaining an understanding of the present technical resources of the organization and their applicability to the expected needs of the proposed system. It is an evaluation of the hardware and software and how it meets the needs of the Proposed system. The systems project is considered technically feasible if the internal technical capability is sufficient to support the project requirements.Operational fea: y Operational Feasibility is the measure of how well the project will support the customer and the service provider during the operational phase. It is dependent on human resources available for the project and involves projecting whether the system will be used if it is developed and implemented. Economic feasibility This assessment aims to determine the positive economic benefits to the organization that the proposed system will provide. It typically involves a cost/ benefits analysis and it’s the most frequent used method for evaluating the effectiveness of a new proposed system. Possible questions raised in economic analysis are: Is the system cost effective? Do benefits outweigh costs? The cost of doing full system study The cost of business employee time Estimated cost of hardware Estimated cost of the software/software development VUVUbY Problem Definition The system will be designed to be user friendly. The user friendly and interactive interface design helps to achieve this by enabling customers to easily browse the menus place order with just a few clicks. The system will be simple to use.SOFTWARE REQUIREMENTS SPECIFICATION SRS is software requirement specification it contains the s/w requirement details like what is front-end technology, backend technology, OS and hardware architecture of the project. SRS stands for Software Requirement Specification. It establishes the basis for agreement between customers and contractors or suppliers on what the software products is expected to do, as well as what it is not expected to do. Some of the features of SRS are- > Itsets permits a rigorous assessment of the requirements before design can begin. > It sets the basis for software design, test, deployment, training etc. It also sets pre-requisite for a good design though it is not enough. > It sets basis for software enhancement and maintenance. ‘> It sets Basis for Project plans like Scheduling and Estimation. Thus, SRS should be consistent, correct, unambiguous & complete, document. The developer of the system can prepare SRS after detailed communication with the customer. An SRS clearly defines the following: > External Interfaces of the System: They identify the information which is to flow ‘from and to’ to the system. > Functional and non-functional requirement of the system: They stand for the finding of run time requirement.There are following step wise stage of SDLC and water fall model with feedback: - Here in our project, we use Waterfall Model to develop this project. It is also known as classic life cycle or linear sequential model. Sometimes it is also treated as software development life cycle (SDLC). Feasibility Study Requirement Analysis MaintenancePROJECT PLANNING: - The project planning objective is achieved through a process of information discovery that leads to reasonable estimates. Before the project can begin, the manager and software team must estimate the work to be done. A manager must decide what objectives are to be achieved, hat resources are required to achieve the objectives how and when resources are to be achieved and how the goals are to be achieved. Thus, project planning for any company has the following four main steps: - 1. Organizing the resources available for the project. 2. Scheduling the events of the project. 3. Evaluating the process. 4. Establishing standards for the project. An effective manager is essential for successful project planning. The techniques of the project are not a substitute for good management, but merely a tool to be used by managers to achieve better results. Only effective management can complete the project on time, within budget, and with satisfactory results. Project Scheduling: Software project scheduling is an activity that distributes estimates efforts across the planned project duration by allocating the effort to specific software engineering tasks. Scheduling of a project can be correlated to prioritizing various tasks with respect to their cost, time and duration. In project management, a schedule consists of a list of a project's terminal elements with intended start and finish dates. Terminal elements are the lowest element in a schedule, which is not further subdivided.Those items are often estimated in terms of resources requirements, budget, and duration, linked by dependencies, and scheduled. > Work Breakdown Structure: - The project is scheduled in various phases following a bottom-up or top-down approach. A tree-like structure is followed without any loops. At each phase or step, milestone and deliverables are mentioned with respect to requirements. The work breakdown structure shows the overall breakup flow of the project and does not indicate any parallel flow. Software Project Analysis The project is split into requirement and analysis, design, coding, testing and maintenance phase. Further, requirement and analysis is divided into R1,R2 .....Rn; design is divided into D1,D2,D3, ...,Dn; coding is divided into C1,C2..Cn; testing is divided into T1,12.. Tn; and maintenance is divided into M1,M2.. Mn. If the project is complex, then further sub-division is done. Upon the completion of each stage, integration is done.DATA FLOW DIAGRAMS Context level DFD Customer r Administrator yo / Register or send Order Add products and “Confirm order Online Book Shop Management System Generates the entire processes report . | Database ReportFirst Level DFD Customer -——— Customer Modul Info about oaue Customer 3.0 1.0 Customer Send Order — Admin Login Generate Report Report Module ~~*| Product Details ‘ Registration Details x Order & View Bill3.0 | — Cust Login Customer Customer Module ] | 1 ZA Register Register Details 1.3.1 View Product 1.3 Product Details [1.3.2 Add Cart __,J1-4.1 Send order details 1.4.2 View order detailsSecond Level DFD for Admin Module Admin 2.1 _,| Admin Login Admin Login Module * _,| Products 2.2 Add Product 4 Register Delete 2.3.2 Update Registration Image 23 View Registration Order Delete Order 2.5 _ Print Billjer_detailsNUMBER OF MODULE User Module VU User Registration User Login Display products See book collection Add cart Send order Add contacts Admin Login VUUVUYUY Add products View Registration Update Registration View Order Update Order Delete order View and Print BillDATABASE TABLE Admin Login attribute Type Size | Constraints User_name | Varchar 15 | Primary Key password Varchar 15 | Not Null User Login attribute Type Size Constraints User_name | Varchar 15 | Primary Key password Varchar 15 | Not Null Register attribute Type Size Constraints Id Int 6 Primary Key Fname Varchar 5 Not Null Lname Varchar 50 Not Null Email Varchar 50 Not Null Mobile Varchar 10 Not Null User_name | Varchar 20 Not Null password __| Varchar 20 Not NullProducts attribute Type Size Constraints Id Int 6 Primary Key Title Varchar 20 Not Null Auth_name | Varchar 50 Not Null Publication | Number 10 Not Null Description | Varchar 20 Not Null Price Number 10 Not Null Image Varchar 20 Not Null Orders_details attribute Type Size Constraints Id Int 6 Primary Key Title Varchar 20 Not Null Name Varchar 50 Not Null Price Number 10 Not Null C_name Varchar 20 Not Null Address Varchar 10 Not Null Mobile Number 20 Not Null Date_time | Date Not NullTESTING Testing is a process of executing a program with the intent of finding an error. > Agood test case is one that has high profitability of an as-yet- undiscovered error. > Asuccessful test is one that uncovers an as-yet-undiscovered error. > Testing presents an interesting anomaly for the software engineers. Unit Testing: - It is normally performed on individual module. As each module of the proposed system has been developed, the modules are being tested. Integration Testing: - It is performed after unit testing. Integration testing is a systematic technique for constructing the program structure while conducting tests to uncover errors associated with interfacing. Installation Testing: - When acceptance test was completed, the acceptance system was installed in the environment in which it would be med and a final installation test was performed to make sure that the system function as it should. Black box testing — external testing of test cases. White box testing—internal testing of test cases REPORT GENERATION > Book Report > Registration Report > Order report > Bill ReportsSYSTEM SECURITY MEASURES To provide better security, we had developed an automated Services System of Online Book shop Management System. All information and management forms are stored within the system, and access to his sensitive information is controlled through an intricate password system: one must know the user id, password to gain access to any of the information. In this system, we had supplied user id & pwd. Distinguish between management and other employee is management (administrator) can create new user, while user cannot. | provide the facility to change the password according to the user need. For security measure | have taken ‘password’ as ‘Varchar’ data type, so that a user can use in this field both integer and alphabet. To do an adequate job on security, a system analyst must analyze the risk, exposure, and costs and specify measures such as passwords and encryption to provide protection. The backup copies of software and recovery restart procedures must be available when needed.LIMITATIONS > All the softwares are not easily available. > Project run only windows platform. > Limited time period. FUTURE SCOPE & FURTHER ENHANCEMENT OF THE PROJECT At present the system satisfy most of the function of Online Book Shop Management System. The project uses very nearly the same as any online book shop management System. > We can add other modules without affecting the current modules. > We can add SMS Facility. > A mail server can be implemented to send mails directly from the system to the inbox of the recipient. The code needed for the same is being implemented except the mail server. > Help file can be included. The system, as of now, does not support any help facility for the users of the system. A help menu can be provided with a special function key and help command in the main page itself. > A training module can be included in the system. This module can be used to train the users of the system about the systems usage.