In this paper, we are going to develop a website for the book store which is named as “Buy Your Books”. The development of the online bookstore helps the student to order book of their choice from the company. The development of the virtual book store provides the facility to the students and customers to search into the available catalogue to order books according to their requirement by sitting in their house only (Kumar, 2014). The renovation of the book store can be done with the development of the interactive online website for the store. They do not have to waste their time in search of the book in the local market. The owner of the book store had decided to increase their marketing with the implementation of the online book store with the name “Buy your books”.
Project objectives:
The objective of the project is to design a website for the ordering of the books through the medium of internet. This documentation helps in providing the technical specification of the website to give the clear idea about the construction of website pages. It helps in providing interactive website through which customers can directly order their books to be delivered at their door steps.
Deliverables of the project:
The project is designed to deliver the feasibility analysis of the proposed design, specification for establishing requirement of the owner of the book store, risks associated with the project development and others (Hu, 2014). The renovation of the book store can be done with the development of the interactive online website for the store (Johnsons, 2013). The organization of the processes should be done in the efficient manner of the effective deployment of the processes involved in the construction of the website.
Literature Review:
We have analysed that the development of the website involves the use of graphics and other visualization techniques for attracting customer towards their business for increasing the sale of the online book store (Kodali, 2007). From the research, it has been concluded that the in the world of digital innovation customers are getting attracted towards the online shopping. It has been searched that about 60% of the marketing stores have improved their turnover with the development of the online store (Hulagabali, 2012). The development of the online book store depends on the following factors:
Technical feasibility analysis: The PHP programming language is used for constructing the online web portal for the book store. The MySQL database is used for designing relational table for the website.
Operational Feasibility: The efficiency of the book store can be improved with the designing of the online website of the enterprise (Mummaneni, 2011). The information of the system can be controlled by accessing the information from the database. The strong password should be developed by using the password policies to make the privacy of the data. The handling of the order can be efficiently done with the development of the relational table for storing details of the order in the database.
Business requirement specification:
The ordering of the books can be efficiently done with the help of online book store by sitting in the house only. The students do not have to spend their precious time in searching for the books in the local market. The orders delivered to the door step of the student. The development of the website is designed for solving the following purposes:
The project is developed with the key idea to provide an online application for the owner of the book store to manage the details of the order placed and maintaining the accurate financial information. The functionality provided by the web application are categorised as admin information, menu option, user details, profile detail, cart management system, databases, and others.
Features:
Assumptions:
Constraints:
Functional Requirement of the website:
Particulars |
Description |
Login credentials |
The user can registered into their account by using their login credential details validated by the admin. |
Add and viewing of user cart |
The user can check their cart for ordering of the books |
Adding of customers |
The new customers can be added in to the database by filling their personal information to get login credential |
Editing of the order |
The user can edit their order according to their changing requirement |
Updating the status of the ordered books |
The status is changed according to the current status of the order in process or delivered |
Changing password |
The user can change their password according to their own need |
Particulars |
Description |
Adding, editing, deleting information of the user |
The information of the active user is kept updated and the inactive user is deleted |
Viewing of the order placed by the customers |
The admin can check the details of the order placed by customers |
Generation of the sale report |
The financial report generation helps in determining the turnover of the book store |
Non Functional Requirement:
Design of the project:
The development of the online book store depends on the effective utilization of the relational database for storing the required information of the customers and the books (Agal, 2013). The relational tables are developed for storing the data on the relational database.
Risks Identification Table:
Identification of the risks |
Type of the risks |
Probability |
Impact |
Mitigation plan |
Failure of the system |
Technical risks |
75% |
Catastrophic impact |
Management of the backup database |
Cost associated with the development of the complete system |
Economical Risk |
65% |
Critical situation |
Conducting meeting with the owner of the book store for estimating the cost of the project |
Limitation of communication with the owner of the book store |
Inefficiency in the project management planning |
65% |
Critical situation |
Clear specification of the issues |
Shortage of availability of efficient human resource |
Operational risks |
30% |
Negligible |
Selection of the expert human resource |
Incomplete specification of the requirement plan |
Business and operational risks |
70% |
Marginal |
Clear specification of the customer requirement |
Representation of the data model
The storage of required data is represented with the use of entity relationship diagram. The development of the ERD helps in demonstrating the clear perception of the relational database which is used for storing the information (Gopal, 2013). The following is the entity relationship diagram for the online book store
Representation of the process model
The process model is used for defining and representing the flow of data between different participating units for maintaining the completion of processes involved (Clay, 2013). The representation of the data flow is shown with the help of Data flow diagram. The DFD is composed of four symbols which are used for representing the flow of information which are categorised as Rectangles used for representing entities associated with the system, eclipses are used for admitting input and delivering output, arrows are sued for representing the data flow, and open ended rectangles are used for representing the data store (Atmojo, 2013).
Database Design
Categorise:
Column Name |
Type |
Size |
Id_Category |
Double |
8 |
Name |
Text |
30 |
Editorial Categories:
Column Name |
Type |
Size |
Id_EditorialCatgories |
Double |
8 |
Name |
Text |
30 |
Book Details:
Column Name |
Type |
Size |
Book_Id |
Double |
8 |
Name |
Text |
30 |
Author |
Text |
30 |
Price and cost |
Double |
8 |
Image_url |
Text |
200 |
Member Detail:
Column Name |
Type |
Size |
Member_Id |
Double |
8 |
Member_login |
Text |
100 |
First Name |
Text |
30 |
Last name |
Text |
30 |
Phone |
Double |
8 |
Address |
Text |
200 |
|
Text |
100 |
Order Details:
Column name |
Type |
Size |
Order_Id |
Long integer |
8 |
Book_ID |
Long integer |
8 |
Quantity |
Integer |
4 |
Project limitation:
There is a scope for future development in the proposed website. The linking and validation of the card type is not done with the bank at the development of this stage. We are looking forward to add more functionality to the admin portal to make the website more interactive. The multiple shopping of the books can be done.
Conclusion:
The development of the virtual book store provides the facility to the students and customers to search into the available catalogue to order books according to their requirement by sitting in their house only. The inefficiency of the traditional book store can be resolved with the development of online web portal for the book store. The financial report generation helps in determining the turnover of the book store.
References:
Agal, S. (2013). The design and implementation of an e-commerce site for online book sles. 1st ed. [ebook]. https://www.researchgate.net/profile/Sanjay_Agal/publication/259478827_Online_Book_Store/links/0046352c11063a8ca8000000/Online-Book-Store.pdf [Accessed 26 Sep. 2017].
Atmojo, R. (2013). Recommendation for development of online bookstore in Indonesia. 1st ed. [ebook]. https://thescipub.com/PDF/jcssp.2014.1522.1530.pdf [Accessed 26 Sep. 2017].
Clay, K. (2013). Price and non-price competition in the online book industry. 1st ed. [ebook]. https://www.heinz.cmu.edu/~kclay/papers/retail.pdf [Accessed 26 Sep. 2017].
Gopal, R. (2013). An study of factors affecting on online shopping behaviour of consumers. 1st ed. [ebook]. https://www.ijsrp.org/research-paper-0613/ijsrp-p1853.pdf [Accessed 26 Sep. 2017].
Hu, Y. (2014). Estimating the value of increased product variety at online booksellers. 1st ed. [ebook]. https://ebusiness.mit.edu/research/papers/176_ErikB_OnlineBooksellers2.pdf [Accessed 26 Sep. 2017].
Hulagabali, S. (2012). E-commerce: A study on selected Indian online bookstores. 1st ed. [ebook]. https://www.nkc.ac.in/uploaded_files/E-Commerce-Santosh%20C%20Hulagabali-Flipkart-Bookstores.pdf [Accessed 26 Sep. 2017].
Johnsons, E. (2013). A report on opening a new book shop. 1st ed. [ebook]. https://www.slideshare.net/ChocoLash/example-report-2 [Accessed 26 Sep. 2017].
Kodali, S. (2007). The design and implementation of an E-commerce site for online book sale. 1st ed. [ebook]. https://www.cs.iusb.edu/thesis/SKhodali_thesis.pdf [Accessed 26 Sep. 2017].
Kumar, S. (2014). Status and scope of online shopping. 1st ed. [ebook]. https://www.ijarcsms.com/docs/paper/volume2/issue12/V2I12-0036.pdf [Accessed 26 Sep. 2017].
Mummaneni, V. (2011). Online book store. 1st ed. [ebook]. https://people.cs.ksu.edu/~vamsim/vamsi_Report_Draft1.pdf [Accessed 26 Sep. 2017].
Muzumdar, P. (2014). Online bookstore- A new trend in textbook sales management for service marketing . 1st ed. [ebook]. https://www.aabri.com/manuscripts/11987.pdf [Accessed 26 Sep. 2017].
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order formOnce we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignmentAs soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download