user relationship management
TRANSCRIPT
-
8/6/2019 User Relationship Management
1/61
User Relationship
Management(Post Question &Chemistry Drawing tool)
DEVELOPED BY
PRIYANKA GUPTA
-
8/6/2019 User Relationship Management
2/61
INTRODUCTION
Basicidea behind this project is Ifastudent
or user hassome Problems regarding their
subjects then theycanask their Questions.
And user canget answers by their friends, or
others, or experts.
This project isa revolutionarystep towards
the fulfilment of their needs regarding their
assignmentsandcomplex problems.
-
8/6/2019 User Relationship Management
3/61
Technology Used:
This Project is beingdevelopedin GWT using
Eclipseasadevelopment tool. The Chemistry
Drawing Tool isdevelopedin Flex-3.0. Weare
using MySql asaBackend.
-
8/6/2019 User Relationship Management
4/61
GWT (GoogleWeb ToolKit): -
GWT providesa Java API that letsyou build
component based GUIswhileavoiding
JavaScript.
The GWT compiler takesyour client side Java
codeandgenerates JavaScript. A compiled
GWT applicationconsists of fragments of
HTML, XML and JavaScript.
-
8/6/2019 User Relationship Management
5/61
GWT also helps to enablesdevelopers to
effectively test anddebug their applications
without first compiling them into JavaScript,
anddeploying theapplications to aweb-
server. For that purpose GWT allows twomodes:-
1. Hosted mode
2. Web mode
-
8/6/2019 User Relationship Management
6/61
GWT Architecture
-
8/6/2019 User Relationship Management
7/61
About Flex:-
Flexisahighly productive, free, opensource
framework for buildingexpressive mobile,
web,anddesktop applications.Flex isa
product of Adobe.
Ingeneral a Flexapplicationisdeveloped
using MXML languagecoupledwith
application logic that has beenwrittenin
ActionScript3.
-
8/6/2019 User Relationship Management
8/61
REQUIREMENTS
HARDWARE REQUIREMENTS SOFTWARE REQUIREMENTS
-
8/6/2019 User Relationship Management
9/61
HARDWARE REQUIREMENTS
Thesystem have following requirementssuch
as-
*The processor should be at least Pentium 4 orabove
*RAMshould be or greater than 256Mb
-
8/6/2019 User Relationship Management
10/61
SOFTWARE REQUIREMENTS
OperatingSystem : Windows
Framework : Eclipse Galileo 3.5, GWT,Flex3.0
Front-End Tool : J2EE (Java,Servlets, HTML,JSNI) (Actionscript, Mxml, Php)
Scripting : JavaScript
Back-End Tool : MySql Web Server : Apache Tomcat, Php
Wamp Server
-
8/6/2019 User Relationship Management
11/61
Project Objectives
This project aims to provideinteractive user
interface by using the flavors of HTML and Css
such that user caneasilyinteract with the
websiteandget their job doneeasily.
This project emphasis more on practical skills.
This project aims to makestudent skilful.
This Project aims to provide the best solution
of the problem posted by thestudent or user.
-
8/6/2019 User Relationship Management
12/61
This Project aims to provide the best solutionwithin the time limit given by the user.
This project aim towardscultivatingstudents
interest in subjects bycreatingacompetitiveenvironment for overall development.
This Project aims to provide right content at righttime.
This Project is trying to build study toolsaroundeducational content that enablesstudents tostudysmarter.
-
8/6/2019 User Relationship Management
13/61
DESIGN
E-R Diagram
Data Flow Diagrams
Class Diagram
State Diagram
-
8/6/2019 User Relationship Management
14/61
User
User_id
fullname
Password
friends
Strong streams
Weakstream
citystate
Current points
address
company
designation
Contact no
picture
post
message
sender
receiver
subject
Send
config-
uration
organization
User reg_id
Password
Email_id
question
tags
Friend sent
Upload image
suggestion
stream
Bid_points
Public link
Date 1
Ques_id,user_id
Date 2
Question
problem
-
8/6/2019 User Relationship Management
15/61
Level 0 Dfd:-
-
8/6/2019 User Relationship Management
16/61
Level 1 Dfd:-
-
8/6/2019 User Relationship Management
17/61
Level 2 Dfd (1.1):-
-
8/6/2019 User Relationship Management
18/61
Level 3 Dfd (Post a Question 1.1.1)
-
8/6/2019 User Relationship Management
19/61
Level 3 Dfd (Answer a Question 1.1.2)
-
8/6/2019 User Relationship Management
20/61
Level 3 Dfd (Watch an answer 1.1.3):-
-
8/6/2019 User Relationship Management
21/61
Class Diagram
-
8/6/2019 User Relationship Management
22/61
CHEMISTRY STRUCTURE
DO/CLICK
PERIODIC TABLE
DO/CLICK
CHEMISTRY DRAWING
DO/SELECT
OPEN STRUCTURE
BUTTON DO/SELECT
BUTTON DO/SELECT
DRAWING
DRAW DO/MOUSE MOVE
SELECT
DO/CLICK
DRAG DO/MOUSE
DOWN & MOVE
RESIZE DO/MOUSE
DOWN & MOVE
CLEAR
DO/DOUBLE CLICK
ROTATION
DO/CLICK & MOVE
VIEW DETAILS VIEW DIAGRAM
START
-
8/6/2019 User Relationship Management
23/61
DATA BASE DESIGN
-
8/6/2019 User Relationship Management
24/61
Table 1: Login
Field Name Data Types Constraints
username Varchar(30) Not nulluser_id Varchar(30) Primarykey
Password Varchar(30) Not nullConfirm password Varchar(30) Not null
-
8/6/2019 User Relationship Management
25/61
Table 2:- Strong Stream
Field Name Data Types Constraints
user_id Varchar(30) Primarykey
Stream Varchar(20) Not null
-
8/6/2019 User Relationship Management
26/61
Table 3:-Weak Stream
Field Name Data Types Constraints
user_id Varchar(30) Primarykey
Stream_weak Varchar(20) Not null
-
8/6/2019 User Relationship Management
27/61
Table 4:- User Profile
Field Name Data Types Constraints
user_id Varchar(30) Primarykey
photo blob null
Full_name Varchar(20) Not null designation Varchar(20) Not null
college/company Varchar(20) Not null
Address Varchar(30) Not null
contact no Integer(15) Not null
Current_point Integer(15) Not null
-
8/6/2019 User Relationship Management
28/61
Table 5:- Friend
Field Name Data Types Constraints
user_id Varchar(30) Primarykey
Total_friends Varchar(10) Not null
-
8/6/2019 User Relationship Management
29/61
Table 6:- Post Question
Field Name Data Types Constraints
user_id Varchar(30) Compositekey(user_id+ques_id)
Ques_id Integer Compositekey(user_id+ques_id)
Stream Varchar(10) Not null
Que_jpg blob Not null
Hint_prob Varchar(20) Not null
Point_ques Date&time Not null
Close_post Date&time Not null
Point_bag Integer(20) Not null
Bid_point Integer(20) Not null
Public link Varchar(10) Not null
Friends_total Integer(10) Not null Subject Varchar(30) Not null
Message Varchar(30) Not null
Que_asked Varchar(50) Not null
-
8/6/2019 User Relationship Management
30/61
Table 7:- Tag
Field Name Data Types Constraints
Ques_id Integer Primarykey
Tags Varchar(50) Not null
-
8/6/2019 User Relationship Management
31/61
Table 8:- Send Friend
Field Name Data Types Constraints
Ques_id Integer Primarykey
Friends_send Varchar(10) null
-
8/6/2019 User Relationship Management
32/61
Table 9:- Response
Field Name Data Types Constraints
user_id Varchar(30) Primarykey
Ques_id Integer Compositekey
Respond_people Integer Not null
-
8/6/2019 User Relationship Management
33/61
Table 10:- Comment
Field Name Data Types Constraints
user_id Varchar(30) Primarykey
Ques_id Integer Compositekey
comments Varchar(30) null
-
8/6/2019 User Relationship Management
34/61
Table-11 Answer Post
Field Name Data Types Constraints
user_id Varchar(30) Compositekey
Ques_id Integer Compositekey
answer Varchar(30) null
-
8/6/2019 User Relationship Management
35/61
Table 12:- Rating
Field Name Data Types Constraints
user_id Varchar(30) Primarykey
Ques_id Integer Compositekey
Point_earn Integer Not null
-
8/6/2019 User Relationship Management
36/61
SnapShots
-
8/6/2019 User Relationship Management
37/61
Sign Up Form (With Captcha)
-
8/6/2019 User Relationship Management
38/61
Displaying Error Messages (Sign Up
form)
-
8/6/2019 User Relationship Management
39/61
Choose Streams where a user can
help others:-
-
8/6/2019 User Relationship Management
40/61
Choose Streams where user needs
help from others:-
-
8/6/2019 User Relationship Management
41/61
Captcha API
-
8/6/2019 User Relationship Management
42/61
Post a Question:-
Write Question Here:-
-
8/6/2019 User Relationship Management
43/61
Toolbar Displayed:-
-
8/6/2019 User Relationship Management
44/61
Character Map Toolbar Displayed:-
-
8/6/2019 User Relationship Management
45/61
Color Palette displayed with Math
Toolbar:-
-
8/6/2019 User Relationship Management
46/61
File Upload:-
Select Image:-
-
8/6/2019 User Relationship Management
47/61
Saving Image on Server:-
-
8/6/2019 User Relationship Management
48/61
Image Displayed in Rich Text Area:-
-
8/6/2019 User Relationship Management
49/61
Select Bid Points(To Rate Question)
and add Tags to Question:-
-
8/6/2019 User Relationship Management
50/61
CongratulationsWindow after
Question Posted:-
-
8/6/2019 User Relationship Management
51/61
Mail Box:-
-
8/6/2019 User Relationship Management
52/61
Flex Tool:-
-
8/6/2019 User Relationship Management
53/61
Chemistry Drawing Tool:-
-
8/6/2019 User Relationship Management
54/61
Drawing Chemistry Diagram:-
-
8/6/2019 User Relationship Management
55/61
Call Flex From GWT (As a Dialog Box)
(Post Problem Module to insert
Diagram):-
-
8/6/2019 User Relationship Management
56/61
Inserted Diagram From Flex in Rich
Text Area:-
-
8/6/2019 User Relationship Management
57/61
Flex Periodic Table:-
-
8/6/2019 User Relationship Management
58/61
Elements Details:-
-
8/6/2019 User Relationship Management
59/61
FUTURE SCOPE
Futurescope of thesekinds ofapplicationsis
incremental. As the project will move forward,
thescope or futurescopewill change.
Wecanadd lots of functionalities to these
kinds ofwebsites(For example)
In mail box
-
8/6/2019 User Relationship Management
60/61
CONCLUSION
At theendwecansay thisisakind of
innovative project. Thiswill help users
especiallyStudentsat their crucial time (such
as Exam time) where theycant have their
teachers or guidewith them who cansort out
their problems.So thisisavery useful project.
-
8/6/2019 User Relationship Management
61/61
Thanks to all