My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
|
Web based Reward Points Management System
Posted Date: 19 Mar 2008 Resource Type: Articles/Knowledge Sharing Category: General
|
Posted By: Deepu Member Level: Diamond
Rating:  Points: 5
|
|
|
Abstract of the project
Company ABC has an internet based product called Infobar, which allows users to view useful links from different sites on topics of his/her interest
To encourage the usage of the Infobar, the company has a reward point scheme. 10 points are rewarded on usage of Inforbar for 1 hr. When a user accumulates over 100 points, he can redeem them for a gift of his choice.
This project aims at building a Reward Points Management System for the customer support team of the company. Objectives are to build
1.A data store for user information
2.Web site supporting functionalities like - Search/sort/add/delete/view/modify etc on user information
3.Modules for bonus point allocation
4.Facility to add information on different gifts available and bonus points against them
5.Facility to detect fraud/duplicate users
6.Generate report on number of users using the Infobar in a month, their responses to various schemes etc
7.Communicate user via email to notify him about various incentives and bonus point schemes, get his feedback etc
Keywords
Generic Technlogy keywords
Network and middleware, database, programming
Specific Technology keywords
HTML, Active Server Pages/Java Server Pages, MS SQL Server/Oracle, T-SQL
Project type keywords
Analysis, Design, Implementation, User Interface, Testing
Functional components of the project
Following is a list of functionalities of the system. More functionality that you find appropriate can be added to this list. And, in places where the description of functionality is not adequate, you can make appropriate assumptions and proceed.
1.There should be login based access to the system. A person should be able to
a.login to the system through the first page of the application
b.change the password after logging into the system
2.System users will be of three type –
a.An administrator
b.A customer relationship officer (CRO)
c.Manager
Depending on the roles, system will be divided into 3 main modules
Administrative module
Reporting module
Customer Details Module
3.Administrative Module - should allow administrators to
i.create other users
ii.View users
iii.provide role based access
iv.invoke access
v.delete user etc
(Add more functionality as suitable)
4.Customer details module should allow to
a.View the list of customer
b.View details of a customer and Infobar usage history on click on customer name/email-id
c.search, sort the customer on different fields
d.send email to the customer
e.check the bonus point status
f.Check customer requests for bonus points. This should receive as an email, CRO should be able to see mails from a POP3 server
g.Adjust number of bonus points automatically on allocation/selection of gift
h.Store shipment details and update the delivery status
i.Before allocation of gift, check if the user is a duplicate user, logging with some other details – this would be a key functionality and involve development of efficient search algorithm on database to detect duplicate uses. Search will be on different criteria like user name, date of birth, address etc
j.On detection of duplicate user, CRO should be able to able to block/blacklist user
k.Add/delete new reward schemes, product details in reward schemes
l.Send emails to user regarding reward points, queries, feedback, complains etc.
h
5.Reporting module – should allow end users to
a.View different types of reports such as
i.Usage of Infobar in a month over a year in graphical format
ii.User base for the year
iii.Graphs for inactive users (users who did not use the Infobar for a period of a month and more)
iv.Different reward schemes over the year and user response
v.Customer feedbacks
Steps to start-off the project
There are a couple of alternatives to implement this system
Active Server Pages as the front end/ middleware and MS SQL Server as the back end
OR
Java server pages/Java Servlets as front end/middleware, Oracle as back end
The following steps will be helpful to start off the project.
1.Study and be comfortable with technologies such as
a.Active Server Pages (ASP)/HTML and SQL server.
b.Java Server pages(JSP), Java Servlets and Oracle
Some links to these technologies are given in the ‘Guidelines and References’
section of this document
2.Create the database for following
a.User information
b.Login information and roles such as administrator, CRO, Manager
c.Reward Schemes
d.Infobar usage
Split database into multiple tables as applicable, develop relationship, dependency between tables
3.Design the front ends for 3 modules – administrative, customer details and repotring
4.Design the flow diagrams for modules to have seamless navigation between the pages in a module
5.Decide on the links/pages required to achieve all the functionalities
6.Design the UI to give the site a consistent look, make the pages informative as well as attractive for the end user. Make use of style sheets, images
7.Decide on efficient algorithm for search, sort functionalities in the site
8.Create a help page, site diagram for novice users
|
Responses
|
No responses found. Be the first to respond and make money from revenue sharing program.
|
|
Watch TV Channels
|