BOOK STOREA PROJECT REPORTSubmitted byARJUN PATEL (151213116011)ASHISH ASODARIYA (151213116003)In fulfillment for the award of the degreeOfBACHELOR OF ENGINEERINGInINFORMATION TECHNOLOGY APOLLO INSTITUTE OF ENGINEERING AND TECHNOLOGYGujarat Technological University, Ahmedabad April, 2017GUJARAT TECHNOLOGICAL UNIVERSITYAPOLLO INSTITUTE OF ENGINEERING AND TECHNOLOGYINFORMATION TECHNOLOGY CERTIFICATEThis is to certify that Mr. Arjun Patel enrolment no 151213116011 a student of 8th Semester B.E.(I.
T Department), has satisfactory presented her project entitled BOOK STORE the guidance and supervision of me for the term ending in April- 2018.To the best of my knowledge and belief, this work embodies the work of candidate herself, has duly been completed, fulfils the requirement of the ordinance relating to the Bachelor Degree of the University and is up to the standard in respect of content, presentation and language for being referred to the examiner. The results embodied in this project, to the best of my knowledge, haven’t been submitted to any other university or institution for award of any degree or diploma.Date: Internal Guide HODHIRAL RATHOD SANKET RAVAL GUJARAT TECHNOLOGICAL UNIVERSITYAPOLLO INSTITUTE OF ENGINEERING AND TECHNOLOGYINFORMATION TECHNOLOGY CERTIFICATEThis is to certify that Mr. Ashish Asodariya enrollment no 151213116003 a student of 8th Semester B.E.
- Thesis Statement
- Structure and Outline
- Voice and Grammar
(I.T Department), has satisfactory presented her project entitled BOOK STORE under the guidance and supervision of me for the term ending in April- 2017.To the best of my knowledge and belief, this work embodies the work of candidate herself, has duly been completed, fulfils the requirement of the ordinance relating to the Bachelor Degree of the University and is up to the standard in respect of content, presentation and language for being referred to the examiner. The results embodied in this project, to the best of my knowledge, haven’t been sub-mitted to any other university or institution for award of any degree or diploma.Date:Internal Guide HODHIRAL RATHOD SANKET RAVAL CANDIDATE’S DECLARATIONWe declare that our project report entitled “BOOK STORE” is our own work conducted under the supervision of the internal guide Ms.
HIRAL RATHOD We further declare that to the best of my knowledge the report does not contain any part of the work which has been submitted for the award of B.E Degree either in this or any other university without proper citation.STUDENT NAMES (Enrolment No.) (1) Arjun Patel (151213116011)(2) Ashish Asodariya (151213116003)INDEXChapter No. Contents Page No.
Acknowledgement i AbstractOrganization Profile iiiii List Of Table 16 List Of Figure 171. Introduction Page no 1.1 Project Detail1.
2 Project Purpose 1.3 Project Scope 19 1.4 Project Objectives1.
5 Technology ; Literature Review 22232. Project Management 2.1 Feasibility Study 2.
1.1 Operational Feasibility Study 2.1.2 Technical Feasibility 2.1.3 Time Schedule Feasibility 2.1.4 Economical Feasibility 2.
1.5 Implementation Feasibility 35 2.2 Project Planning 38 2.2.1Project Development Approach ; Justification 2.2.2 Project Plan 2.2.
3 Milestones; Deliverables 2.2.4 Group Dependencies 2.3 Project Schedule 423. System Requirement Study 3.
1 Study Of Current System 43 3.2 Problem And Weakness Of Current System 44 3.3 User Characteristics 44 3.4 Hardware ; Software Requirement 46 3.
4.1 Hardware Requirements 46 3.4.2 Software Requirements 46 3.4.3 Programming /Server/Database Tools 46 3.4.
4 Software Used 46 3.5 Constraints 47 3.5.1 User Interface 47 3.
5.2 Communication Interface 47 3.5.3 Criticality Of This Application 47 3.5.4 Safety ; Security Consideration 47 3.5.
5 Hardware Interface 47 3.6 Assumptions ; Dependencies 484. Requirement of Proposed System 4.1 Main Module of A System 49 4.1.
1 Introduction 49 4.1.2 Functionality of 50 4.1.3 Requirements of 51 4.1.
4 Major Components of 21 4.1.5 Descriptive Data 51 4.1.6 Connecting Feature ; Attribute 51 4.1.7 Data Manipulation 51 4.
1.8 Usability Of 51 4.1.9 Areas Where will be Used ? 51 4.1.10 Future Of – 4.2 Module Description 52 4.
3 Features Of New System 525 System Design 5.1 System Architecture Design 53 5.1.1 Use-Case Diagram 54 5.1.2 ER Diagram 58 5.1.3 System Activity Diagram 60 5.
1.4 Control Flow Diagram – 5.1.5 Data Flow Diagram 64 5.1.6 Sequence Diagram 74 5.
2 Data Dictionary 78 5.3 User Manual 87 5.4 Design Methodology 87 5.4.1 Observation Matrix – 5.4.2 Ideation Canvas 87 5.4.
3 Product Development Canvas 886 Implementation Planning 6.1 Implementation Environment 89 6.1.1 Implementation Planning 89 6.1.2 Database Implementation 89 6.1.
3 Core Class Implementation 89 6.1.4 User Component Implementation 89 6.1.5 Map Function ; Functionality Implementation 89 6.1.6 Administration Module Implementation 89 6.
2 Coding Standards 90 6.2.1 Purpose Of Coding Standards ; Best Practices 90 6.2.2 Naming Conventions ; Standards 90 6.2.3 Sample Coding 917 Testing 7.1 Testing Plan 105 7.
2 Testing Strategy 107 7.3 Testing Methods 107 7.3.1 Statistical Testing 107 7.3.
2 Defect Testing 107 7.4 Test Cases 1098 Limitations ; FUTURE Expansion 8.1 Limitation 115 8.2 Future Extension 1159 Conclusion ; Reference 9.1 Conclusion 116 9.2 References 117 Appendix-I Appendix-II Appendix-III ACKNOWLEDGEMENTI express my cavernous sense of obligation and gratitude to my guide Ms.Hiral Rathod for her genuine guidance and constant encouragement throughout this project work. I am highly obliged as my honourable guide have devoted her valuable time and share her experience knowledge.
I extend my thanks to HOD, department of Information Technology and principle, Apollo Institute of Engineering and Technology for providing me such an opportunity to do my project work in my college.I also wish to express my heartfelt appreciation to my friends, colleagues and many who have rendered their support for the successful completion of the project, both explicitly and implicitly.(1) Arjun Patel (151213116011)(2) Ashish Asodariya (151213116003)AbstractWe have undertaken ‘BOOK STORE’ project as a part of compulsory project seminar in 8th semester in degree engineering form AIET, ANASAN. The proposed website is online that will be directly communicate to suppliers and customer. From customers will place order and suppliers will receive order. As well as the main focus of website will be on production management and material and production stock management. ORGANIZATION PROFILE ABOUT QUICK SOLVE INFORMATIONQuick Solve Technologies is built with the experienced IT Professionals to give the best services to their clients. Our clients are from different fields like financial, manufacturing industries, Marketing firms, Constructions etc.
We are always ready to give solutions to your problems.Our ProcessQuick Solve Technologies applies the well pre planned ways to develop the applications. We always focus in depth in our client’s requirement and then start to develop application.
Our development process applies like following manners..Analyzing the problemMarket researchGathering requirements for the proposed business solutionDevising a plan or design for the software-based solutionImplementation (coding) of the softwareTesting the softwareDeploymentMaintenanceOur industry experience, combined with the expert trainers are an ideal platform for students who are looking to get exposure to IT industry. Project Training for freshers is provided by experts of the respective fields.
A project training certificate is provided at the end of the training. We even hire people after this training or help them get a suitable job in the ever growing IT industry.TechnologiesWe provide development trainings in different languages and technologies. PHP JAVA ASP.NET VB.NET AndroidKey FeaturesAlong with project training we provide some extra key features like.Career DevelopmentTeam Work DevelopmentTechnical EnhancementIndustry Based LearningImprovement Of Research & Development SkillsServices That We ProvideQuick Solve Technology provides the best services at any development platform with not compromising with quality.
We follow a systematic process to accommodate the customers’ requirements in the most efficient manner.Software Development Mobile Applications.Web Design ; DevelopmentPROJECT PROFILEProject Title :- BOOK STOREInternal Guide: – Ms. Hiral Rathod External Guide:- Purpose: – This website is web application. The proposed website is online that will be directly communicate to Supplier and Customer.
From customers will place order and suppliers will receive order. As well as the main focus of website will be on production Management material and production stock management. Platform:- Operating System – WINDOW XP,7 Front End – Microsoft ASP.NET Framework Back End – My Sql.Specification Tools:- Microsoft word for Documentation Microsoft Power Point 2007 for PresentationDeveloped By: – (1) Arjun Patel (151213116011) (2) Ashish Asodariya (151213116003)Submitted To: – Department Of Information TechnologyList of TablesTable No. Table Name Page No.1.
1 Tools ; Technology 781.2 Project Schedule 781.3 New books details 791.4 Old books 791.
5 Login 801.6 CR details 801.7 Select Course 811.8 Registration 811.9 Upload Project files 811.
10 Buy projects 821.11 Test case login 821.12 User Rights 831.13 Date Validation 831.14 Email Validation 841.15 Required field validation 841.16 Insertion 841.17 Automatic update 851.
18 Delete 85List of FiguresFigure No. Figure Name Page No.1.1 .NET Framework Architecture 251.2 Spiral Model 361.3 Charts For Scheduling 401.4 Usecase Diagram For Admin 551.
5 Usecase Diagram For Customer 561.6 ER Diagram 591.7 User Activity Diagram 611.8 Admin Activity Diagram 621.9 Data Flow Diagram(0 level) 631.10 Data Flow Diagram( level 1) 651.11 Data Flow Diagram( level 2) 661.12 Ideation Canvas 671.
13 Product development canvas 681.14 Testing Process 69CHAPTER -1INTRODUCTION1.1 Project Details:-“EQUICKES.COM” this website design for “Quick Solve Technology”. This website enables better management of Online Shopping. It Provides easy access to critical information there by enabling the management to take better decision on time.Ecommerce website for Production of pins equipment is independent to any relational database system like My SQL with Microsoft ASP.NET Framework technology.
The major advantage of this application is the process .1.2 Project PurposeThis application is web based(web application).
The proposed application is online that will be directly communicate to Supplier and Customer.From customers will place order and suppliers will receive order. As well as the main focus of application will be on production management material and production stock management. 1.3 Project ScopeE-Commerce will replace old shopping methodology with the latest technology. it is design to be Easy to use , featuring a graphical user interface similar to that found on most web application.The function of the E-Commerce will follow the function performed by the latest shopping .Operation of the E-Commerce should be almost intuitive to existing system as it modeled after existing procedures.
A key advantage of the E-Commerce is that it will consolidate the data stores in to one central location.This will enable the easy management of all information and ensure data integrity across the entire breadth of the system. This sharply contrasts the existing system where widely separated data store can lead to inconsistent information and misinformed staff.
Also, as the E-Commerce is to be interactive system, the incidence of errors in the data stores could be virtually eliminated. 1.4 Project ObjectiveMaintain all records.Maintain all details about customer and Products.
All completion work check by Admin.Admin aware about stock as well as material, Also checks products can deliver by employee at given time or not.1.5 Technology ; Literature Review Table 1.1:Tools ; TechnologyType of Application Web Based ApplicationFront End Asp.Net with C#Back End SQL server 2008 R2 Management StudioDocumentation Generation Tool Microsoft Word, Microsoft PowerPoint.Application Software Microsoft Visual Studio 2010TECHNOLOGY REVIEW The goal in application development is always the same: create the best possible software in the least amount of time. Yet the bar is continually raised, as demands from users increase.
To meet these demands, the platforms developers build on and the tools they use must get better and better they must evolve.The Key Technologies used in developing the In-House Product to be used Enterprise are:Clients:Microsoft Windows 7Microsoft Office 2007Asp.Net with C#Tools:Microsoft Visual Studio 2010We have used SQL server 2008 as the underlying database. The usage of SQL Server was done by analyzing the pros and cons of various databases existing in the market. To develop Web Asset Management Software we have used ASP.NET framework 4.
0. ASP.NET is a technology provided by Microsoft which supports multiple languages. We have used C# language with this. ASP.NET ASP.NET is a unified Web development model that includes the services necessary for you to build enterprise-class Web applications with a minimum of coding.
ASP.NET is part of the .NET Framework, and when coding ASP.NET applications you have access to classes in the .NET Framework. You can code your applications in any language compatible with the common language runtime (CLR) including Microsoft Visual Basic, C#, Jscript, J# etc. These languages enable you to develop ASP.NET applications that benefit from the common language runtime, type safety, inheritance, and so on.
ASP.NET INCLUDES A page and controls framework The ASP.NET page and controls framework is a programming framework that runs on a Web server to dynamically produce and render ASP.NET Web pages. ASP.NET Web pages can be requested from any browser or client device, and ASP.NET renders mark up (such as HTML) to the requesting browser. ASP.
NET Web pages are completely object-oriented. Within ASP.NET Web pages you can work with HTML elements using properties, methods, and events. The ASP.NET page framework removes the implementation details of the separation of client and server inherent in Web-based applications by presenting a unified model for responding to client events in code that runs at the server. The framework also automatically maintains the state of a page and the controls on that page during the page processing life cycle. The ASP.
NET page and controls framework also enables you to encapsulate common UI functionality in easy-to-use, reusable controls. Controls are written once, can be used in many pages, and are integrated into the ASP.NET Web page that they are placed in during rendering.The ASP.NET compiler :All ASP.NET code is compiled, which enables strong typing, performance optimizations, and early binding, among other benefits.
Once the code has been compiled, the common language runtime further compiles ASP.NET code to native code, providing improved performance. ASP.NET includes a compiler that will compile all your application components including pages and controls into an assembly that the ASP.NET hosting environment can then use to service user requests. Fig 1.1(.
NET framework Architecture)Security infrastructure In addition to the security features of .NET, ASP.NET provides an advanced security infrastructure for authenticating and authorizing user access as well as performing other security-related tasks. You can authenticate users using Windows authentication supplied by IIS, or you can manage authentication using your own user database using ASP.NET forms authentication and ASP.NET membership.
Application configuration ASP.NET applications use a configuration system that enables you to define configuration settings for your Web server, for a Web site, or for individual applications. You can make configuration settings at the time your ASP.NET applications are deployed and can add or revise configuration settings at any time with minimal impact on operational Web applications and servers. ASP.
NET configuration settings are stored in XML-based files. Debugging support ASP.NET takes advantage of the run-time debugging infrastructure to provide cross-language and cross-computer debugging support. You can debug both managed and unmanaged objects, as well as all languages supported by the common language runtime and script languages. In addition, the ASP.
NET page framework provides a trace mode that enables you to insert instrumentation messages into your ASP.NET Web pages. An XML Web services framework ASP.NET supports XML Web services.
An XML Web service is a component containing business functionality that enables applications to exchange information across firewalls using standards like HTTP and XML messaging. XML Web services are not tied to a particular component technology or object-calling convention. Extensible hosting environment and application life cycle management ASP.
NET includes an extensible hosting environment that controls the life cycle of an application from when a user first accesses a resource (such as a page) in the application to the point at which the application is shut down. While ASP.NET relies on a Web server (IIS) as an application host, ASP.NET provides much of the hosting functionality itself. The architecture of ASP.NET enables you to respond to application events and create custom HTTP handlers and HTTP modules.
An extensible designer environment ASP.NET includes enhanced support for creating designers for Web server controls for use with a visual design tool such as Visual Studio. Designers enable you to build a design-time user interface for a control, so that developers can configure your control’s properties and content in the visual design tool. Benefits The .NET environment allows today’s architects, analysts and developers to spend more time and effort focusing on their clients’ business issues and less time wrestling with the limitations of the technology itself. The .NET Framework was designed with several intentions: • Interoperability • Common Runtime Engine • Language Independence • Base Class Library • Simplified Deployment • SecurityMICROSOFT VISUAL STUDIO 2010 Overview It is an integrated development environment (IDE) from Microsoft. It can be used to develop console and graphical user interface applications along with Windows Forms applications, web sites, web applications, and web services in both native code together with managed code for all platforms supported by Microsoft Windows, Windows Mobile, Windows CE, .
NET Framework, .NET Compact Framework and Microsoft Silver light. Visual Studio includes a code editor supporting IntelliSense as well as code refactoring. The integrated debugger works both as a source-level debugger and a machine-level debugger. Other built-in tools include a forms designer for building GUI applications, web designer, class designer, and database schema designer. Visual Studio supports languages by means of language services, which allow any programming language to be supported (to varying degrees) by the code editor and debugger, provided a language-specific service has been authored. Built-in languages include C/C++ (via Visual C++), VB.NET (via Visual Basic .
Benefits It can auto generate stubs, event handlers, interface implementations etc for you – which can be a time-saver. It generates a .dll file so if you delete all your .aspx files the code still runs – which is source-code protection. In classic asp you have to deliver your source code to the client. Introduction To SQL Server 2008:Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet).
There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for different workloads (ranging from small applications that store and retrieve data on the same computer, to millions of users and computers that access huge amounts of data from the Internet at the same time). SQL Server 2005 introduced “MARS” (Multiple Active Results Sets), a method of allowing usage of database connections for multiple purposes.Architecture:This architecture of MS SQL Server contains different layers.Protocol layer Protocol layer implements the external interface to SQL Server. All operations that can be invoked on SQL Server are communicated to it via a Microsoft-defined format, called Tabular Data Stream (TDS). TDS is an application layer protocol, used to transfer data between a database server and a client. Initially designed and developed by Sybase Inc. for their Sybase SQL Server relational database engine in 1984, and later by Microsoft in Microsoft SQL Server, TDS packets can be encased in other physical transport dependent protocols, including TCP/IP, Named pipes, and Shared memory.
Consequently, access to SQL Server is available over these protocols. In addition, the SQL Server API is also exposed over web services.Data storage The main unit of data storage is a database, which is a collection of tables with typed columns. SQL Server supports different data types, including primary types such as Integer, Float, Decimal, Char (including character strings), Varchar(variable length character strings), binary (for unstructured blobs of data), Text (for textual data) among others. The rounding of floats to integers uses either Symmetric Arithmetic Rounding or Symmetric Round Down (Fix) depending on arguments: SELECT Round(2.5, 0) gives 3.Microsoft SQL Server also allows user-defined composite types (UDTs) to be defined and used.
It also makes server statistics available as virtual tables and views (called Dynamic Management Views or DMVs). In addition to tables, a database can also contain other objects including views, stored procedures, indexes and constraints, along with a transaction log. A SQL Server database can contain a maximum of 231 objects, and can span multiple OS-level files with a maximum file size of 260 bytes.38 The data in the database are stored in primary data files with an extension .
mdf. Secondary datafiles, identified with a .ndf extension, are used to store optional metadata. Log files are identified with the .ldf extension.Buffer management SQL Server buffers pages in RAM to minimize disc I/O.
Any 8 KB page can be buffered in-memory, and the set of all pages currently buffered is called the buffer cache. The amount of memory available to SQL Server decides how many pages will be cached in memory. The buffer cache is managed by the Buffer Manager. Either reading from or writing to any page copies it to the buffer cache.
Subsequent reads or writes are redirected to the in-memory copy, rather than the on-disc version. The page is updated on the disc by the Buffer Manager only if the in-memory cache has not been referenced for some time. While writing pages back to disc, asynchronous I/O is used whereby the I/O operation is done in a background thread so that other operations do not have to wait for the I/O operation to complete. Each page is written along with its checksum when it is written. When reading the page back, its checksum is computed again and matched with the stored version to ensure the page has not been damaged or tampered with in the meantime.Logging and Transaction SQL Server ensures that any change to the data is ACID-compliant, i.e. it uses transactions to ensure that the database will always revert to a known consistent state on failure.
Each transaction may consist of multiple SQL statements all of which will only make a permanent change to the database if the last statement in the transaction (a COMMIT statement) completes successfully. If the COMMIT successfully completes the transaction is safely on disk.Concurrency and locking SQL Server allows multiple clients to use the same database concurrently. As such, it needs to control concurrent access to shared data, to ensure data integrity – when multiple clients update the same data, or clients attempt to read data that is in the process of being changed by another client.
SQL Server provides two modes of concurrency control: pessimistic concurrency and optimistic concurrency. When pessimistic concurrency control is being used, SQL Server controls concurrent access by using locks. Locks can be either shared or exclusive. Exclusive lock grants the user exclusive access to the data – no other user can access the data as long as the lock is held.
Shared locks are used when some data is being read – multiple users can read from data locked with a shared lock, but not acquire an exclusive lock. The latter would have to wait for all shared locks to be released. Data retrievalThe main mode of retrieving data from an SQL Server database is querying for it. The query is expressed using a variant of SQL called T-SQL, a dialect Microsoft SQL Server shares with Sybase SQL Server due to its legacy. The query declaratively specifies what is to be retrieved. It is processed by the query processor, which figures out the sequence of steps that will be necessary to retrieve the requested data. SQL Server includes a cost-based query optimizer which tries to optimize on the cost, in terms of the resources it will take to execute the query.
Given a query, then the query optimizer looks at the database schema, the database statistics and the system load at that time. It then decides which sequence to access the tables referred in the query, which sequence to execute the operations and what access method to be used to access the tables. CHAPTER -2PROJECT MANAGEMENT2.
1 Feasibility Study Feasibility is a practical extent to which a project can be performed successfully. To evaluate feasibility, a feasibility study is performed, which determines whether the solution considered to accomplish the requirements is practical and workable in the software or not. Such information as resource availability, cost estimate for software development, benefits of the software to organization, and cost to be incurred on its maintenance are considered. The objective of the feasibility study is to establish the reasons for developing software that is acceptable to users and adaptable to change.A feasibility study is a short, focused study, which aims to answer a number of questions:Does the system contribute to the overall objectives of the organization?Can the system be implemented using current technology and within given cost and schedule constraints?Can the system be integrated with systems which are already in place?There are various types of feasibility studies:Operational FeasibilityTechnical FeasibilityScheduling FeasibilityEconomical FeasibilityNow each of them is explained briefly, as below.2.1.
1 TECHNICAL FESIBILITYThis is concerned with specifying equipment and software that will successfully satisfy the user requirement. The technical needs of the system may vary considerably, but might include: The facility to produce outputs in a given time. Response time under certain conditions. Ability to process a certain volume of transaction at a particular speed. Facility to communicate data to distant locations. In examining technical feasibility, configuration of the system is given more importance than the actual make of hardware. The configuration should give the complete picture about the system’s requirements. How many workstations are required, how these units are interconnected so that they could operate and communicate smoothly? What speeds of input and output should be achieved at particular quality of printing.
2.1.2 Time Schedule FeasibilitySchedule feasibility corresponds to whether sufficient time is available to complete the project. A project will fail if it takes too long to be completed before it is useful. Typically this means estimating how long the system will take to develop, and if it can be completed in a given time period using some methods like payback period. Schedule feasibility is a measure of how reasonable the project timetable is. Given our technical expertise, are the project deadlines reasonable? Some projects are initiated with specific deadlines.
You need to determine whether the deadlines are mandatory or desirable. Factors considered:-Schedule of the project.Time by which the project has to be completed.Reporting period.Considering all above factors it was decided that we have sufficient time and then we decided to start the project.2.1.
3 Operational FeasibilityThe system has been developed for any user who wants to use this system. The users must find the system friendly and easy to use. The interoperability with the existing system is also to be checked after uploading the website. So they may face certain problems in using the user interfaces. So keeping this consideration in mind we have provided field for each and every field on the forms.
The administrator also may be non-technical, so the user interface is designed in such a way that it gets comfortable for the non-technical person to operate easily.Using this intranet based application one can connect from anywhere at any time. The maps are available at any time. Some operational features of the city on the road map:1. Performance2. Information3.
EconomyPerformance: The application provides the connectivity to all the assets in a minimum time required.Information: This application will provide the detailed information about different assets available with the company.Economy: This System will use some existence resources like Computers, software, etc. Cost of this project is depending upon the man hour dedicated to the proposed System.