DESIGN AND IMPLEMENTATION OF AN ONLINE BOOKSTORE MANAGEMENT SYSTEM (A CASE STUDY OF KANO PUBLIC LIBRARY IN NIGERIA (KPL)


DESIGN AND IMPLEMENTATION OF AN ONLINE BOOKSTORE MANAGEMENT SYSTEM (A CASE STUDY OF KANO PUBLIC LIBRARY IN NIGERIA (KPL)  

ABSTRACT

The main objective of the project is to create an online book store that allows users to search and purchase a book online based on title, author and subject. The selected books are displayed in a tabular format and the user can order their books online through credit card payment. Using this Website the user can purchase a book online instead of going out to a book store and wasting time. 

 There are many online book stores like Powell’s, Amazon which were designed using Html. I want to develop a similar website using .NET, SQL Server. 

 Online Book store is an online web application where the customer can purchase books online. Through a web browser the customers can search for a book by its title or author, later can add to the shopping cart and finally purchase using credit card transaction. The user can login using his account details or new customers can set up an account very quickly. They should give the details of their name, contact number and shipping address. The user can also give feedback to a book by giving ratings on a score of five. The books are divided into many categories based on subject like Software, Database, English, and Architecture etc. 

 The Online Book Store Website provides customers with online shopping through a web browser. A customer can, create, sign in to his account, place items into a shopping cart and purchase using his credit card details. 

 The Administrator will have additional functionalities when compared to the common user. He can add, delete and update the book details, book categories, member information and also confirm a placed order. 

 This application is developed using JSP, HTML 5, AND PHP Programming languages. The Master page, data sets, data grids, user controls are used to develop the Online Book store. 

TABLE OF CONTENTS

DECLARATION i

APPROVAL PAGE ii

ACKNOWLEDGEMENT iii

TABLE OF CONTENTS viii

LIST OF FIGURES ix

LIST OF ACRONYMS x

ABSTRACT xi

CHAPTER ONE 1

INTRODUCTION 1

1.0 Background of the Study 1

1.1Problem Statement 2

1.2 Objectives of the Project 2

1.2.1Main Objective 2

1.2.2 Specific Objectives 3

1.3 Scope of the Project 3

1.4Significance of the Study 3

1.5 Justification for the New System 4

1.6Limitations 4

1.7 Definition of Terms 4

CHAPTER TWO 5

LITERATURE REVIEW 5

2.0 Introduction 5

2.1Role of Information Technology in the Academic System 6

2.2 Data and Information 7

2.3Technology Enhance Computer Software Based Online Clearance System 8

2.4 Computer-Based Online Information System 9

2.5 Data Base 10

2.6 Communication Technology Used In Online Clearance System 13

CHAPTER THREE 14

RESEARCH METHODOLOGY 14

3.0 Introduction 14

3.1 Research Design 14

3.2 Population study 14

3.3 Source of data 14

3.4 Method of Data Collection 15

3.4.1 Oral interview 15

3.4.2 Study of Manual. 15

3.4.3 Evaluation of Forms. 15

3.5 General Analysis of Existing System 15

3.6 Choice of Development Tools 16

3.6.1 Operating System 16

3.6.2 Visual Studio 16

3.6.3 MySQL 17

3.7 System Requirements 17

3.7.1 Hardware Requirement 17

3.7.2 Software Requirements 17

3.8 Requirements specification 18

CHAPTER FOUR 20

ANALYSIS, DESIGN AND DEVELOPMENT 20

4.0 Introduction 20

4.1System Analysis 20

4.1.1Existing System 20

4.1.2Proposed new system 21

4.3 System design 22

4.3.1 Process modeling 22

4.3.2 Data modeling 23

CHAPTER FIVE 30

SYSTEM DESIGN, DEVELOPMENT AND PRESENTATION OF RESULTS 30

5.1 System Development 30

5.2 Results from testing and validation 30

5.2.1 System testing 30

5.2.2 Unit testing 30

5.2.3 Acceptance testing 31

5.2.4 System validation 31

5.2.4 Screen shots of testing and validation 32

5.3 Discussions 33

5.4Limitations 34

CHAPTER SIX 34

SUMMARY, RECOMMENDATIONS AND CONCLUSION 34

6.1 Summary 34

6.2 Conclusion 35

6.3 Recommendation 36

REFERENCES 37

APPENDICES 39

Appendix I: Department C# 39

Appendix II: Time Frame 43

Appendix III: Budget 44

LIST OF TABLES

Table 1: Minimum Hardware requirements 21

Table 2: Minimum Software requirements 21

Figure 3. Entity Relationship Diagram 24

Table 4. Department Table 28

Table 3: Department Table 27

Table 5. Comment table 28

Table 6: System Validation results 32

LIST OF FIGURES

Figure 1: Level 0 DFD diagram of the new system 23

Figure 2: Relationship between the students and clearance 25

Figure 3: Relationship between the department and the student 25

Figure 4: Screen shot 32

Figure 5: Clearance Interface 33

Figure 6: Students Clearance Details 33

LIST OF ACRONYMS

I.S : Information System 

IUIU : Islamic University in Uganda 

ANSI                          : American National Standard Institute

HTML : Hypertext Mark-up Language 

TPS : Transaction Processing System 

MIS : Management Information System 

DSS : Decision Support System 

ESS : Executive Support System 

TPS : Transaction Processing System 

CIMA : Chartered Institute of Management Accountants

OCMS : Online and Communication Management Systems 

Kbps : Kilo Byte per Sec

GHz : Giga Hertz

SQL : Structured Query Language

XML : Extended Markup Language

CSS : Cascading Style Sheet 

CHAPTER ONE

INTRODUCTION

1.0 Background of the Study

In the world of software development there lots of improvement in the area of Architectural design and principles. The philosophies and implementation details are changing as the people guiding the development of the application. In this fantastic and yet sometimes complex world of software development there are some tried and true architecture patterns  and software development guidelines employed by most architects. Also your design must have an ability to turn towards innovation instead of lending itself to common practices. Web services are one such area where architects must lean on their creative side and hope that their solutions are still successful. In this report we will explain an exciting voyage down the road of Web services application. From requirements to use cases, to database design, to component frameworks, to user interfaces, we will cover each and every aspect of system design required to build an application with collaborative Web services. The reason why we selected online Bookstore web service is everybody walking down the street has some idea about bookstores. The objective of this project is to develop an e- book store where books can be bought from the comfort of home through the Internet. 

An online book store is a virtual store on the Internet where customers can browse the catalog and select books of interest. The selected books may be collected in a shopping cart. At checkout time, the items in the shopping cart will be presented as an order. At that time, more information will be needed to complete the transaction. Usually, the customer will be asked to fill or select a billing address, a shipping address, a shipping option, and payment information such as credit card number. An e- mail notification is sent to the customer as soon as the order is placed.

1.1Problem Statement

The process of buying books from the small scale business requires that the customers must move with cash in which may be dangerous to their life.

Furthermore, for a graduating student to carry out his/her clearance from all these departments it normally takes a lot of time and a lot of processes and delay in clearing the students, Unavailability of some key staffs while processing clearance form, which leads student repeatedly visiting a particular office in other to sign his/her clearance form, Loss of vital document as the filing system is manual, Damage of document due to fire or rain incident, Illegal removal of forms by fraudulent staff leading to insecurity, Take a lot of time to retrieve a particular clearance form. Hence, it became important for computer software based automated clearance system to eliminate the shortcoming of the manual system in place. 

1.2 Objectives of the Project

1.2.1Main Objective

The main objective of the project is to create an online book store that allows users to search and purchase a book online based on title, author and subject.

1.2.2 Specific Objectives

To design an online bookstore management system

To analyze the problems in the existing system

To analyze the possible requirements for the new system

1.3 Scope of the Project

As a part of the preliminary study, the scope of the system has to be clearly outlined. This is useful for estimating the amount of effort required, the cost involved etc.

In any Bata store Purchase and Billing department play an important role to produce great image in market. We cannot think about an existence of an individual department only. Here the Purchase department deals with all the procedure regarding the purchase of the shoes from the party. Here the billing department deals with all the procedure regarding the sale of the shoed to the client.

During the purchase or billing procedure the Bata store will interact with the party or with the client as external entity and with other departments inside the environment of Bata store.

The boundaries of the system is the system is the boundary of the Bata store which encloses the different departments including the purchase and sale department which interact with the external entities as Party and Client.

1.4Significance of the Study

This project helps in several ways, increasing importance of e-commerce is apparent in the study conducted by researchers at the GVU (Graphics, Visualization, and Usability) Center at the Georgia Institute of Technology. In their summary of the findings from the eighth survey, the researchers report that “online shopping is taking off both in terms of the number of users shopping as well as the total amount people are spending via Internet based transactions". 

1.5 Justification for the New System

The new system was designed to solve problem affecting the manual system in use. It was designed use online thereby relieving both student and staff from much stress as experienced from the manual system.

This was the analyzing and storing of information either automatically or interactively, it made use of online access to internet. The proposed system also had some other features like.

⦁ Accuracy in handling of data 

⦁ Fast rate of operation and excellent response time. 

⦁ Flexibility, that is to say, it can be accessed at any time 

⦁ Easy way of back up or duplicating data in diskette in case of data loss. 

⦁ Better storage and faster retrieval system. 

⦁ Accessibility from any part of the world. 

1.6Limitations

This project covered some of the aspect of a computer software based online clearance system using Islamic University in Uganda as case study. 

However the following are the constraints: 

Time Constraints: Due to time constraints the web-page covers only clearance for various departments by the graduating student. 

Financial Constraints: Due financial constraints people cannot afford this kind of process online especially towards the cost of accessing the internet. Therefore, it costed a lot to develop a full web-based clearance system. 

Some documents were considered confidential and were not made available.

1.7Definition of Terms

Computer Network: Computer network is a system that connects two or more computers together using a communication link. 

World Wide Web: World Wide Web simply called “www” is the most important tool of the internet, it was created in the late 1980’s in Europe and was limitedly use in academics cycle. 

Clearances: Official certification of blamelessness trustworthiness or suitability for graduation and issue of certificate in degree course. 

File Transfer: Any kind of computer file can be sent via the internet from one internet user to another. Table of account in a spreadsheet, design by a graphic artist, music and sound files etc can all be exchanged in this way. 

Web Browser: this is special kind of software that processes hypertext mark-up language (HTML) document. In other words, a web browser is a computer program that interprets HTML command to collect, arranged and display the parts of a web page. 

Web Site: A web site is a collection of many interconnected web page organized by a specific college, organization company etc, containing web page (goods and commodities) on the internet. Web site is stored on web servers. There are many web sites and thousands of HTML pages on each web site. A web is a treasure of information and entertainment. 

Hyperlinks: Hyperlinks are highlighted words and phrase you find on a web document that you can click on as to jump to some other document or internet services. 

Online: connected via a computer attached to or available via a central computer network 

Offline: Disconnected from computer network, describe a computer terminal or peripheral devices disconnected from a computer network. 

System: Set of computer components that is, an assembling of hardware, software and peripheral functioning together. 

.


TYPE IN YOUR TOPIC AND CLICK SEARCH.






RESEARCHWAP.COM

Researchwap.com is an online repository for free project topics and research materials, articles and custom writing of research works. We’re an online resource centre that provides a vast database for students to access numerous research project topics and materials. Researchwap.com guides and assist Postgraduate, Undergraduate and Final Year Students with well researched and quality project topics, topic ideas, research guides and project materials. We’re reliable and trustworthy, and we really understand what is called “time factor”, that is why we’ve simplified the process so that students can get their research projects ready on time. Our platform provides more educational services, such as hiring a writer, research analysis, and software for computer science research and we also seriously adhere to a timely delivery.

TESTIMONIES FROM OUR CLIENTS


Please feel free to carefully review some written and captured responses from our satisfied clients.

  • "Exceptionally outstanding. Highly recommend for all who wish to have effective and excellent project defence. Easily Accessable, Affordable, Effective and effective."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I saw this website on facebook page and I did not even bother since I was in a hurry to complete my project. But I am totally amazed that when I visited the website and saw the topic I was looking for and I decided to give a try and now I have received it within an hour after ordering the material. Am grateful guys!"

    Hilary Yusuf, United States International University Africa, Nairobi, Kenya.
  • "Researchwap.com is a website I recommend to all student and researchers within and outside the country. The web owners are doing great job and I appreciate them for that. Once again, thank you very much "researchwap.com" and God bless you and your business! ."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I love what you guys are doing, your material guided me well through my research. Thank you for helping me achieve academic success."

    Sampson, University of Nigeria, Nsukka.
  • "researchwap.com is God-sent! I got good grades in my seminar and project with the help of your service, thank you soooooo much."

    Cynthia, Akwa Ibom State University .
  • "Great User Experience, Nice flows and Superb functionalities.The app is indeed a great tech innovation for greasing the wheels of final year, research and other pedagogical related project works. A trial would definitely convince you."

    Lamilare Valentine, Kwame Nkrumah University, Kumasi, Ghana.
  • "Sorry, it was in my spam folder all along, I should have looked it up properly first. Please keep up the good work, your team is quite commited. Am grateful...I will certainly refer my friends too."

    Elizabeth, Obafemi Awolowo University
  • "Am happy the defense went well, thanks to your articles. I may not be able to express how grateful I am for all your assistance, but on my honour, I owe you guys a good number of referrals. Thank you once again."

    Ali Olanrewaju, Lagos State University.
  • "My Dear Researchwap, initially I never believed one can actually do honest business transactions with Nigerians online until i stumbled into your website. You have broken a new legacy of record as far as am concerned. Keep up the good work!"

    Willie Ekereobong, University of Port Harcourt.
  • "WOW, SO IT'S TRUE??!! I can't believe I got this quality work for just 3k...I thought it was scam ooo. I wouldn't mind if it goes for over 5k, its worth it. Thank you!"

    Theressa, Igbinedion University.
  • "I did not see my project topic on your website so I decided to call your customer care number, the attention I got was epic! I got help from the beginning to the end of my project in just 3 days, they even taught me how to defend my project and I got a 'B' at the end. Thank you so much researchwap.com, infact, I owe my graduating well today to you guys...."

    Joseph, Abia state Polytechnic.
  • "My friend told me about ResearchWap website, I doubted her until I saw her receive her full project in less than 15 miniutes, I tried mine too and got it same, right now, am telling everyone in my school about researchwap.com, no one has to suffer any more writing their project. Thank you for making life easy for me and my fellow students... Keep up the good work"

    Christiana, Landmark University .
  • "I wish I knew you guys when I wrote my first degree project, it took so much time and effort then. Now, with just a click of a button, I got my complete project in less than 15 minutes. You guys are too amazing!."

    Musa, Federal University of Technology Minna
  • "I was scared at first when I saw your website but I decided to risk my last 3k and surprisingly I got my complete project in my email box instantly. This is so nice!!!."

    Ali Obafemi, Ibrahim Badamasi Babangida University, Niger State.
  • To contribute to our success story, send us a feedback or please kindly call 2348037664978.
    Then your comment and contact will be published here also with your consent.

    Thank you for choosing researchwap.com.