Introduction
The Best Publication Shop order to provide online services to boost profit and extend their marketing, they ask us to create one online bookshop system.
Internet shopping is an activity to permit consumers to purchase goods or services immediately from a retailer instantly, without intermediary services on the Internet. When there is an intermediary service is named e-commerce. An online shop, eshop, e-store, internet shop, webshop, webstore, online store, or Virtual store evokes the physical simulation to buy products or services in a brick and concrete retailer or retail center. This process is known as business to consumer (B2C) online shopping. When companies buy others, is known as the Business to Business (B2B) online shopping. B2C and B2B both by means of e-commerce online shopping.
In order to create bookshop system, we will visit simple online bookshop for feasibily research. Create project planning to control work flow, design this program and related repository system, we provides assembly guide and customer guide as the same time. We will show our use several documents, each file is dependent demonstrating their individual information. You will discover feasibily report, task planning, program design, installation guide and user guide. Open up those documents you can find what details we are working.
Feasibility study
Feasibility study is one important studying that to consider the job we go do or not. Feasibility study was to judge a proposal to look for the specific troubles of the task. Generally, the first feasibility studies and technology development tasks. Quite simply, the feasibility analysis, evaluation or examination of the actual impact of the proposed project.
In case of our own feasibility studying, first we will visit one popular online bookshop to get more information concerning this bookshop system, and then we use the information we gathered to analysis the feasibility to apply new online bookshop.
Amazon. com, Inc. is a US-based multinational e-commerce company. Headquartered in Seattle, Washington, which is the most significant online store, has nearly three times the runner-up Internet sales, Staples Company, by January 2010. Amazon. com, founded in 1994 and 1995 the business launched on the net. The company was formerly called Cadabra company, but the name has modified, people found that individuals sometimes notice the name of "body. " Amazon. com also selected this name because the Amazon is the world's largest river, therefore the name signifies large size, but also in part since it 'a', therefore the letter can look near the start of the list. Amazon. com started out as a web bookstore but soon diversified, advertising the DVD, CD, MP3 download, software applications, video games, electronics, clothing, furniture, food, gadgets and so forth. Amazon has generated split websites in Canada, Britain, Germany, France, Japan and China. In addition, it provides international delivery of some products in certain countries. 2009 survey found that Amazon is the UK's favorite music and video retailers, retailers and third overall.
The company began as a web bookstore, and the most significant brick and cement bookstores and email order catalog of catalogs might provide 20 million headings, one provides more online bookstore. Bezos company called "Amazon", the world's largest river. Since 2000, Amazon's identity can be an arrow leading from A to Z, on behalf of customer satisfaction (because it forms a teeth), one goal is to make each product in the alphabet.
Amazon was founded in 1994, in Washington Condition. July 1995, the business began to market its services, and the first booklet in amazon. com - Douglas Hofstadter's Liquid concepts and creative analogies: computer types of the essential mechanisms of Thinking. In 1996, it was reincorporated in Delaware. Amazon launched its IPO on May 15, 1997, trading companies Nasidake NYSE AMZN, in the original general population offering price of $ 18. 00 per share, USD ($ 1. 50 after stock split three in the overdue '90s).
Amazon's initial business plan was strange: the company will not expect earnings of 4 to 5 years. It's "slow" progress caused grievances from shareholders, the company has not reached success fast enough. When the Internet bubble burst, many e-companies went out of business, Amazon persevered and finally turned its first income in the fourth quarter of 2001: 500 million, or 1 cent per share, on profits over one billion U. S. dollars, but modest It is important to the profits of the business enterprise model can prove to be profitable. In 1999, Time magazine named Bezos Person of the entire year, recognizing the business's successful advertising of online shopping.
Amazon's products includes books, music CD, video tutorial and Movie, software, gadgets, kitchen resources, tools, garden and garden equipment, toys and games, baby equipment, clothing, Tiyuyongpin, food, rings, clocks and watches, health insurance and personal care products, cosmetics, musical equipment, clothing, industrial, technological products and groceries.
The company launched amazon. com public sale, the public sale Web service, in March 1999. However, it didn't take the chip on the market pioneer eBay's large market talk about. amazon. com auction followed by the release of a fixed-price market operations, zShops, 1999 9 months, and the now defunct Sotheby's / Amazon Assistance as amazon. com November. Amazon Auctions and zShops developed in to the market in 2001, launched a service to permit customers to market used books, Compact disk, Dvd movie and other products with new tasks. Today, the market's main competitor Amazon, eBay's 50 %. com service.
August 2005, Amazon started retailing its products in its brand ", smooth instances, " said the brand application, the label will be utilized for textiles, kitchen utensils, household goods. In March 2007 the company expanded to cover more brand applications for diverse list of goods and register a fresh design consisting of "letters to form words Hiramatsu letter O and space gaps appear in the" one o'clock "position. ". Reported by the hallmark grew to include items such as coloring, carpet, wallpaper, head of hair accessories, clothing, footwear, headgear, cleaning products and jewelry. September 2008, Amazon submitted under famous. USA Patent and Trademark Office has completed the review of the application, but Amazon has not yet received official registered name.
Amazon MP3, its own online music store, launched in america Sept 25, 2007, sales of MP3 format, download no digital rights management. This is the first available online DRM - free music of all four major record companies.
The domain amazon. com attracts travelers, at least 615 million U. S. us dollars, twice the 2008 variety of walmart. com. Amazon appeals to about 65 million customers to its site each month in the United States.
Amazon allows users to send responses to the page of each product. Reviewers rate the merchandise, must maintain a rating level in one to five celebrities. Amazon has an optional comment badge options that the true name of the reviewer (predicated on confirmed visa or mastercard bill) or that Reviewer is an assessment by acceptance.
Amazon. com customer reviews are supervised obscene, but allow negative reviews. Specter, the e book on amazon. com, describes how "when publishers and authors asked Bezos why the negative remarks will be printed amazon. com, defended his approach, saying that amazon. com is' taking a different way. . . We hope to enable each e book - good, bad, ugly truth. . . let loose '"(Sipeikete 132). Allegations have been made, Amazon has a poor evaluation of the selective deletion of related assignments, despite the views of Scientology conformity with the rules.
"Book Search" is a feature that allows customers to search for keywords in the written text in many catalogs directory. The function started out with 120, 000 game titles (or 33 million web pages of words) Oct 23, 2003. Presently about 25 million catalogs in the program. Amazon has about 130 publishers and allows the user to execute these searches.
In order to avoid copyright infringement, amazon. com does not return a machine-readable word e book. Instead, it results web pages that match a picture to prohibit printing, and proposed to limit the amount of pages within a user can access. Furthermore, customers can buy online usage of some of the same publication through the "Amazon Upgrade" program.
About forty percent from sales of the Amazon Amazon affiliate and internet affiliate marketing so-called third-party retailers who sell their products in Amazon [citation needed]. Customers associate commission payment described the Amazon Amazon link positioned on its Internet site, the results of the deal if the recommendation. In Shijiefanwei, the Amazon has "over 900, 000 members" in its affiliate marketer program. Amazon reported over 1. 3 million vendors sold products through Amazon's Site in 2007. Unlike eBay, Amazon retailers don't need to maintain separate payment accounts, payment processing of all the Amazon.
Employees can straight gain access to the catalog on its Internet site using Amazon Amazon Web Services (AWS) of the XML service. A fresh subsidiary products, aStore, the connection is inserted in a subset of Amazon products, or connect to another site. June 2010, Amazon launched product advice seller (reported to be internally referred to as "Genesis Project") to provide more transparency, vendor-specific products advised for sale to an authorized Amazon retailer. Product recommendations are based on customer's browsing record.
January 2010 study found that third-party suppliers Auctionbytes. com, Amazon fourth. amazon. com second "benefit. " The cheapest rating, but still above average, in the "ease of use. " Amazon vendor that clearly described rules, offers a steady blast of traffic list, with a focus on reducing part of the community. amazon. com emerged in second place in the sales suggestion category.
Focus on amazon. com bookshop system, there has several important features that people need to find out, first is clearly item catalog system, Amazon have many items are selling on their web site, such as catalogs, digital devices, shoes, clothes, Gadgets, etc. although there are too much items on bookshop system, it is very clearly and no problem finding, as once, Amazon give a powerful item search engine for user to find a common products. It is one feature that Amazon to draw in users sessions them and buy items.
Another important point is shopping cart system and member system. Amazon provides are powerful member system that each customer need create one member profile on Amazon. com for sale items and transfer payment. Trying to find Amazon's member system, it must have enterprise level data source server to aid large size copy and member record.
Shopping cart is one system on Amazon that we need to pay attention to. When user browsing and shopping on Amazon. com, if indeed they have some favour item they want to buy, they can input it into shopping cart software. Finally, they could go to shopping cart software page to check on what they had bought, if end user agree to to buy all items, they may direct transfer payment. If user's order has any change, they can remove any item from shopping cart software, that won't to pay extra demand and the quantity will real time change.
After studding Amazon. com, we live summation that online bookshop system is one good idea to develop. We are focus on marketing and technical.
In modern times, online shopping is becoming popular, but it still caters to upper middle class. For online shopping, must be able to have access to a computer, loan provider accounts and debit credit cards. Shopping has evolved with the progress of technology. It is discovered that e-commerce in the journal, if we focus on the demographic characteristics of purchasers in the family, in general, the higher the training level, income, profession of head of household, a far more favorable belief of non-store shopping. An influential element in consumer attitudes of non-store shopping is exposure to technology, since it has been proven to increase the probability of exposure to technology development to increase the favorable frame of mind of the new shopping channel.
Expanded the mark audience online shopping men and women of the middle class. Initially, the main users of online shopping is teenagers, high income level and school education. This profile is changing. For example, the early many years of the Internet in the United States there are extremely few women users, but to women in 2001 were 52. 8% of the web population.
Focus on technological of bookshop system, nowadays, hardware and software develop maturity for use to create powerful web encoding and data source system, we have a lot of preference to execute bookshop system, such as Windows server, Linux, Solaris, UNIX and AIX system for operating-system. Database systems have MYSQL, MSSQL and Oracle. CGI Development possessed PHP, Perl, C++ and Framework. Net. We are likely to choice wide open source resources. They are Linux, Apache, MYSQL and PHP. The benefit of available source resources are low priced for develop. It is very suited to us that people without too much develop capital.
Context diagram of the online book shop system
A context diagram is a data flow diagram, with only one substantial central process that subsumes everything inside the opportunity of the machine. It shows how the system will receive and send data flows to the external entities involved. The web publication shop system including three functions: customer, Company, and The best e book shop. Clients make an application for membership and can buy reserve online. The member function is mainly for purchasing publication online. When guest be a member of online book shop, they can buy view the publication detail and buy it online though credit-based card. The supplier provides book's information to the best e book shop, from then on, their book is a product of online book shop; they'll return income and book selling status. The very best e book shop mainly provides the online platform and keep maintaining for it.
Aim
The aim of the study program is to develop an online booklet shop. The objective 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.
Objectives
To create a user-friendly e-commerce website.
To provide different books for customer to choose
To create a web user interface for administrator usage of update publication store
To provide information of book
To installation the e book price and buy online
Dataflow of customer
The first step in the process of buying the product is to apply for regular membership. After listed, user's data will store in repository and only signed up member can see book detail and buy. Then, customer will choose their wish list and add in the cart, after that, the data will store in databases. While client click go to payment, it will redirect to payment gateway to process it. No matter what payment is success or not, the repayment gateway will return. If repayment success, booklet shop will make the delivery.
Dataflow of supplier
The online reserve shop will provide login and password to company. When dealer login in to the system, they can revise their book information and add some new book into the system. While published the data, the web reserve shop will approve or reject the product. If approved the product, the reserve will screen on the reserve store.
Dataflow of the best book shop
The best publication shop is the administrator of the web site; they offer maintain and upgrade product information. After administrator login into system, they will update the website data, approve the merchandise provide from company or download sales statement, purchase record else.
A picture below show an Entity Life Record for a member:
The Amount shows the entity life history for an associate. A member starts its life by a fresh member", and ends it by a "Close". When a member join the account and confirmed, it will start the member lift up routine ( purchase reserve the web site).
Introduction
Kent (1978) discussed that repository is a style of some facet of the reality of and corporation. A data model we can treat a database as an abstract machine. In other words, we can concentrate on the rules of design divorced from an immediate concern with execution.
There have three databases packages ideal for their website, relational data source, object -focused repository and Object-relational data source. The essential data composition of the relational model is the stand, thus all relations (tables) in a relational repository have to adhere to some basic rules to define as relations. An subject- oriented databases can be thought to provide a middle floor between relational repository and object-oriented database, this means it included with a programming API for storing and retrieving items, and little or no specific support for querying. An Object-relational database is a repository management system (DBMS) similar to a relational data source, but with an object-oriented data source model: items, classes and inheritance are straight supported in data source schemas and in the query terminology.
Three database plans would be ideal for the set up business directory site.
Relational Database
Edgar F. Codd (1970) invented the relational data source in 1970, relational databases are based on relational place theory which is the framework of a databases. A database is simply a collection of one or more relations or tables with columns and rows. Due to serials relationships of tables, Normalization is a essential component of relational model of repository. Normalization was a fundamental element of the relational model which improves complexity and handling.
Benefits of relational databases are that the system is simple, versatile, and productive. Because the desks are simple, data is simpler to understand and talk to others. Relational databases are adaptable because users don't need to use predefined tips to suggestions information. Also, relational databases are more fruitful because SQL is a fairly easy and human-readable terms. SQL instructions are in the form of plain instructions, that can be put to the data source for implementation. This allows users to invest more time inputting rather than learning. The other important advantages of relational databases include their performance, ability, and support to new hardware technologies as also flexibility and a capacity to meet all sorts of data needs. More importantly, relational data source biggest advantage is the simplicity with which users can create and gain access to data and expand it if needed
But there are limits to the relational databases management system. First, relational database don't have enough storage area to take care of data such as images, digital and audio/training video. The system was originally created to manage the integration of press, traditional fielded data, and templates. Another restriction of the relational data source is its inadequacy to operate with languages beyond SQL. Following its original development, languages such as C++ and JavaScript were made. However, relational databases do not work successfully with these dialects. A third limitation is the necessity that information must maintain tables where connections between entities are described by beliefs.
The three basic principles of your relational repository are that all information must be placed by means of a stand, where all data are described using data values. The second fundamental is that every value found in the table columns does not repeat. The final fundamental is the use of Standard Query Dialect (SQL), such as MYSQL or Microsoft's Access.
MYSQL Available from: http://www. mysql. com/ [Accessed 23 January, 2009]
Microsoft's Gain access to Available from: http://office. microsoft. com/en-us/access/default. aspx [Accessed 23 January, 2009]
Object- focused database
To fight the constraints of relational data source and meet the challenge of the increasing surge of the Internet and the net, object-oriented data source developed in the 1980s. The most important characteristic for object-oriented databases is the joining of object-oriented programming with databases technology, which gives an integrated application development system.
The object-oriented data source has many advantages and benefits. First, object-oriented is a far more natural thought process. Second, the described operations of these types of systems are not dependent on this database application running at a given instant. Third, users are permitted to define their own methods of usage of data and exactly how it will be represented. It can store more types of data, and gain access to this data, and far faster than relational databases. Another advantage of object-oriented database is the fact relationships are symbolized explicitly, it support large numbers of relationships between your objects.
However, object-oriented repository also has down sides or limitations. One disadvantage of relational repository is the fact it lacks a data model. There is also no current standard, since it is still regarded as in the development stages. Also there are unavailability of object-oriented CASE tools and misunderstandings with way too many different object-oriented development methods.
Object-oriented database use a query dialect called object query terms (OQL) to control and get data. thing query language facilitates thing referencing within dining tables. Items can be nested within objects. Python is an exemplory case of Object-oriented data source.
Python Available from: http://python. org/ [Accessed 23 January, 2009]
Object- relational database
Object-relational data source management systems grew out of research that happened in the first 1990s. It could cope with new types of data such as audio tracks, video, and image files that relational database were not equipped to handle. In addition, its development was the result of increased use of object-oriented and a huge mismatch between these and the DBMS software. Object-relational database are systems that "try to extend relational database systems with the efficiency essential to support a broader category of applications and, in many ways, provide a bridge between the relational and object-oriented paradigms. "
One benefit of ORDBMS is the fact that it allows organizations to continue using their existing systems, without having to make major changes. This is referred to as reuse. It gives rise to increased productivity both for developer and end-user Another advantage is the fact it allows users and programmers to start using object-oriented systems in parallel. Also, it able to deal with and query large and intricate applications.
Though Object- relational data source involve some advantages by the way of using object oriented features, it is also not fully fixing the problems. Object-oriented database involve some disadvantages like Complexity and SQL is currently extremely intricate thus query is hard to optimization.
Many SQL subject- relational repository are extensible with user-defined types and custom-written functions, such as Oracle.
Deploy a databases on the Internet
To deploy a database on the internet, we are in need of serial process to do it. The client side can use internet browser as tool to access the data source. The server side has to setup an internet server. Client sent the get to the server though web browser. When database preserved the record and it send back response though browser. Internet browser process all the repository action. We are able to build/design the internet site by using dreamweaver.
Window platform
We can install IIS as our web server in window platform. IIS support Active Server Pages (ASP) which really is a technology that allows you to make powerful and interactive web pages. ASP pages have extension. asp instead of. htm, whenever a page with the extension. asp is wanted by a web browser the web server is aware of to interpret any ASP comprised within the web page before sending the HTML produced to the internet browser. In this manner all the ASP is run on the internet server no ASP will ever be handed to the web browser. Access or SQL server can be use for databases.
Linux platform
Linux is a perfect program for installation web server. We are able to set up Fedora as our Operating-system package. Apache will be the best web server. This program side we can use PHP which really is a freeware for build up website. The database can use MYSQL as data source server, from the relational data source.
An Entity Romance Diagram of the web book shop
Entity Description
Entity Name: publisher
Descriptions: The safe-keeping of the publisher details.
Data Element Content:
id
name
username
password
date
Entity Name: book
Descriptions: The safe-keeping of publisher's publication.
Data Component Content:
Id
publisher_id
code
name
author
year
price
discount
stock
Entity Name: reserve_price
Descriptions: The storage area of book's price.
Data Aspect Content:
id
book_id
picture
sort
Entity Name: member
Descriptions: The safe-keeping of member data
Data Factor Content:
id
username
password
firstname
lastname
address
phone
Entity Name: member_order
Descriptions: The safe-keeping of member's order on website.
Data Factor Content:
id
member_id
price
date
Entity Name: member_order_detail
Descriptions: The safe-keeping of order's detail
Data Component Content:
id
member_order_id
book_id
quantity
The following furniture are in 1NF:
The following tables are in 2NF:
The following furniture are in 3NF:
Relationship Description between Entities
member & member_order & member_order_detail
The romance between three databases are someone to many, that means 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_details, but one member_order_details relate with one member_order only.
Publisher & publication & reserve picture
The marriage between three directories are someone to many, that means one publish will have one or many booklet records, but one book will have only 1 publisher. And each e book may have significantly more than one picture.
Member_order_details & book
The marriage between two databases are one to many, one and only one reserve record will in each member_orde_detail, but only 1 book will have significantly more than one member_order_information records.
Screen shot:
Home page
Book detail
Add to cart:
A Login Webpage:
Member subscription:
Search booklet:
Training Plan:
Step/Content
Time/Training Materials
I. Review (altogether)
A. [Training goal] Express the online e book system.
10 minutes
Whiteboard (as needed)
II. Summary (all together)
A. [Guide] Go through the system step-by-step.
B. [Training aims] Describe the function of the system.
C. [Importance] Review the software of the machine.
30 minutes
Handout
III. Demonstration (all together)
A. [Ideas] Plan using by using mnemonic acronym
B. [Steps] Review each function and the emphasis it covers
C. [Demonstrate] Q & A about what each step means
D. [Good examples] Format for Presenting Class
2-3 hours
Handout
IV. Exercise (small group)
A. [Applications] Practice in group
1-2 hours
Group discussion
V. Summarize
A. [Q & A] Ask for any improvement.
30 minutes
Whiteboard (as needed)
Installation Guide - Install MYSQL Repository Server
Once put into practice bookshop system, we are in need of create related repository for record information that create by bookshop system or source from users. Bookshop system is using MYSQL for backend database system, please visit http://www. mysql. com to find out more and download MYSQL DBMS software.
Fist visit http://www. mysql. com, you will see "download (GA)" on the top of the net page, click this button and the page of body will change to download information, scroll down the web page, you will get MYSQL Community Server, it'll show a short explanation and version no of this DBMS. Click "download" button (with red group remark on body) to enter in download MYSQL DBMS.
After enter download site, you will see different package of database system, you need to choice which operating-system for your databases server. For instance, if you work with house windows server, please choice Microsoft Windows, and there have 32bit is and 64bits version for end user install. We recommend download offer that with installation execute.
Directly double click the file you down load from mysql. com for MYSQL server installation, set up program will ask you question detail by detail to help you mount MYSQL DBMS directly into windows system, such as where you want to install MYSQL DBMS, and which aspect you want to install. We recommend you setup MYSQL on the main of the server that such as "C:\MYSQL" on home windows system. It is because it let individual better to operate and deal with data on repository system. And we recommend end user use "complete" solution to setup MYSQL, it make set up program install most of MYSQL DBMS component into the windows server, it reduce the challenge that we might need reinstall some components when MYSQL system survey something missing when system running. Please follow below pictures to create MYSQL DBMS.
Double click "mysql-essential-ver-win32. msi" that you downloaded from mysql. com
Straight frontward to DBMS
Click "Next"
We recommend choice "Complete" to let set up program to install all MYSQL components into house windows system.
Click "Install" to begin installation.
Waiting set up software copy record.
Install process competed, and program will request you to configure MYSQL server, we recommend configure it as the same time.
After setup method, now we will MYSQL database server configure wizard, it is one important method that it may affect databases server performance. The technique of database setting is as identical to installation treatment that setting repository step-by-step. Please follow below step to configure data source server for bookshop.
The first question asking by settings wizard is detailed settings or standard configuration, standard settings is one simply configuration way that configuration wizard will set all setting up with default environment, but this setting up cannot gratify heave work launching of bookshop system, so, please choice detailed configuration, detailed settings requires users to configure database server step-by-step, there are server type, database usage, data file location, users connection number, service slot, character set, services mount and root profile set up. Follow below step to modify setting for appropriate with bookshop system.
Server type have three options, these are developer machine, server machine, dedicated MYSQL server machine. Designer machine is one setting environment that delivers for programmer to develop program and database, under this environment, MYSQL server won't use most of memory space and CPU vitality for database working, it continues enough electricity for programmer for program coding and tests.
Dedicated MYSQL server machine is one setting up environment for one computer machine which it only have MYSQL data source server one services are working. In cases like this of placing, MYSQL will use most of CPU ability and memory space for push up repository working performance, It's the fastest mode of these server type setting up.
Server machine is a balance setting up environment, it well suited for some server they need to running MYSQL repository server, web server and backend CGI programming together. In this particular environment, MYSQL will measure CPU work fill of web server and CGI program to configure vitality use of self database services, it can make sure a whole lot services are jogging clean. Server machine is the setting that we recommend to choice for our bookshop system.
Database use is one environment to ask customer how to use the data source system, multifunctional database is one preparing that database include all query, evaluation, calculation and report function, well suited for large size and major database for data examination. Transactional data source only is one preparing that work more vitality for query first, but individual still can use data evaluation and data statement. Non-transactional repository only is one setting up limited to data query with research etc function. We recommend using transactional database method for bookshop system.
Data data file location is asking you where data document of database system storing to. IF computer machine without specific precise hard drive for storing data, we recommend choice default setting up "C:\MYSQL_DATA".
Services port environment, MYSQL provide function of query data record by network, so that it must provides one port amount for network services, sometime, we may modify port quantity for security concern. Which time, we recommend using default port amount 3306 for MYSQL service setting.
Character Place is one important setting up of data source, it control repository record information with which terms. Nowadays, a great deal of systems these are moving to international, multi words (Unicode) are most popular environment when setting data source.
Next, configure wizard will ask you mount glass windows service, it make house windows administrator can control MYSQL data source by home windows service panel. And settings wizard will require services name, default setting up "MYSQL" is most popular choice. Following this, wizard will ask you for root security password, please setup your own security password here.
Finish answers all setting up, the final level is creating data source system, presses do only and longing configuration wizard completes all process. When all procedure complete, press Finish complete database construction.
Installation Guide - Create Database
Since repository server installation success, you will need to storage data source information into server. Once you installed MYSQL database server, MYSQL management gaming console was already installed on system. Please run "C:\Program Data files\mysql\bin\mysql. exe -h localhost -u root -p" to run database management console. Console will require you to enter root security password, please type in the security password that you setup before. We had prepared MYSQL affirmation on bookshop unit installation package, please download and duplicate it on MYSQL management gaming console as follow step.
After create data source, tables and relationship, database were set up completed. And then, you need to build web server.
Enter root security password to login MYSQL management gaming system.
Create repository first
Create desk Book
Create table publication_picture
Create desk member
Create table member_order
Create stand member_order_detail
Create desk publisher
Create romance with different tables
Installation Guide
Web Server & PHP
You need to setup web server once database server setup complete. Web server is use to provide bookshop software for users and customers. Apache and IIS are most popular web server software. IIS are default service agency of home windows server series, and apache are always use on Linux platform. But sometimes, user may wish to provide web services on windows XP or House windows 7 platform, in those days, apache is a good solution for non server series.
Apache web server are one wide open source web services, individual can download source program on apache website http://www. apache. org. Please follow below step to download source program.
Visit http://www. apache. org, click "download" button on top right corner (red circle)
On download site, apache. org provide several mirror site for customer download, they will provide one reflection server that the nearest where you are, follow this link for best value and quickest download acceleration.
Enter download server, there have a list provide different version of apache server for different operating-system. There have four versions for windows, the several between those four variations is package openSSL or not and 32/64 bits option. Bookshop system provide online payment system, openSSL provides encrypt connection between server and client computer. It required by bookshop system.
After download then run the set up program, it will demonstrate version number and using contract, choose accept and click next then self-explanatory to setup apache server.
Next, setup program will show you some new feature of latest version apache server and request you complete domain name, server name and administrator's email, please fill those information that showing at above amount.
After that, installation program with ask you set up method, we recommend typical installation that program will install all of element, it make sure website running simple. Then, program will ask you locate of this program, default is C:\Program Files\Apache Group.
After answer all question, click install to let installation program copy and install document to machine, in the end of technique, program do you want to subject matter and click finish off to complete installation.
Bookshop system are one web basic program, which means that it not only require apache provide web services, a backend CGI program will be required by bookshop system too. PHP is the CGI program that bookshop system using. So, when complete setup apache web server, please installation PHP CGI runtime environment.
PHP is open up source CGI environment, user can download source program on PHP internet site http://www. php. net. Please follow below step to download source program.
Visit http://www. php. net, you can see stable releases on top right corner, click stable link to enter download site.
Enter download web page, php. net will list different version of PHP environment for different operating-system. We recommend customer download house windows binaries with installer (the link of red group)
Please run setup program when download complete, accept license agreement and click next to forward set up procedure.
After that, installer will ask for your setup location, and CGI running options, IIS FastCGI is using for Windows IIS web services, and also other CGI is using for apache and other web server program. You had installed apache and it match with Other CGI option.
Next, Installer will show the component and asking you for install to machine, we recommend backup extensions only because we wish PHP only doing work for web server, after select modules then click installs to start out coping data file to machine.
Finally, waiting for installer copy data file to machine, click carry out when installer complete install PHP runtime environment.
Now, most of components install success, we have to put into practice bookshop system. We provided one deal call "bookshop. rar", wide open with winrar or winzip, you might see the source program data, copy those program documents to apache server provide font end program. Details types of procedures please follow below numbers.
Open "bookshop. rar" by winrar or winzip, you can view the source program.
Go to Apache's folder (default is C:\Program Files\Apache Group\Apache2\htcdocs"), there involve some demo page designed by apache. org for administrator running simple test of web server, and today, delete all demonstration pages from this folder first.
Uncompress those sources file from "bookshop. rar" to apache's folder htdoc. After this step, all of install procedure complete, you can open bookshop system from your browser.
Use your browser visit http://localhost/staff/login. php to start bookshop management system, default login is "admin" and password is "advertising1234", we strongly recommend modifying admin password after login for security issue.
Use your web browser visit http://localhost/index. php to start bookshop forward end interface, this site provide catalogs catalog and catalogs information for customer visit and buy books.
If front side end software and back again end bookshop management system both jogging fine, installation treatment are totally completed.
Asking for ISP service provider revise DNS record to execute to internet.
User Guide
The online booklet shop can be an content management system. In most cases, content will refer to individual webpages, though additionally, it may include images, videos, and other styles of media. For now, we're just going to focus on written content.
Firstly, admin must login in to the system:
Menu
First, you access them through the machine. The left hand area is the search function, searching the booklet data and order on the kept side. Along with the right aspect is the info list. You can click edit and edit the data.
Books
Book management is a section to control the booklet stores. Again, you must assign each book to both a category otherwise it will not be kept.
There are a few options that e book have that the Categories don't and you could find those options in the variables boxes on the right-hand part of a fresh or Edit Article webpage.
A few shows:
You can choose the category start and end schedules.
You must type in book aspect data, such as name and price
Edit an book
When press the "Edit" button on the right part, it show additional information and customer allow to edit the info like below. Then you can edit the information like create an e book.
Delete a book
Click the delete button on the bottom, and an popup will ask if you wish to delete this book. Please note that if delete the publication, you must sure not order in control.
Add a category
When you gain access to them through the Category Manager. Then click on the create button and enter in the info such as category name, and click "save" to store the data.
In circumstance of book shop program development, we could pursuing system design life routine to allocate jobs to our associates. The benefit of system design life cycle is we can follow a standard system design method to design and build up out product with the right ways, right route. It could reduce a whole lot of thrown away time whenever we are lacking on some problem we strike. Different jobs information is wearing down as below:
First quest of program development is feasibility research, this mission has two breaking job, case study and feasibility evaluation, and first we have to analyze different similar book shop such as Amazon. com, 24reader. com, bookshop. hktdc. com and shopinhk. com for learning their feature, functioning method and accumulate useful information for program develop. After that we provides a feasibility record after studying and feasibility research. It can make sure the product is running easy and practical. Feasibility analysis requires one week adding into practice.
The second task is requirement research, collects requirement or advice from users, it can let us know what they need and what they want on the publication shop, we might be need to talk to several user, bookshop director, bookshop staffs, customers, after acquire requirement, doing evaluation to consider practicability and feasibility of these suggestion. I needed allocated four times for this job.
After requirement research is program evaluation and design, there have three major breakdown tasks and those have some breakdown missions. There are data source design, program design and bookshop layout design. We allocate total ten days for those tasks:
Database design, one of major part is database design, there have two malfunction missions, table marriage and normalization, those missions will work parallel and that want 5 days to fulfill. First, we analysis bookshop which of information need to record in data source system, such as publication name, editor name, company name, stocking, etc. Not merely design record information, databases table marriage is most important for database operating too. After planning, we need to do a normalization to make sure database without side effect when bookshop implement. The purpose of stocking information into data source system make simpler to upgrade information by users of bookshop by contact management system.
Program design, second major part is program design, there have four breakdown missions, there are entity diagram, context diagram, system move and data move. Different diagram demonstrating different information make evidently for coding. Entity romance model is a database modeling method, used to produce a kind of conceptual model or semantic data model systems, usually a relational data source, it needs a top-down fashion. Framework diagram is the best level of something, like the block diagram, exhibiting, may be predicated on the software, the machine as a whole, and its insight and productivity from / to external factors. System flow and data movement are one diagram that showing abstract computing handling by image, it make program flowing clearly showing to programmer, reduce develop problems. We allocate total 8 days for program design.
Layout Design, design design is the last major task of program analysis and design, the aim of task is planning bookshop layout, design will observe user requirement that we gather on before job. We allocate one day on this process.
After program research and design, we start program coding. There have three areas need to be create, SQL assertion coding, Program coding and Layout coding. SQL statement is using to create databases for storage data that using by program. SQL coding will observe databases design that on before process. Program coding is the primary function of the bookshop, the program will coding by PHP and program will follow system move and data movement that we had designed before. Layout coding follow designed layout to develop bookshop web software with HTML, Java script and CSS terms. Program coding are one quest that wit heave work weight, so, we allocate total 21 days (SQL declaration coding 5 times, program coding 14 days and structure coding 3 times. ) for programmer build-up program and doing self product test themselves.
If finish all of program unit and passed unit test, we will go to next method, integration test. Integration test will group all product programs we coding before to execute a test together. With this test, we will owning a bookshop program for demo, we will attempt to type some invalid data into system for insect discover. Stress test is important test too, we will try running system for a long period and we make an effort to make a whole lot of information query from web program and a lot of database process on system backend at exactly the same time for testing system running with heavy work loading. Stress test need additional time to achieve more accurate results, most of integration test need seven days adding into practice. After that, we will go to make prototype and report.
After integration test, we have to create prototype and writing document, we will generate some documents for users, such as install manual and customer guilds, to teach customer how to configure the bookshop system. We might create one web bottom part end user guilds for bookshop visitors too. We are in need of 2 weeks to doing those duties.
Finally, we doing system and approval test, in this responsibilities we doing test with customer, first, we provides doc to customer that people prepared before to teach them how to working system, maybe we provides program to customer at exactly the same time, from then on we will let users make an effort to configure and operating system, the advantage of this test is customer could find out some problems on the machine that they are using their viewpoints. After we make sure all parts running smooth, complete system running powerful and customer accepted all the environment, we will use the system. Most of system test require a week to complete.
