MSC PROJECT (3) Updated
MSC PROJECT (3) Updated
MSC PROJECT (3) Updated
BY
JITHIN VIJAYAN
2021-2022
-------------------------------------------------------------------------------
NO 53, Violet College Road, Menambedu, Ambattur, Chennai-600053
Phone: 26861611/26864684
1
ANNAI VIOLET ARTS AND SCIENCE COLLEGE
JITHIN VIJAYAN
------------------------------------ ------------------------------------
Mr.Samuel., MCA., M.Phil Mrs. Gladis Thanka Roobi MCA., M.Phil
------------------------------------------------------------------------------------------------------------------------
Submitted for the Viva-Voice Examination Held on At Annai Violet Arts and Science College,
Chennai-600053
------------------------------------------- -----------------------------------------------
2
ACKNOWLEDGEMENT
The success and final outcome of the project required a lot of guidance and assistance from many
people and I am extremely privileged to have got this all along the completion of my project. All
that I have done is only due to such supervision and assistance and I would not forget to thank them.
I respect and thank Dr. Initha LebanonEbency, Principal of Annai Violet Arts and
ScienceCollege for providing me an opportunity to do the project and giving as all support and
guidance which made me complete the project duly. I am extremely thankful to her for providing
such a nice support.
I wholeheartedly thank Mrs. Japhia Solomon, Vice principal of Annai Violet Arts and Science
college for all support and encouragement which motivated us to complete the project successfully.
I would not forget to remember Mrs. Gladis Thanka Roobi., MCA., M.Phil., Head of the
Department for her encouragement and more over for their timely support and guidance till the
completion of my project work
I owe my deep gratitude to my project guide Mr.Samuel.,MCA., M.Phil Assistant Professor who
took interest in my project work and guided me all along, till the completion of my project work by
providing all the necessary information for developing my project work
I am thankful to and fortunate enough to get constant encouragement, support and guidance from all
Teaching staffs and my friends of the computer science department which helped me in successfully
completing my project work.
Also, I would like to extend my sincere esteems to staff in the laboratory for their timely support.
JITHIN VIJAYAN
Enrol No:832000177
H.O.D
Table of Contents
3
CHAPTERS Page
No.
ABSTRACT 05
CHAPTER 1: INTRODUCTION 08
1.1 Background 08
1.2 Objectives 08
1.3 Purpose, scope and Applicability 08
1.3.1 Purpose 08
1.3.2 Scope 09
1.3.3 Applicability 09
1.4 Achievements 09
1.5 Organization of Report
CHAPTER 7: CONCLUSION 47
7.1 Conclusion 47
7.2 Limitation of the System4 47
7.3 Future Scope of the Project 47
References 48
Abstract
It’s a thing of massive gratification for us to present this Second Year Project Report on the project
CSE BOOK STORE.
Information Technology adoption is on the rise and recent technological innovation have
dramatically enhanced the capability of the organization performance leveraging the power of these
technologies , various business sectors are working together to offer a wide array of services
internal as well as external to the organization.
CSE BOOK STORE is a web based e-commerce application to support Environment sustainability
by selling used books. CSE BOOK STORE is based on idea to understand what customers want:
Fair price quotes, fast payment, good communication, excellent customer service, and an easy to
use website. By buying and selling used books CSE BOOK STORE will help to prevent waste and
to protect our environment.
CSE BOOK STORE has several advantages and it could be of immense help customers as it can
provide Effective Performance and Greater Economic Efficiency, improved and Secured Business
Transaction, Customers can check for order history, Wish list and Newsletters. Also, Users can
create their account for shopping as well as for making their own online library and check for book
publishers and read & write review comments.
5
CHAPTER 1: INTRODUCTION
6
CHAPTER 1: INTRODUCTION
1.1Background
Information Technology adoption is on the rise and recent technological innovation have
dramatically enhanced the capability of the organization performance leveraging the power of these
technologies , various business sectors are working together to offer a wide array of services
internal as well as external to the organization.
In this growing world, everyone wants to the access of knowledge and books play an important role.
However, books are help for us but making of books cost negative effects on environment. Hence,
CSE BOOK STORE application is as challenge for us because the idea behind scene is to help not
only human being but also environment.
1.2Objectives
CSE BOOK STORE is a web based e-commerce application to support environment sustainability
by selling used books. CSE BOOK STORE is based on idea to understand what customers want:
Fair price qotes, fast payment, good communication, excellent customer service, and an easy to use
website. By buying and selling used books My Book card will help to prevent waste and to protect
our environment.
1.3.1 Purpose
Our proposed solution to the problem is to provide the Book readers or sellers with better and more
efficient means of managing, marketing and keeping a record of books online. “CSE BOOK
STORE” is based on e-commerce where customer can sell any kind of books in more economic and
efficient way. Moreover, It will help customers and users to do improved and secured business
transactions.
1.3.2 Scope
Like any other application CSE BOOK STORE has a great scope of evolving in the future. The
application will also have a desktop widget which will show the current status of the book on the
desktop to prevent frequent login. Also a mobile version of the application is proposed which
would run on Windows Mobile platform which would enhance the portability as well as flexibility.
1.3.3 Applicability
7
necessary to have an account in CSE BOOK STORE. If users or customers won’t have any account
on CSE BOOK STORE then they get information about books but cannot by it. This feature is
implemented from the security prospects.
1.4 Achievements
CSE BOOK STORE provides the Customers with better and more efficient means of managing
land utilization and keeping a record of books. Technologies such as PHP: Hypertext
Preprocessor(a server-side scripting language designed for Web development but also used as a
general-purpose programming language) and HTML(Hyper Text Markup Language),
CSS(Cascading Style sheet), Java Script and Wamp Server have been used in building this
application. I got know about how data is fetched form Server and how server based application
works. Moreover, I was working on a completely new platform to implement new idea.
Successfully completing my idea is a biggest achievement for me.
1.4Organization of Report
This is project report contains information regarding CSE BOOK STORE Application. Report has
covered all the points as how do we get idea of implementing CSE BOOK STORE application.
Hardware and software requirement for implement and running web application followed by use
case diagrams, class diagrams, E-R diagram, Activity diagram and Collaboration diagram.
Moreover, project report has also covered unit and integration test cases which are run during
testing of application to ensure the quality. At the end of report, appendix and reference books &
site are added which were used during coding and implementation of application.
8
CHAPTER 2: SURVEY OF TECHNOLGIES
9
CHAPTER 2: SURVEY OF TECHNOLGIES
CSE BOOK STORE is based on MVC (Model- View- Controller) architecture. The information is
presented through a rich user interface experience, using
PHP :
HTML:
JAVA SCRIPT :
CSS:
10
CHAPTER 3: REQUIREMENTS AND ANALYSIS
11
CHAPTER 3: REQUIREMENTS AND ANALYSIS
3.1 Problem Definition
The theme that we have opted for is “Web based centralized system”. The main objective of
making “CSE BOOK STORE” is to provide a platform to customers where they can experience a
effective performance of selling books to anyone followed by improved business transactions.
CSE BOOK STORE provides the Customers with better and more efficient means of online book
shopping and wide range of books from all over the world. Technologies such as PHP: Hypertext
Preprocessor(a server-side scripting language designed for Web development but also used as a
general-purpose programming language) and HTML(Hyper Text Markup Language),
CSS(Cascading Style sheet), Java Script and Wamp Server have been used in building this
application. Main requirements involve :
1. Design of Admin page
2. Design of Home page
Admin page will cover all the aspect like managing, maintenances as well as flow of selling of
books. While Home page will involve interaction with user in user friendly manner and home page
will cover all the aspects such as My Account, Information, Extras and Customer Services.
12
3.3 Planning and Scheduling
GANTT CHARTS
No. Of Days
0 10 20 30 40 50
Task
Software Requirements
1. Windows 7 Ultimate
2. IE8/Firefox/Safari
3. Web Server (preferably Apache)
4. PHP (at least 5.2)
5. MySQL
6. Curl
Common Tasks:-
Our study showed us that it would be really difficult for us to develop a “CSE BOOK STORE with
all features due to the time constraint as well as provide facility of e-commerce because for e-
commerce, admin requires internet certifications. The functionality that we were going to
implement in our “CSE BOOK STORE Application” are home screen and admin page, mobile
simulator for using application on mobile and desktop widget.
15
DATA FLOW DIAGRAM
1. Data Flow
An arrow represents data flow; it represents the path over which data travels in the system? A data
flow can move between processes, flow into or out of data stores, to and from external entities.
2. Bubbles (Process)
A circle or bubble represents that transforms data from once form to another by performing some
tasks with the data.
3. Data store
A data store is a place where data is held temporarily from one transaction to the next or is stored
permanently.
4. Entity
External Entity symbol represents sources of data to the system or destinations of data from the
system
CLASS DIAGRAM
16
A class diagram is used to support functional requirement of system. The class diagram used to
model the vocabulary of the system.
17
A use case shows a set of use cases, actors and their relationship. The use case diagram make
system and classes approachable by presenting an outside view of how the elements may be used in
context.
Admin
General User
Shopping
cart
Wish List
My Account
Review/
Information Comment
Home Screen
Order History
<<include >>
Registered Customer
User Service
<<include >>
Extras
Shopping
Fig 6. Use Case Diagram
cart
E-R DIAGRAM
18
1. Entity
Entity has a set of attribute whose value is uniquely, identify the entity or distinguish the
entityfrom the other thingor entity in the world.
2. Attribute
3. Relationship
4. Derived Attribute
Any attribute which is derived from the relationship is called derived attribute.
5. Cardinality
Cardinality refers to the multiplicity of the entities. How many entity are actually engaged in the
relationship
Types of cardinality:-
1. Many to 1
2. 1 to 1
3. 1 to Many
4. Many to Many
19
COLLABORATION DIAGRAM
Admin
Shopping cart
General User
Review/comment
Extras
Customer service
ADMIN Login
Registered User
Statistics
20
ACTIVITY CLASS DIAGRAM
Activity diagrams are graphical representations of workflows of stepwise activities and actions
with support for choice, iteration and concurrency.
Invalid
user name N If U=PS3
and &
Password
Shopping cart
If
Registered
Useer
Wish List
Add to cart
Login
NPage
Review
Comment
If U=PS3
&
21
My Account Information Extras Customer
Service
Y
Y
If
If My information is Y
account is selected
selected
N N
Login page Y
for Y About us, If Extras
unregistered Delivery is selected
user information
for
unregistere
Wish list, Delivery in
d user
Oder for and
History, policy for N
My registered Y
account user
details Home
will be screen
displayed
Options will
be displayed
STOP
22
CHAPTER 4: SYSTEM DESIGN
23
CHAPTER 4: SYSTEM DESIGN
4.1Basic Modules
CSE BOOK STORE is a web based e-commerce application to support Environment sustainability
by selling used books. CSE BOOK STORE is based on idea to understand what customers want:
Fair price quotes, fast payment, good communication, excellent customer service, and an easy to
use website. By buying and selling used books
6. Login of Administrator.
Administrator module is responsible for managing sales, orders, transactions done by customers. By
means of this admin can evaluate total sales and eventually profit drawn from the website which
makes the website economical and profitable.
7. Login of Registered User.
A registered user can search books, add books to wish list, select books from wish list and add to
shopping cart, check out books from cart and make order and payment of books through Book Cart
8. Register of new account.
New User can save own information by means of database of website so that user’s identity is kept
protected for secure browsing and buying.
9. My account information.
My account information alloes user to edit own information and shop in the website using a secure
ID for ensuring privacy and avoiding theft activities.
10. Search of book list by keyword.
By searching user can shortlist the useful books and select from the search result.
11. Management of wish list by registered user.
Wish list comprises of one more round of shortlisting of books from various modules available in
the website
Wish list comprises of one more round of shortlisting of books from various modules available in
the website. The best thing is that you need not be registered to select books and add to wish list.
13. Management of shopping cart by registered user.
Shopping cart lists the books selected to buy by the user. One needs to register to buy a book.
15. Check out of books from shopping cart.
Check out functionality is to buy selected books from the cart after successful regsiteration.
24
16. Logout of registered user.
For a secure connection and browsing, exit functionality is implemented.
4.2Data Design
Designing data is about discovering and completely defining your application's data characteristics
and processes.
CSE BOOK STORE has been entrusted with sensitive, personal data to accomplish its goals. The
success of CSE BOOK STORE depends on the availability, integrity and confidentially of data.
One of the mechanisms to protect data is to implement data integrity and validation controls. Data
integrity controls are used to protect data from accidental or malicious alteration or destruction and
to provide assurance to the user that the information meets the expectations about its quality and
that it has not been altered. Validation controls refer to tests and evaluations used to determine
compliance with security specifications and requirements. To maintain data integrity, I have used
following validations in my code.
1) Reporting errors so that users can contact the account holder and correct, prior to submission.
This saves on unnecessary bank charges for failed transactions.
2) Map a CSE BOOK STORE account holder with a personal ID number or company registration
number
3) Rest assured that the correct legal entity is being debited or credited
4) Check that the information as provided by your client is correct, current and valid
5) Document-type declaration (DTD) must be declared for CSE BOOK STORE.
6) HTML and CSS validations are used so that correct HTML page should be displayed.
7) Only authorized uses can buy books from CSE BOOK STORE.
8) Each user has customer ID created in Database. This id is a email id of user
9) Guest users have separate entry in data bases so that proper record can be maintain.
10) User has to accept privacy policy before performing any transactions.
11) In Registration account, all mandatory fields should be filled before submitting account.
25
26
Fig 12. Home Page
27
Fig 14. Check out Page
28
Fig 15. Admin Login Page
29
4.5 Security Issues
1. Hackers can install malware that gets CSE BOOK STORE site
banned from Google and your customer details exposed to
cybercriminals
2. Problems with passwords
Most systems use passwords to restrict access. It is possible to obtain a password in several ways:
guessing
If you choose a particularly simple password (your mother's maiden name, your pet's name,
your favorite sports team) then people may be able to guess the password
brute-forcesearch
There are programs which can try many passwords, for example by going through every word in
a dictionary
social engineering
It is often possible to trick people into revealing passwords, for example by phoning up and
pretending to be the Internet service provider or a member of the company
obtaining stored passwords
Sometimes people store passwords on their computer, on post-it notes, in their diary, etc. In this
case, the password can easily be obtained by somebody with physical access
obtaining shared passwords
When the same password is used for several systems, anybody who obtains the password for
one system already has it for all others
installing trojans
There are 'trojan horse' software programs which install invisibly on your computer, monitoring
keystrokes. These are often associated with computer viruses
interception
If passwords are sent across an unencrypted connection, it may be possible to intercept the
password as it is transmitted (this is usually a relatively low risk)
Choose a password that is reasonably long (at least 8 characters) and is not made up of simple
words. Use punctuation and numbers if possible
31
Test
S.N Descriptio Pre- Expected Actual
Case Steps Status
o n condition Result Result
ID
TC_1 Verify 1.Applicatio 1. Start “Home” Same as Pass
functionalit n should be browser. page Expected
y of added in 2. Enter should be
“Home Wamp server url displayed.
1. “button folder. 3. Tap on
2. Home “Home”
screen button
should be
displayed
TC_2 Verify 1.Applicatio 1. Start “Account Same as Pass
functionalit n should be browser. Login” Expected
y of “wish added in 2. Enter page
list” button Wamp server url should be
2. folder. 3. Tap on displayed.
2. Home “Wish
screen List”
should be button
displayed
TC_3 Verify 1.Applicatio 1. Start “Account Same as Pass
functionalit n should be browser. Login” Expected
y of “My added in 2. Enter page
Account” Wamp server url should be
3. button folder. 3. Tap on displayed.
2. Home “My
screen Account”
should be button
displayed
TC_4 Verify 1.Applicatio 1. Start Shopping Same as Pass
functionalit n should be browser. cart” page Expected
y of added in 2. Enter should be
“Shopping Wamp server url dplayed.
4. cart” folder. 3. Tap on
button 2. Home “Shoppin
screen g cart”
should be button
displayed
TC_5 Verify 1.Applicatio 1. Start “Checkou Same as Pass
functionalit n should be browser. t” page Expected
y of added in 2. Enter should be
“Checkout Wamp server url displayed
5. ” button folder. 3. Tap on
2. Home “Checkou
screen t” button
should be
displayed
6. TC_6 Verify 1.Applicatio 1. Start “Register Same as Pass
functionalit n should be browser. Account” Expected
y of added in 2. Enter page
“Create an Wamp server url should be
account” folder. 3. Create displayed.
32
button 2. Home an
screen account”
should be button
displayed
TC_7 Verify 1.Applicatio 1. Start “Account Same as Pass
functionalit n should be browser. Login” Expected
y of added in 2. Enter page
“Login” Wamp server url should be
7. button folder. 3. Tap on displayed.
2. Home “Login”
screen button
should be
displayed
TC_8 Verify 1.Applicatio 1. Start Currency Same as Pass
functionalit n should be browser. should be Expected
y of added in 2. Enter changed
“Currency” Wamp server url to
8. button folder. 3. Tap on dollor/pou
2. Home currency nd/euro
screen “Dollar/P
should be ound
displayed Euro”.
33
CHAPTER 5: IMPLEMENTATION AND TESTING
34
CHAPTER 5: IMPLEMENTATION AND TESTING
CSE BOOK STORE application is a web based application which requires to review and test a
code every time so that quality and expected result can be obtained from efficient code
implementation. Hence, We used waterfall model for the implementation of this project so that
proper project can be implemented under guidance.
Requirements
Design
Implementation
Verification
Maintenance
The waterfall model is a sequential design process, often used in software development processes,
in which progress is seen as flowing steadily downwards (like a waterfall) through the phases of
Conception, Initiation, Analysis, Design, Construction, Testing, Production/Implementation, and
Maintenance. The waterfall development model originates in the manufacturing and construction
industries; highly structured physical environments in which after-the-fact changes are prohibitively
costly, if not impossible. Since no formal software development methodologies existed at the time,
this hardware-oriented model was simply adapted for software development
35
5.2 Coding Details and Code Efficiency
Registration Screen:
registration.php
<?php
class Controller Account Register extends Controller {
private $error = array();
$this->language->load('account/register');
$this->document->setTitle($this->language->get('heading_title'));
$this->document->addScript('catalog/view/javascript/jquery/colorbox/jquery.colorbox-min.js');
$this->document->addStyle('catalog/view/javascript/jquery/colorbox/colorbox.css');
$this->load->model('account/customer');
$this->customer->login($this->request->post['email'], $this->request->post['password']);
unset($this->session->data['guest']);
$this->redirect($this->url->link('account/success'));
}
36
$this->data['breadcrumbs'] = array();
$this->data['breadcrumbs'][] = array(
'text' => $this->language->get('text_home'),
'href' => $this->url->link('common/home'),
'separator' => false
);
$this->data['breadcrumbs'][] = array(
'text' => $this->language->get('text_account'),
'href' => $this->url->link('account/account', '', 'SSL'),
'separator' => $this->language->get('text_separator')
);
$this->data['breadcrumbs'][] = array(
'text' => $this->language->get('text_register'),
'href' => $this->url->link('account/register', '', 'SSL'),
'separator' => $this->language->get('text_separator')
);
$this->data['heading_title'] = $this->language->get('heading_title');
$this->data['entry_firstname'] = $this->language->get('entry_firstname');
$this->data['entry_lastname'] = $this->language->get('entry_lastname');
$this->data['entry_email'] = $this->language->get('entry_email');
$this->data['entry_telephone'] = $this->language->get('entry_telephone');
$this->data['entry_fax'] = $this->language->get('entry_fax');
$this->data['entry_company'] = $this->language->get('entry_company');
$this->data['entry_customer_group'] = $this->language->get('entry_customer_group');
$this->data['entry_company_id'] = $this->language->get('entry_company_id');
$this->data['entry_tax_id'] = $this->language->get('entry_tax_id');
$this->data['entry_address_1'] = $this->language->get('entry_address_1');
$this->data['entry_address_2'] = $this->language->get('entry_address_2');
$this->data['entry_postcode'] = $this->language->get('entry_postcode');
$this->data['entry_city'] = $this->language->get('entry_city');
$this->data['entry_country'] = $this->language->get('entry_country');
$this->data['entry_zone'] = $this->language->get('entry_zone');
$this->data['entry_newsletter'] = $this->language->get('entry_newsletter');
$this->data['entry_password'] = $this->language->get('entry_password');
37
$this->data['entry_confirm'] = $this->language->get('entry_confirm');
$this->data['button_continue'] = $this->language->get('button_continue');
if (isset($this->error['warning'])) {
$this->data['error_warning'] = $this->error['warning'];
} else {
$this->data['error_warning'] = '';
}
if (isset($this->error['firstname'])) {
$this->data['error_firstname'] = $this->error['firstname'];
} else {
$this->data['error_firstname'] = '';
}
if (isset($this->error['lastname'])) {
$this->data['error_lastname'] = $this->error['lastname'];
} else {
$this->data['error_lastname'] = '';
}
if (isset($this->error['email'])) {
$this->data['error_email'] = $this->error['email'];
} else {
$this->data['error_email'] = '';
}
if (isset($this->error['telephone'])) {
$this->data['error_telephone'] = $this->error['telephone'];
} else {
$this->data['error_telephone'] = '';
}
if (isset($this->error['password'])) {
$this->data['error_password'] = $this->error['password'];
} else {
$this->data['error_password'] = '';
}
if (isset($this->error['confirm'])) {
$this->data['error_confirm'] = $this->error['confirm'];
} else {
$this->data['error_confirm'] = '';
}
if (is_array($this->config->get('config_customer_group_display'))) {
$customer_groups = $this->model_account_customer_group->getCustomerGroups();
38
foreach ($customer_groups as $customer_group) {
if (in_array($customer_group['customer_group_id'], $this->config-
>get('config_customer_group_display'))) {
$this->data['customer_groups'][] = $customer_group;
}
}
}
if (isset($this->request->post['customer_group_id'])) {
$this->data['customer_group_id'] = $this->request->post['customer_group_id'];
} else {
$this->data['customer_group_id'] = $this->config->get('config_customer_group_id');
}
// Company ID
if (isset($this->request->post['company_id'])) {
$this->data['company_id'] = $this->request->post['company_id'];
} else {
$this->data['company_id'] = '';
}
// Tax ID
if (isset($this->request->post['tax_id'])) {
$this->data['tax_id'] = $this->request->post['tax_id'];
} else {
$this->data['tax_id'] = '';
}
if (isset($this->request->post['address_1'])) {
$this->data['address_1'] = $this->request->post['address_1'];
} else {
$this->data['address_1'] = '';
}
if (isset($this->request->post['address_2'])) {
$this->data['address_2'] = $this->request->post['address_2'];
} else {
$this->data['address_2'] = '';
}
if (isset($this->request->post['postcode'])) {
$this->data['postcode'] = $this->request->post['postcode'];
} elseif (isset($this->session->data['shipping_postcode'])) {
$this->data['postcode'] = $this->session->data['shipping_postcode'];
} else {
$this->data['postcode'] = '';
}
if (isset($this->request->post['city'])) {
$this->data['city'] = $this->request->post['city'];
39
} else {
$this->data['city'] = '';
}
if (isset($this->request->post['country_id'])) {
$this->data['country_id'] = $this->request->post['country_id'];
} elseif (isset($this->session->data['shipping_country_id'])) {
$this->data['country_id'] = $this->session->data['shipping_country_id'];
} else {
$this->data['country_id'] = $this->config->get('config_country_id');
}
if (isset($this->request->post['zone_id'])) {
$this->data['zone_id'] = $this->request->post['zone_id'];
} elseif (isset($this->session->data['shipping_zone_id'])) {
$this->data['zone_id'] = $this->session->data['shipping_zone_id'];
} else {
$this->data['zone_id'] = '';
}
$this->load->model('localisation/country');
$this->response->setOutput($this->render());
}
$json = array(
'country_id' => $country_info['country_id'],
'name' => $country_info['name'],
'iso_code_2' => $country_info['iso_code_2'],
'iso_code_3' => $country_info['iso_code_3'],
'address_format' => $country_info['address_format'],
'postcode_required' => $country_info['postcode_required'],
'zone' => $this->model_localisation_zone->getZonesByCountryId($this->request-
>get['country_id']),
'status' => $country_info['status']
);
}
$this->response->setOutput(json_encode($json));
}
}
?>
40
?>
The View however, knows about the Model. It will poll the Model about the state, to know what to
display. That way, the View can display something that is based on what the Model has done. But
the View knows nothing about the Controller.
The Controller knows about both the Model and the View. To take an example from a game: If you
click on the "fire" button on the mouse, the Controller knows what fire function in the Model to
call. If you press the button for switching between first and third person, the Controller knows what
function in the View to call to request the display change.
The reason to keep it this way is to minimize dependencies. No matter how the View class is
modified, the Model will still work. Even if the system is moved from a desktop operating system to
a smart phone, the Model can be moved with no changes. But the View probably needs to be
updated, as will the Controller.
- Synchronized views :
The change propagation mechanism insures that all views simultaneously reflect the current state of
the model.
Like any other application CSE BOOK STORE has a great scope of evolving in the future. The
application will also have a desktop widget which will show the current status of the book on the
desktop to prevent frequent login. Also a mobile version of the application is proposed which
would run on Windows Mobile platform which would enhance the portability as well as flexibility.
42
CHAPTER 6: RESULT AND DISCUSSION
43
CHAPTER 6: RESULT AND DISCUSSION
Diagram above is the home screen of CSE BOOK STORE Application. It has following parts:
1. Search
2. Currency
3. Create an account and login
4. My Account
5. Wish list
6. Shopping cart
7. Checkout
8. Featured
9. Publisher
10. Information
11. Customer Service
12. Extras
13. My account
1. Search : User can search for any book by entering text in search field and corresponding search
result will be displayed.
44
2. Currency : There are three different types of currency converter are displayed.
(a) Euro
(b) Pound
(c) Dollor
By default, all prices will be displayed in dollor. By clicking any of the
above currency, user can see desired currency format.
3. Create an account and login : If users are not registered then to do shopping , they need to
register themselves. When user click on create an account then Registration page will open and
all information will be stored in database. If users are already registered then they need to click
on login where they can enter username and password for shopping.
4. My Account: By clicking on My account, users can do login and see their purchase history .
5. Wish List: It could be possible that users cannot get books for which they looking for. By
clicking on wish list, users can add their desired books and CSE BOOK STORE admin will
inform him through mail that book can be arranged or not.
6. Shopping cart: When users click on shopping cart then it will indirect to a page where users
can see shopped items and by clicking continue button, users can complete shopping process.
7. Checkout: When users will click on checkout button then it will indirect to checkout page from
where they can continue shopping.
9. Publisher: It will display list publishers whom books are available on CSE BOOK STORE. By
clicking on any publisher, it will display corresponding publisher’s page and books.
About us: About us page will contain information about CSE BOOK STORE.
Delivery information : Delivery information page will contain information about delivery
reports.
Privacy policy: Privacy policy page will contain policies that CSE BOOK STORE follow
to maintain integrity and confidentiality of data.
Terms & Conditions: This page will include terms and conditions that users have to follow.
Contact us: If users want to contact with CSE BOOK STORE admin then they can click on
Contact us to get contact details.
Returns: If users want to return book then they need to fill their details in Returns page.
Site map: Site map will display the locations where CSE BOOK STORE office is available.
45
12. Extras: Extras page contains following links:
Brands: By clicking on brands link, users can get info about brands which support CSE
BOOK STORE site.
Gift Vouchers: By clicking on Gift voucher link, users can get info about Gift vouchers
available for shopping.
Affiliates: By clicking on affiliates link, users will redirect to affiliated .
a. Specials: This page will info about special books and events.
My Account: By clicking on My account, users can do login and see their purchase
history .
Order History : Users can get to know about their order history by clicking on order
history.
Wish list: It could be possible that users cannot get books for which they looking for. By
clicking on wish list, users can add their desired books and CSE BOOK STORE admin will
inform him through mail that book can be arranged or not.
Newsletter: This page will include news related to books and users can subscribe for news
by filling their detail.
46
CHAPTER 7: CONCLUSION
47
CHAPTER 7: CONCLUSION
7.1 Conclusion
CSE BOOK STORE has been entrusted with sensitive, personal data to accomplish its goals. The
success of CSE BOOK STORE depends on the availability, integrity and confidentially of data.
One of the mechanisms to protect data is to implement data integrity and validation controls. Data
integrity controls are used to protect data from accidental or malicious alteration or destruction and
to provide assurance to the user that the information meets the expectations about its quality and
that it has not been altered
48
REFERENCES
Bibliography:
Websites :
1. http://en.wikipedia.org/wiki/PHP
2. http://in.php.net/
3. http://www.w3schools.com/php/default.asp
4. http://www.sqlite.org/
5. http://en.wikipedia.org/wiki/SQLite
6. http://www.functionx.com/sqlserver/
7. http://www.quackit.com/sql_server/tutorial/
8. http://www.tutorialized.com/tutorials/MsSQL/1
49