B Tech Project

THE PROJECTThe project Online shopping is especially made for those users who want to purchase various computer parts or branded computers through the internet, the user done the online shopping through internet and made the payment through Credit/Debit card / net banking Cheque/DD (Using a Mobile) .User can also get the information about any peripherals of computer or whole system which he or she wants to buy. The advantage of this project is that this project provides very easy and secure way for online shopping. User surf the shopping items list one by one and can add the product in the shopping list which he or she wants to buy, the project generates a virtual cart for the user when the first page open by the user until he or she done his whole shopping or session expires. After finishing the shopping users have to fill a small form to contain the basic information about them for manage the database. After this formality automatically the bill is generated and the payment is made through the Debit/Credit card which is done through the gateways that provide this functionality. There are basically two type of user one is client who wants to surf the site, either for information or for purchasing the product, and second one is administrator. To logon with administrator we want user name and password for the security purpose. The work of administrator is to maintain the database, in this project administrator have full right to manage, edit or update the database.ABOUT .NETThe strength of any project depends upon the technology on which the project is based. Today we are living in a world where technologies related to computer science are evolving every day new technologies are taking an edge over the older ones. Every new technology is provides some new benefits, but only small part of them remains in the competitive world. .NET is the latest technology, which is in use nowadays and has proved to be the most reliable development framework. The technologies we have used in the development of the project are:. NETASP. NETSQL_SERVER 2000Why to use .NET?The .NET Framework is a new computing platform that simplifies application development in the highly distributed environment of the Internet. The .NET Framework is designed to fulfill the following objectives:To provide a consistent object-oriented programming environment whether objects code is stored and executed locally, executed locally but Internet-distributed, or executed remotely.To provide a code-execution environment that minimizes software deployment and versioning conflicts.To provide a code-execution environment that guarantees safe execution of code, including by an unknown or semi-trusted third party. Advantages of .NETASP.NET is the latest Microsoft programming framework that allows for the rapid development of powerful web applications.Faster web applications: Two aspects of ASP.NET make it fast – compiled code and caching. In the past, the code was interpreted into machine language when your website visitor viewed your page. Now with ASP.NET, the code is compiled into “machine language” before your visitor ever comes to your site.ASP.NET was tested and found to be over 10 times faster for the average user than any other technology. While there have been some debates about the methods of testing, it is interesting to note that this has been validated by 3rd parties.Memory leaks and crashes protection: ASP.NET automatically recovers from memory leaks and errors to make sure that your website is always available to your visitors.Multiple language support: Programmers can actually write their code in more than 25 .NET languages (including VB.NET, C#, and Jscript.NET). This allows programmers to develop your site in the language.Deployment is Easy: As compared to ASP application, the deployment is as easy in .NET as there I is no need of registration of DLL.

ABOUT SQL SERVER 2000Microsoft SQL Server 2000 is a family of products that meet the data storage requirements of the largest processing systems and commercial Web sites, yet at the same time can provide easy-to-data storage services to an individual or small business.Microsoft SQL Server 2000 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration.Enterprise Manager is the main administrative console for SQL Server installations.Query Analyzer offers a quick and dirty method for performing queries against any of your SQL Server databases.Service Manager is used to control the MS- SQL Server (the main SQL Server process), MSDTC (Microsoft Distributed Transaction Coordinator) and SQL Server Agent processes. Advantages of SQL ServerSQL is widely used and accepted in the high-performance database industry. Its current version has recently been compared to Oracle, the database leader, in terms of overall market acceptance. Incorporating SQL means many clients’ IT staff will already have experience installing, configuring, and managing the database, and their staff will often already have already used. SQL was tested and used in the in the field for several years. Now in version 8, with millions of people having used it, bug fixing, tweaking, and performance testing has been completed in almost every environment. Clients can be sure data will not be lost, connections will not drop, and data will be secure.CLIENT SIDEOn the client machine to run this project we need any latest web browser for example Internet explorer (5.0 or above) or Netscape Navigator etc. and it should be configure to allow for cookies so that temporary variables can maintain on the client machine. SERVER SIDEOn the server machine we need 1 GB web space to deploy the project with .NET framework (1.0 or above) to execute the website. We also need the SQL database server for managing the database.VB.net allows you to build applications that run on a web server & interact with clients over the internet with the internet information service.CLIENT SERVER ARCHITECTUREThe Internet revolves around the client-server architecture. Your computer runs software called the client and it interacts with software known as the server located at a remote computer. The client is usually a browser such as Internet Explorer, Netscape Navigator or Mozilla. Browsers interact with the server using a set of instructions called protocols. These protocols help in the accurate transfer of data through requests from a browser and responses from the server. There are many protocols available on the Internet. The World Wide Web, which is a part of the Internet, brings all these protocols under one roof. You can, thus, use HTTP, FTP, Telnet, email etc. from one platform - your web browser. The web employs a connection-less protocol, which means that after every client-server interaction the connection between the two is lost. Let us now examine the client-server inter-communication with three models.Model #1 of the clientserver architecture Static HTML pagesINCLUDEPICTURE "../../sh/www.webdevelopersnotes.com/basics/model1.gif" \* MERGEFORMAT The client (browser) requests for an HTML file stored on the remote machine through the server software. The server locates this file and passes it to the client. The client then displays this file on your machine. In this case, the HTML page is static. Static pages do not change until the developer modifies them.Model #2 of the client-server architecture - Server side scripting technologiesINCLUDEPICTURE "../../sh/www.webdevelopersnotes.com/basics/model3.gif" \* MERGEFORMAT The third case also involves dynamic response generated by the use of server side technologies. There are many server side technologies today like JSP, ASP etc. A systematic investigation of a real or planned system to determine the function of the system and how they relate to each other and to any other system is known as system analysis. System analysis is conducted with the following objectives in mind:Identify the customer’s need,Perform economic and technical analysis,Evaluate the system concept for feasibility,Allocate functions to hardware, software, people, database,Establish cost and schedule constraints,Create a system definition that forms the foundation for all subsequent engineering work.System Analysis

Overview:Problem recognition means detailed study of the current system being used by the user. A detailed study of system being currently used must be carried out of sessions with customer and end user. It can be termed as a process of recognizing problems and opportunities.A complete understanding of software requirement is essential to the success of a software development effort. The problem evaluation and solution synthesis is the next major area of effort for analysis. It enables the system, engine to redefine the software allocation and build model of process followed Identification of need Preliminary investigationIdentification of need:The first step of the System Analysis process involves the identification of need. The analyst meets the customer and the end user (if different from the user). The intent is to understand the products objective and to define the goals required to meet the objectives. Timely Customer-Analyst communication is an important ingredient of a system analyst’s work. The specific objectives are:Reducing the Duplication during manual Processing Designing and Developing User friendly interfaces through which user will interact with the packageInteraction of these GUI with the DatabaseManaging the DatabaseImprove efficiency and quality of servicesThere are a number of factors that needs to be actively handled, the system must track the data and be able to manage it as well as give the detailed account of the comparative study in the forms of graphs and reports.Every system must have some complexity attached with it, which is needed to be simplified so that we can achieve a system, which is easier, less complex and easily accessible to the less trained user.The above stated complexity being faced by the staff in respect of such a large number of departments and variety of programs being run by each department, each having its own criteria makes it entice the official to look for a system which can operate with a such a complex nature of data and be developed in such a way so that it becomes relatively easier to operate by the end user.Preliminary investigation:During the analysis phase of the project, first we decided to sit/talk /and understand the current workflow. And found that the basic functionality is divided into 12 major modules, which deals with registration management, searching for tender management, supplying and purchasing of tender management, generation of reports for each requirement and searching for many other facilities etc. Feasibility study:All the projects are feasible given the unlimited resources and infinite time. Unfortunately, the development of a computer-based system or product is more likely to be plagued by the scarcity of resources and difficult delivery dates. It is both necessary and prudent to evaluate the feasibility of a project at the earliest possible time. Months or years of effort, thousand or millions of rupees, and untold professional embarrassment can be averted if an ill-conceived system is recognized early in the definition phase.Feasibility and risk analysis are related to each other. If project risk is great, the feasibility of producing quality software is reduced.However, we confine our attention to: Technical Feasibility.Economical Feasibility.Operational feasibility.Technical Feasibility:A study of function, performance, and constraints that may affect the ability to achieve an acceptable system. It is the most difficult area to assess because objectives, functions, and performance are somewhat hazy; anything seems possible if me right assumptions are made.A clinical attitude should prevail during an evaluation of technical feasibility. The considerations normally attached with the technical feasibility:Development Risk: Can the system element be designed so that necessary function and performance are achieved within the constraints uncovered during analysis?Resource availability: Are skilled staff available to develop the system element in Question? Are any other necessary resources (hardware and software) available to build the system?Technology: Has the relevant technology progressed to a state that will support the system?All of the above consideration also applies to the work I have done. As far as developments risks are concerned, yes necessary functions and the constraints under which they have to perform have been identified and divided into modules so that each module performs its own assigned task.The use of programming language enables the programmer to develop software that can help end-user to operate the system more easily. The use of GUI tool VB.NET and Oracle 8i can be really helpful in case of developing an

information system. The tool comprises of all the components required to solve me problem system.Economical Feasibility:An evaluation of development cost weighed against the ultimate income or benefit derived from the development system or product. It includes a broad range of concerns such as:Cost-benefit AnalysisLong-term m corporate income strategiesImpact on other profits/productsCost of resources needed for developmentPotential market growthThe work being done is economically feasible since the work is not being done at very large scale, although it might be a bit complex. The cost of resources needed to do the work was not big. I did receive the necessary monetary help required to develop this software.Operational Feasibility: This study helps us in finding whether the work to be done will be operational with the available staff and with in the given time. The staff is fully capable of handling information system. The IT literacy is of good order and the software has been made in such a way that it becomes easier for the user to answer queries being asked. This will facilitate easy use and adoptability of the system. Based on this, it was felt that the proposed system would be operationally feasible. With the use of menus, simple command buttons and proper validation required it become fully understandable to the common user and operational with the user.SOFTWARE REQUIREMENT SPECIFICATIONA document describes the requirements of a computer system from the user’s point of view. An SRS document specifies the required behavior the system in terms of input data, required processing, output data, operational scenarios and interfaces and the attributes of a system including performance, security, maintainability, reliability, audit ability, availability and safety requirements and design constraints. Alias: user requirement specification, functional specification.The software requirement specifications produced at the culmination of the analysis task. The function and the performance allocated to software as part of the system engineering are refined by establishing a complete information description, a detailed functional and behavioral description, an indication of performance requirements and design constraints, appropriate validation criteria, and other data pertinent to requirements. [Pressman Roger S.] SRS was evolved based on brain storming sessions and active interactions with the following set of stakeholders:Assistant registrar (PGS)Superintendent (PGS)AssistantChairman, grades and registrations.The main area of the I.T. dept, which had to be automated, was described in module description. E-R Diagram EMBED PBrush Default Page This is the default page of this site, which gives the general information of the site. All menus are also placed on this page which provides different options for client. A client can start shopping by clicking on Continue shopping option, can view shopping cart and help is also provided for him. Administrator of this site also has the option on this page for login to manage the recordsHome Page Homepage appear for the user when user select the option to view the products or he want to shop any thing. This page contain all the products which are available to shop, and also have link through which he can get the full detail of the products For example if the client want to view the detail information about the Hard Disk he simply click the link which is given below the icon of the Hard Disk on the Home Page, and the page will be appeared that contain the information about the product. If the client wants to shop that product, he or she has to simply click on another link and the page will be appeared which shows the availability of products with their prize. Now on this page client has the option to add the product in the virtual cart.This is another example: - In between the shopping or after finishing the shopping client can view his shopping cart and make the changes in quantity. And to make the payment he proceeds to check out. After making the shopping client have to give some information about him to do this he have to fill a small form. After that all the information is shown to the client if there is any mistake he can made the changes and here he have also the option to go back for more shopping.To proceed next the bill of the user is generated and payment option is appeared, which is further connecting to the payment gateways.Rather this main functionality there are several other things that are available for the client like there are given many important links, to search engines,

job links etc. To mange the records there are available a link for administrator, if the person is authorized user he is allowed to manage the record by taking the valid username and password.There are several options for administrator to manage the different records by providing him different links. Admin have the option to manage (delete, add, update) record in Brand table. He is also having the option to manipulate Category table. Direct manipulation can also be done by the administrator on the Product table. Administrator can change the Customer record; he can delete any customer if he found that customer is not making any transitions for a long time.System Testing is very important issue in system development. During system testing the system is used experimentally to ensure that the system does not fail and will run according to its specification producing desired outputs as per the user expected from it.In many organization persons other than those who have written it perform testing, so that the software will be more reliable. Following tests can carry out the testing of system: . White Box Testing. . Black Box Testing.White Box Testing White Box Testing, sometimes called glass box testing is a test case design method that uses the control structure of the procedural design to derive test cases. White Box Testing considers system to be like a White box, which means that every thing about the system is known to me. The different programs used in the system, Procedures used, inputs supplied and I know the outputs produced by it in advance. Person who has developed it generally carries out White Box testing and he/she tests the system against all odd conditions for extreme values. I tested all the modules independently. In the testing of each module I tested all the functionality. Right from ‘New or Add’ to ‘Exit or Close’ and from ‘Move-first’ to ‘Move-last’ all were tested. All the if-else structures with various values supplied at various times were checked. I checked all the loops used in the system and checked at their boundaries too.White Box Testing in the application is carried out in two parts:. Alpha Test. Beta TestAlpha Test:Alpha test of the application involves testing (checking) the system by testing each and every part of the system separately. In this test the experts or those who have made the system test each module of the system for different types of inputs. Beta Test:Beta test involves testing of the system treating the system as a whole and the complete system is tested for extreme values for finding the output generated by it are as desired or not. I have tested my application by inputting the sample data and found that my application passed Beta test.Black Box Testing:Black Box Testing focuses on the functional requirements of the software. It uncovers a different class of errors than white box testing methods. The end users or the ultimate user carries out Black Box testing for whom the system is made or some one who not knows how the system is being made. Selecting some persons of the organizations who have to operate on the system can perform this testing so that they know what inputs to be given to the system for different options and what should the output generated by the system for those values. To perform this test I selected some persons from the organization including one senior person also and tested the application. They then evaluated that whether the system is working properly or not. They all found the system working according to specification. Some one who neither knows about the work carried out by the system nor about how it is developed can even perform this test. Thus testing of the system by this method can even be done for absurd values, which are unknowingly entered by the user. The testing of this project is also done accordingly to these above methods so that it can fulfill the needs, produce all desired output even in the worst possible condition and can prove to be a reliable software. I started the testing of the system right from the Alpha test to Beta test and then Black box test. Initially it was tested for each and every input give to it and how it responds to those inputs. The validation and checks which are masked for certain inputs like Names, Numbers, alpha numeric, floating point numbers, Unique Fields, Maximum Size, Values and other Special Fields and ranges is working or not for each and every entry forms. The testing is then done for the different calculations and queries for the different combinations to find the results in the outputs. By running each individual

forms as my software is developed using event based concept. In this project all the functionality done through the Web Services known as Web Method. The benefit with the Web Services is that we are able in the future to develop other kinds of application from web application. For example site get popular and now if we want to develop the same thing in mobiles so we can do this without writing the new code for the database connection. We just call the web methods in the new smart device applications like the windows application, WAP applications or mobile applications etc.The final product named On Line Shopping, which allows users to purchase easily various computer peripherals through an internet. It involves the ASP.NET framework functionality with backend design of SQL Server 2000.The front-end design is made in ASP.NET web forms with VB. The ASP.NET provides different functionalities to help user/client to use the portal in a user friendly way.Professional VB.NET 2005 Author: Christian Nagel, Bill Evjen, Jay Glynn, Morgan Skinner, Karli Watson Publisher: DreamtechProfessional ASP.NET 2.0Author: Bill Evjen, Scott Hanselman, Farhan Muhammad, Srinivasa Sivakumar Publisher: DreamtechMicrosoft ASP.NET (STEP BY STEP)