ACKNOWLEDGEMENT

I would like to express my profound thanks to His Divine Soul Padmabhushan Sri Sri Sri Dr.
Balagangadharanatha MahaSwamiji and His Holiness Jagadguru Sri Sri Sri Dr. Nirmalanandanatha
MahaSwamiji for providing me an opportunity to pursue my academics in this esteemed institution.

I would also like to express my profound thanks to Reverend Sri Sri Sri Dr. Prakashnath Swamiji, Managing
Director, SJB Institute of Technology, for his continuous support in providing amenities to carry out this mini
project in this admired institution.

I express my gratitude to Dr. K VMAHENDRA C K, Principal, SJB Institute of Technology, for providing
an excellent facilities and academic ambience; which have helped me in satisfactory completion of mini
projectwork.

I extend my sincere thanks to Dr. Krishna A.N , Head of the Department, Computer Science and engineering;
for providing an invaluable support throughout the period of mini project work.

I wish to express heartfelt gratitude to my guides, Mrs. Anusha M, assistant professor, dept of CSE for their
valuable guidance, suggestions and cheerful encouragement during the entire period of this work.

Finally, I take this opportunity to extend my earnest gratitude and respect to my parents, Teaching & Non-
teaching staffs of the department, the library staff and all my friends, who have directly or indirectly supported
me during the period of this mini project work.
Regards,
Varshitha Bai D
(1JB19CS155)
Yashaswini P
(1JB19CS163)

i
 ABSTRACT

Development of web-based application has grown to a significance level that almost all organization
in paperless working environment. Nowadays, many organizations and agencies had developed from
manual system to computerized system. Online booking system does not only assist the facilities
unit to achieve higher quality but it also helps to simplify the booking process and raise the efficiency
in management. In the life of the software development, problem analysis provides a base for design
and development phase. The problem is analysed so that sufficient matter is provided to design a
new system. Large problems are sub-divided into smaller once to make them understandable and
easy for finding solutions. Same in this project all the task are sub-divided and categorized.

Book of Bliss is designed and the main objective of system is to provide a platform for book
borrowers and lenders. It will automate some of the basic operations of an online store. It also
provides subscription facility where only subscribed member can download and read the book.

Scope would be to provide basic functionalities using a web application so that those manual
processcan be automated. It will include to provide administration access to book owners, borrowers
and user specific access to customers.

All the information will be saved safely in the database. Any information needed can be retrieved
easily without any errors. The system is user friendly and error free. The data is maintained and
processed quickly providing user flexibility. The application developed is responsive and can be
accessed from laptops, mobiles and other variable screen devices rendering user comfort to use the
application kind.

ii
 TABLE OF CONTENTS
Acknowledgement i
Abstract ii
Table of contents iii-v
List of Figures iv-vii
List of tables vii

Chapter No. Chapter name Particulars Page No.

1-6
1.1 Traditional file system
1.1.1Pros and Cons of traditional approach
1.2 Introduction to DBMS
1.3 Indicative areas for the use of DBMS
1 Introduction
1.4 Advantages of DBMS
1.5 Components of DBMS
1.6 Problem statement
1.7 Scope

7
2.1 Hardware Requirements
2 Requirement Analysis
2.2 Software Requirements

3.1 WAMP 8-9

3.2 My SQL
Software Requirement
3 3.3 PHP
specifications
3.4 APACHE
3.5 SUBLIME
4.1 E.R Diagram 10-15
4.2 DFD (Data Flow Diagram)
4.2.1 DFD Level 0
4 Analysis and Design
4.2.2 DFD Level 1
4.2.3 DFD Level 1(admin)
4.3 Tables

iii
 4.3.1 Register table
4.3.2 Add category table
4.3.3 Add book table
4.4.4 Author table
4.4.5 Rent book table
4.5.6 Subscribe table
16-38
5.1 Create Table Commands
5 Implementation
5.2 Code snippet

6.1 Home 39-52

6.2 About us page

6.3 Registration page
6.4 Login page
6.5 Home Dashboard page
6.6 All categories page
6.7 New/Rent details page
6.8 My cart book page
6.9 Shipping Address details
6.10 Billing page
6.11 Payment page
6 Snapshots and Results
6.12 Admin login page
6.13 Admin Dashboard page
6.14 Add author page
6.15 View author page
6.16 Add category page
6.17 View category page
6.18 Add books page
6.19 View books page
6.20 View rent books request page
6.21 View rent books approved page

iv
 7.1 Test cases 53-63
7.2 Need of testing
7.3 Software testing
7.4 Goals of testing
7.5 Testing Methods
7.5.1 Bottom-up testing
7 Testing
7.5.2 Top-down testing
7.5.3 Black box testing
7.5.4 White box testing
7.6 Snapshots
7.7 Testcase tables

Conclusion 63

Bibliograph 64

LIST OF FIGURES
Fig No Figure name Page No.

1.1 Components of DBMS 5

4.1 E.R Diagram 10

4.1 DFD at level 0 of checking vaildity 11

4.2 DFD at level 0 of user login 12

4.3 DFD at level 1 12

4.4 DFD at level 1(Admin) 13

4.5 Register table 13

v
4.6 Add category table 14

4.7 Add book table 14

4.8 Author table 14

4.9 Rent book table 15

4.10 Subscribe table 15

6.1 Home page 39

6.2 About us page 40

6.3 Registration page 41

6.4 Login page 41

6.5 Home dashboard page 42

6.6 All categories page 42

6.7 New /rent details page 43

6.8 My cart book page 44

6.9 Shipping address details 45

6.10 Billing page 45

6.11 Payment page 46

6.12 Admin login page 46

6.13 Admin dashboard page 47

6.14 Add author page 47

6.15 View author page 48

6.16 Add category page 48

6.17 View category page 49

vi
 6.18 Add books page 50

6.19 View books page 51

6.20 View rent books request page 52

6.21 View rent books approved page 52

7.1 Register page test case-(name field) 56

7.2 Register page test case-(email field) 57

7.3 Register page test case-(contact field) 58

7.4 Register page test case-(password field) 59

7.5 Login page test case -(validation) 60

LIST OF TABLES
Table no. Table name Page no.

1.1 Indicative areas of DBMS 3

7.1 Testcase table of phone number 61

7.2 Testcase table of email 61

7.3 Testcase table of password 61

vii