Designing A Online Book Shop System Information Technology Essay

Designing A Online watchword Shop System In annoy foration Technology EssayIntroductionThe top hat Book Shop order to issue online service to improve amplification and conk out their marketing, they invite us to practice matchless online account accommodate work fund system. net obtain is a exploit to each(prenominal)ow consumers to secure goods or service directly from a lead astrayer in received time, without intermediary services on the net income. If on that point is an intermediary service is c every last(predicate)ed e-commerce. An online shop, eshop, e- bloodline, internet shop, weather vaneshop, wind vanestore, online store, or realistic store evokes the physical simulation to acquire harvestings or services in a brick and cement retailer or shopping m every last(predicate). This process is cognise as business to consumer (B2C) online shopping. When companies buy other companies, is k nown as the cable to Business (B2B) online shopping. B2C and B2B both in the plaster bandage of e-commerce online shopping.In order to design intensityshop system, we entrust visit simple online bookst every last(predicate) for feasibily dissect. Create jut externalizening to control work flow, design the course and related entropybase system, we allow abide facility guide and exploiter guide as the homogeneous time. We exit present our work with several documents, each document is subordinate showing their individual discipline. There argon feasibily sketch, device planning, program design, installation guide and exploiter guide. Open those documents you target find what degrees we be working.Feasibility studyFeasibility study is nonp beil primary(prenominal) study that to consider the project we go do or non. Feasibility study was to evaluate a proposal to determine the specific difficulties of the task. In general, the initiatory feasibleness studies and engineering development projects. In other words, the feasib ility study, catch up withgrade or analysis of the potential impact of the proposed project.In case of our feasibility studying, rootage we will visit angiotensin converting enzyme popular online bookshop to generate more info approximately this bookshop system, and then we employ the info we collected to analysis the feasibility to implement rising online bookshop.virago.com, Inc. is a US-establish international e-commerce attach to. Headquartered in Seattle, Washington, which is the largest online retailer, has aboutly three times the runner-up network sales, Staples Company, as of January 2010. amazon.com, founded in 1994 and 1995 the order launched on the web. The company was before called Cadabra company, further the seduce has changed, people found that people mosttimes hear the name of body. virago.com too chose this name beca practice the Amazon is the worlds largest river, so the name implies large size, just similarly in part because it a, so the l etter will appear near the beginning of the list. Amazon.com started as an online bookstore exclusively soon diversified, selling the DVD, CD, MP3 download, selective information processor softw are, video games, electronics, clothing, furniture, food, toys and so on. Amazon has established separate web points in Canada, Britain, Ger umpteen, France, japan and China. It also provides international shipping of about products in certain countries. 2009 analyse found that Amazon is the UKs favorite music and video retailers, retailers and ternary overall.The company began as an online bookstore, and the largest brick and cement bookstores and mail order catalog of books whitethorn provide 20 million titles, atomic number 53 arouse provide more online bookstore. Bezos company named Amazon, the worlds largest river. Since 2000, Amazons identity is an arrow leading from A to Z, on behalf of guest expiation (because it forms a smile), one goal is to make each product in the alph abet.Amazon was founded in 1994, in Washington State. July 1995, the company began to sell its services, and the commencement book in amazon.com Douglas Hofstadters Fluid concepts and creative analogies com raiseer models of the basic mechanisms of Thinking. In 1996, it was reincorporated in Delaware. Amazon launched its IPO on May 15, 1997, trading companies Nasidake big board AMZN, in the initial public offering charge of $ 18.00 per share, USD ($ 1.50 after dribble split three in the late 90s).Amazons initial business plan was unusual the company does non expect profit of 4 to 5 years. Its slow growth caused complaints from shareholders, the company has not reached profitability fast enough. When the Internet bubble burst, many e-companies went out of business, Amazon persevered and finally turned its eldest profit in the fourth quarter of 2001 500 million, or 1 cent per share, on revenues over one billion U.S. dollars, merely low-toned It is grand to the profits of the business model tidy sum prove to be profi fudge. In 1999, Time magazine named Bezos Person of the Year, recognizing the companys successful promotion of online shopping.Amazons product line includes books, music CD, video and DVD, software, consumer electronics, kitchen supplies, tools, lawn and garden supplies, toys and games, baby supplies, clothing, Tiyuyongpin, food, jewelry, clocks and watches, wellness and personal care products, beauty products, musical instruments, clothing, industrial, scientific supplies and groceries.The company launched amazon.com vendue, the auction Web service, in March 1999. However, it did not take the chip in the industry pioneer eBays large market share. amazon.com auction embraceed by the unveiling of a fixed-price market operations, zShops, 1999 9 months, and the now defunct Sothebys / Amazon Cooperation as amazon.com November. Amazon Auctions and zShops evolved into the market in 2001, launched a service to allow customers to sell used books , CD, DVD and other products with new projects. Today, the markets main rival Amazon, eBays Half.com service. alarming 2005, Amazon began selling its products in its own brand , flat cases, state the trademark application, the label will be used for school textiles, kitchen utensils, household goods. In March 2007 the company expanded to cover more trademark applications for assorted list of goods and register a new design consisting of letters to form words Hiramatsu letter O and space gaps appear in the one oclock position.. Reported by the trademark grew to include items untold(prenominal) as paint, carpet, wallpaper, tomentum accessories, clothing, footwear, interrogative sentencegear, cleaning products and jewelry. September 2008, Amazon sendd under famous. linked States Patent and mark Office has completed the freshen up of the application, but Amazon has not stock- silent received official registered name.Amazon MP3, its own online music store, launched in the fal l in States September 25, 2007, sales of MP3 format, download no digital rights management. This is the first obtainable online DRM free music of all four major constitution companies.The sphere amazon.com attracts tourists, at least 615 million U.S. dollars, double the 2008 number of walmart.com. Amazon attracts approximately 65 million customers to its site each month in the United States.Amazon allows users to submit comments to the page of each product. Reviewers rate the products, must be in a rating scale from one to five stars. Amazon provides an optional comment badge options that the real name of the reviewer (based on confirmed credit card account) or that Reviewer is a review by popularity.Amazon.com customer reviews are monitored obscene, but allow negative comments. Specter, the book on amazon.com, describes how when introduceers and authors asked Bezos why the negative comments will be published amazon.com, defended his approach, claiming that amazon.com is fetc hing a diametric way We hope to enable each book good, bad, ugly truth let loose (Sipeikete 132). Allegations yield been made, Amazon has a negative evaluation of the selective deletion of related projects, despite the views of Scientology accord with the guidelines.Book Search is a feature that allows customers to search for keywords in the text in many books directory. The function started with 120,000 titles (or 33 million pages of text) October 23, 2003. Currently about 25 million books in the program. Amazon has about 130 publishers and allows the user to perform these searches.In order to avoid simulateright infringement, amazon.com does not cede a machine-readable text book. Instead, it returns pages that match a picture to prohibit printing, and proposed to designate the number of pages in a single user can access. In addition, customers can purchase online access to slightly of the same book through with(predicate) with(predicate) the Amazon Upgrade program.Abou t forty percent from sales of the Amazon Amazon associate and affiliate marketing so-called ternion-party sellers who sell their products in Amazon citation needed. Customers associate commission referred to the Amazon Amazon link located on its Web site, the results of the sale if the referral. In Shijiefanwei, the Amazon has over 900,000 parts in its affiliate program. Amazon reported over 1.3 million sellers sold products through Amazons Web site in 2007. Unlike eBay, Amazon sellers do not have to go for separate payment accounts, payment processing of all the Amazon.Employees can directly access the catalog on its Web site utilise Amazon Amazon Web Services (AWS) of the XML service. A new subsidiary products, aStore, the association is embedded in a subset of Amazon products, or link to another site. June 2010, Amazon launched product urge onations seller (said to be internally referred to as Genesis Project) to provide more transparency, vendor-specific products preach ed for sale to a third party Amazon seller. Product cheerations are based on customers browsing history.January 2010 survey found that third-party vendors Auctionbytes.com, Amazon fourth. amazon.com second profit. The lowest rating, but still above average, in the ease of use. Amazon seller that clearly delimit rules, provides a steady stream of traffic list, with a focus on reducing part of the community. amazon.com came in second place in the sales recommendation category.Focus on amazon.com bookshop system, there has several important features that we need to know, first is clearly item catalog system, Amazon have many items are selling on their web site, such as books, digital devices, shoes, clothes, Toys, etc. although there are too much items on bookshop system, it is very clearly and easy to find, as the same time, Amazon provide a powerful item search engine for user to search their favorite products. It is one feature that Amazon to attract users visits them and purchas e items.Another important point is shopping draw system and member system. Amazon provides are powerful member system that every customer need create one member account on Amazon.com for purchase items and transfer payment. Looking for Amazons member system, it must have get toprise train database master of ceremonies to mount large size transfer and member character. obtain cart is one system on Amazon that we need to pay attention to. When user browsing and shopping on Amazon.com, if they have some favor item they want to buy, they can put it into shopping cart. Finally, they may go to shopping cart page to check what they had bought, if user exact to buy all items, they may direct transfer payment. If users order has any change, they can remove any item from shopping cart, that will not to pay extra charge and the total amount will real time change. later on studding Amazon.com, we are summary that online bookshop system is one good idea to develop. We are focus on marketi ng and technical.In recent years, online shopping has become popular, but it still caters to upper center class. For online shopping, must be able to have access to a computer, banking concern accounts and debit cards. Shopping has evolved with the growth of technology. It is found that e-commerce in the diary, if we focus on the demographic characteristics of shoppers in the family, in general, the higher the education level, income, occupation of head of household, a more favorable perception of non-store shopping. An influential factor in consumer attitudes of non-store shopping is exposure to technology, because it has been demonstrated to increase the probability of exposure to technology development to increase the favorable attitude of the new shopping channel.expand the target audience online shopping men and women of the middle class. Initially, the main users of online shopping is young men, high income level and university education. This profile is changing. For exampl e, the early years of the Internet in the United States there are very few women users, but to women in 2001 were 52.8% of the online population.Focus on technical of bookshop system, nowadays, hardware and software develop maturity for use to design powerful web scheduling and database system, we have a lot of choice to implement bookshop system, such as Windows legion, Linux, Solaris, UNIX and AIX system for operating system. infobase systems have MYSQL, MSSQL and Oracle. CGI Programming had PHP, Perl, C++ and Framework .Net. We are most likely to choice open seeded player resources. They are Linux, Apache, MYSQL and PHP. The advantage of open source resources are low cost for develop. It is very suitable for us that we without too much develop capital. mount draw of the online book shop systemA context diagram is a data flow diagram, with solo one massive interchange process that subsumes everything inside the scope of the system. It shows how the system will receive and direct data flows to the external entities involved. The online book shop system including three functions customer, Supplier, and The trump book shop. Clients apply for social rank and can buy book online. The member function is mainly for purchasing book online. When guest be a member of online book shop, they can purchase view the book detail and purchase it online though credit card. The supplier will provide books information to the best book shop, after that, their book will be a product of online book shop they will return profit and book selling status. The best book shop mainly provides the online computer program and maintain for it.AimThe aim of the research program is to develop an online book shop .The intention is to understanding of the modeling and installation of a data-driven system, information systems planning, project management, rapid application development and end-user systems development.ObjectivesTo develop a user-friendly e-commerce website.To provide u nlike books for customer to chooseTo develop a web port wine for executive access to update book storeTo provide information of bookTo setup the book price and purchase onlineDataflow of customerThe first abuse in the process of buying the product is to apply for membership. After registered, users data will store in database and only registered member can see book detail and purchase. Then, customer will choose their neediness list and add in the cart, after that, the data will store in database. While client click go to payment, it will direct to payment gateway to process it. Whatever the payment is success or not, the payment gateway will return. If payment success, book shop will prepare the delivery.Dataflow of supplierThe online book shop will provide login and countersignature to supplier. When supplier login into the system, they can update their book information and add some new book into the system. While submitted the data, the online book shop will approve or rej ect the product. If approved the product, the book will display on the book store.Dataflow of the best book shopThe best book shop is the administrator of the website they provide maintain and update product information. After administrator login into system, they will update the website data, approve the product provide from supplier or download sales report, purchase report else.A picture down the stairs show an Entity Life History for a memberThe Figure shows the entity invigoration history for a member. A member begins its life by a New member, and ends it by a Close. When a member join the membership and confirmed, it will start the member lift cycle ( purchase book the website).IntroductionKent (1978) explained that database is a model of some aspect of the reality of and organization. A data model allows us to treat a database as an glom machine. In other words, we can concentrate on the principles of design break up from an immediate concern with implementation.There hav e three database packages suitable for their website, relative database, intention -oriented database and Object- comparative database. The basic data structure of the comparative model is the table, consequently all dealing (tables) in a relative database have to stupefy to some basic rules to qualify as relations. An object- oriented database can be said to provide a middle ground mingled with relative database and object-oriented database, which mode it included with a programming API for storing and retrieving objects, and little or no specific support for doubtfulnessing. An Object- comparative database is a database management system (DBMS) similar to a relative database, but with an object-oriented database model objects, classes and inheritance are directly back up in database schemas and in the query language.Three database packages would be suitable for the setup business directory.Relational DatabaseEdgar F. Codd (1970) invented the relational database in 197 0, relational database are based on relational set theory which is the structure of a database. A database is simply a collection of one or more relations or tables with columns and rows. Because of serials relations of tables, Normalization is a vital component of relational model of database. Normalization was an integral part of the relational model which increases complexity and processing.Benefits of relational database are that the system is simple, flexible, and productive. Becausethe tables are simple, data is easier to understand and report with others. Relational database are flexible because users do not have to use predefined keys to input information. Also,relational database are more productive because SQL is an easy and human-readable language. SQL book of instructions are in the form of plain instructions, which can be put to the database for implementation. This allows users to spend more timeinputting instead of learning. The other important advantages of relati onal database include their performance, power, and support to new hardware technologies as also tractableness and a capacity to meet all types of data needs. More importantly, relational database biggestadvantage is the ease with which users cancreate and access data and extend it if neededBut there are limitations to the relational database management system. First, relational database do not have enough storage area to spread over data such as images, digital and audio/video. The system was originally created to allot the integration of media, traditional fielded data, and templates. Another limitation of the relational database is its insufficiency to operate with languages outside of SQL. After its original development, languages such as C++ and JavaScript were formed. However, relational database do not work efficiently with these languages. A third limitation is the requirement that information must be in tables where kinships amid entities are defined by values.The thr ee fundamentals of a relational database are that all information must be held in the form of a table, where all data are described utilize data values. The second fundamental is that each value found in the table columns does not repeat. The final fundamental is the use of Standard Query spoken communication (SQL), such as MYSQL or Microsofts Access.MYSQL usable from http//www.mysql.com/ Accessed 23 January, 2009Microsofts Access Available from http//office.microsoft.com/en-us/access/default.aspx Accessed 23 January, 2009Object- oriented databaseTo combat the limitations of relational database and meet the repugn of the increasing rise of the Internet and the Web, object-oriented database developed in the 1980s. The most important characteristic for object-oriented database is the joining of object-oriented programming with database technology, which provides an integrated application development system.The object-oriented database has many advantages and benefits. First, objec t-oriented is a more natural way of thinking. Second, the defined operations of these types of systems are not dependent on the particular database application running at a given moment. Third, users are allowed to define their own methods of access to data and how it will be represented. It can store more types of data, and access this data, and much faster than relational database. Another benefit of object-oriented database is that kins are represented explicitly, it support large number of relationships between the objects.However, object-oriented database also has discriminates or limitations. atomic number 53 disadvantage of relational database is that it lacks a common data model. There is also no current banner, since it is still considered to be in the development stages. Also there are unavailability of object-oriented CASE tools and confusion with too many different object-oriented development methods.Object-oriented database use a query language called object query l anguage (OQL) to manipulate and retrieve data. object query language supports object referencing at heart tables. Objects can be nested within objects. Python is an example of Object-oriented database.Python Available from http//python.org/ Accessed 23 January, 2009Object- relational databaseObject-relational database management systems grew out of research that occurred in the early 1990s. It can handle new types of data such as audio, video, and image files that relational database were not equipped to handle. In addition, its development was the result of increased recitation of object-oriented and a large mismatch between these and the DBMS software. Object-relational database are systems that examine to extend relational database systems with the functionality necessary to support a broader class of applications and, in many ways, provide a bridge between the relational and object-oriented paradigms.One advantage of ORDBMS is that it allows organizations to continue employ their existing systems, without having to make major changes. This can be referred to as reuse. It gives rise to increased productivity both for developer and end-user A second advantage is that it allows users and programmers to start using object-oriented systems in parallel. Also, it able to handle and query large and complex applications.Though Object- relational database have some advantages by the way of using object oriented features, it is also not fully solving the problems. Object-oriented database have some disadvantages like Complexity and SQL is now extremely complex thus query is hard to optimization.Many SQL object- relational database are extensible with user-defined types and custom-written functions, such as Oracle.Deploy a database on the InternetTo deploy a database on the internet, we need serial process to do it. The client side can use browser as tool to access the database. The horde side has to setup a web server. Client sent the request to the server thoug h browser. When database saved the record and it send back response though browser. Browser process all the database action. We can build/design the web site by using dreamweaver.Window platformWe can install IIS as our web server in window platform.IIS support Active waiter Pages ( asp) which is a technology that enables you to make dynamic and interactive web pages. ASP pages have the perpetuation .asp instead of .htm, when a page with the extension .asp is requested by a browser the web server knows to interpret any ASP contained within the web page before sending the HTML produced to the browser. This way all the ASP is run on the web server and no ASP will ever be passed to the web browser. Access or SQL server can be use for database.Linux platformLinux is a perfect platform for setup web server. We can install Fedora as our OS package. Apache would be the best web server. The program side we can use PHP which is a freeware for build up web page. The database can use MYSQL a s database server, its a relational database.An Entity Relationship Diagram of the online book shopEntity verbal descriptionEntity Name publisherDescriptions The storage of the publisher details.Data part fieldidnameusernamepassworddateEntity Name bookDescriptions The storage of publishers book.Data Element satiateIdpublisher_idcodenameauthoryearpricediscountstockEntity Name book_priceDescriptions The storage of books price.Data Element mental objectidbook_idpicturesortEntity Name memberDescriptions The storage of member dataData Element Contentidusernamepasswordemailfirstnamelastnameaddress promiseEntity Name member_orderDescriptions The storage of members order on website.Data Element Contentidmember_idpricedateEntity Name member_order_detailDescriptions The storage of orders detailData Element Contentidmember_order_idbook_idquantityThe following tables are in 1NFThe following tables are in 2NFThe following tables are in 3NFRelationship Description between Entitiesmember memb er_order member_order_detailThe relationship between three databases are one to many, that center one member will have more than one member_order record, but one member_order record will have one member record only. Also, one member_order will have more than one member_order_detail, but one member_order_detail relate to one member_order only.Publisher book book pictureThe relationship between three databases are one to many, that means one publish will have one or many book records, but one book will have only one publisher. And each book may have more than one picture.Member_order_detail bookThe relationship between two databases are one to many, one and only one book record will in each member_orde_detail, but only one book will have more than one member_order_detail records. veil shotHome pageBook detailAdd to cartA Login PageMember registrationSearch book didactics PlanStep/ContentTime/Training MaterialsI. Review (all together)A. Training goal reap the online book system.1 0 proceedingWhiteboard (as needed)II. Overview (all together)A. Overview Go through the system step-by-step.B. Training objectives advert the function of the system.C. Importance Review the interface of the system.30 minutesHandoutIII. insertion (all together)A. Concepts Plan using by using mnemonic acronymB. Steps Review each function and the emphasis it coversC. Demonstrate Q A about what each step meansD. Examples Outline for Presenting Class2-3 hoursHandoutIV. Exercise (small collection)A. Applications Practice in group1-2 hoursGroup discussionV. SummarizeA. Q A Ask for any improvement.30 minutesWhiteboard (as needed)Installation Guide Install MYSQL Database ServerOnce implement bookshop system, we need create related database for record information that create by bookshop system or input from users. Bookshop system is using MYSQL for backend database system, entertain visit http//www.mysql.com for more information and download MYSQL DBMS software.clenched fist visit http //www.mysql.com , you will see download (GA) on the top of the web page, click this button and the page of body will change to download information, scroll down the web page, you can find MYSQL Community Server, it will show a short description and version no of this DBMS. check off download button (with red circle remark on figure) to enter download MYSQL DBMS.After enter download page, you will see different package of database system, you need to choice which operating system for your database server. For example, if you are using windows server, please choice Microsoft Windows, and there have 32bits and 64bits version for user install. We recommend download package that with installation execute.Directly double click the file you download from mysql.com for MYSQL server installation, setup program will ask you motility step by step to help you install MYSQL DBMS in to windows system, such as where you want to install MYSQL DBMS, and which component you want to install. We reco mmend you setup MYSQL on the root of the server that such as CMYSQL on windows system. It is because it let user easier to operate and manage data on database system. And we recommend user use complete method to setup MYSQL, it make setup program install all of MYSQL DBMS component into the windows server, it sheer the problem that we may need reinstall some components when MYSQL system report something missing when system running. Please follow below pictures to setup MYSQL DBMS. reprise click mysql-essential-ver-win32.msi that you downloaded from mysql.comStraight forward to DBMSClick NextWe recommend choice Complete to let setup program to install all MYSQL components into windows system.Click Install to start installation.Waiting setup software copy file.Install procedure competed, and program will ask you to configure MYSQL server, we recommend configure it as the same time.After setup procedure, now we are going to MYSQL database server configure wizard, it is one important p rocedure that it may affect database server performance. The method of database setting is as same as installation procedure that setting database step by step. Please follow below step to configure database server for bookshop.The first question postulation by manakin wizard is detailed configuration or standard configuration, standard configuration is one simply configuration way that configuration wizard will set all setting with default setting, but this setting cannot satisfy heave work loading of bookshop system, so, please choice detailed configuration, detailed configuration requires users to configure database server step by step, there are server type, database usage, data file location, users conjunction number, service port, character set, services install and root account setup. detect below step to modify setting for suitable with bookshop system.Server type have three options, they are developer machine, server machine, dedicated MYSQL server machine. Developer ma chine is one setting environment that provides for programmer to develop program and database, under this setting, MYSQL server will not use all o