1 of 68

Social Network System

Develope by:-

Rathod Gunwant M.

Suthar Shivangi J.

Suthar Dipal J.

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

2 of 68

�Project profile

Project title

Website development of social network

Project definition

Social networking-community site,

provides communication to various employees of the company and employees can get also the features as current community Site.

Internal project guide

Hemat Oza

Keyur Patel

Amit Patel

Team size

3

Team member

Rathod Gunwant M.

Suthar Shivangi J.

Suthar Dipal J.

​

​

​

​

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

3 of 68

��Cont..

z

Hardware configuration

​

​

​

Front end

Processor : - Intel Pentium-IV

Ram :- 512 MB

Hard disk : - 20GB on System Drive

Microsoft ASP. Net 2005 with C#

Back end

SQL Server 2005

Operating system

Microsoft XP Service Pack 2

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

4 of 68

System Analysis

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

5 of 68

Existing System Study

​

  • Employees while communicating through phone and internet chat.

​

  • Legal Documents sharing was done with Emails and Manual file works.

​

  • When Employee need communicating with another Employee they have two Option:
  • Phone
  • Chat

​

 

​

​

 

​

​

​

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

6 of 68

Cont..

​

  • Phone :-

In phone communicating it connect with telephone to desire Employee.

  •  Chat :-

When they are use to internet chat that time it must be read internet.

​

  • In sharing of legal document via email employee must be upload a file in email and receiver download a file from email. So, In existing system file sharing task performed by email.

 

​

 

​

 

​

​

 

​

​

​

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

7 of 68

Problem Definition

​

  • Employees while communicating with phone and internet chat there

was no security of their communication.

​

  • When send to mail another employee that time is not use own mail

Sever so it depended on other mail server.

​

  • It was also costly and not reliable. 

 

  • In existing system performed in task is taking more .So, time is

wasting of user.

 

 

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

8 of 68

Project Definition

  • Social networking-community site provides communication to various employees of the company and also employees can get also the features as current community site.

​

Registration :-

When Employees want to add in this application it easily to registration in this application.

Manage profile :-

Employees easily edit profile to desire change.

 

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

9 of 68

Cont..

​

Search Employees :-

Employee easily search another employees by employee information.

 

Request for employees :-

Employees can find another

employees then send a request for join and add inn own account.

 

​

 

​

 

​

​

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

10 of 68

Cont..

 

. Scrap :-

Send and receiver scrap by employees.

 

Photo Gallery :-

Employees can easily upload photos own

employees account easily.

 

Chat :-

It is easily communicating with online employees.

 

​

 

​

 

​

​

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

11 of 68

Cont..

 

  • Feedback :-

If employee want communicating with employees it’s feel feedback and send that feedback it direct connect with admin and read that connect.

 

​

 

​

​

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

12 of 68

About The New System

The new system will developed gives following facility to the user:

​

  • Registration
  • Login
  • Profile Manage
  • Search friends
  • Request friends
  • Scrap

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

13 of 68

Cont..

  • Photo Gallary
  • Chat
  • Feedback

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

14 of 68

Hardware and Software

Hardware (Recommended):-

​

Processor : Pentium-Iv

​

Random Access Memory : 512 MB

​

Hard Disk : 20 GB

​

​

�

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

15 of 68

Software( Recommended):-

​

Front-End : ASP.NET 2.0

Web Server : IIS 5.1

Back-End : SQL server 2005

Support : Framework 2.0

Operating System : Windows XP (service pack 2)

Supporting tools : Microsoft Word for document

 

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

16 of 68

Context Diagram

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

17 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

18 of 68

Fist Level Diagram

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

19 of 68

Revolution Creation Community Site

NSVKMS MCA College , Visnagar Seat No: 559 & 617

20 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

21 of 68

Entity Relation Diagram

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

22 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

23 of 68

Data Dictionary

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

24 of 68

FieldName

Data Type

Length

Constraints

Description

UserID

Varchar

30

Primary Key

Emp.EmailID

Password

Varchar

15

Not null

Emp.Password

Firstname

varchar

20

Notnull

Emp.F.name

Middlename

Varchar

20

Notnull

Emp.M.name

Lastname

Varchar

20

Not null

Emp L.name

State

Varchar

20

Not null

Emp state

City

Varchar

15

Not null

Emp city

Pin

Number

6

Not null

Emp city pin

Securityquestion

Varchar

100

Not null

Sec Que of Emp

Securityans

Varchar

100

Not null

Sec Ans of Emp

Status

Varchar

1

Not null

Status of emp.

Table Name:-tbllogin

Purpose:-Employee login

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

25 of 68

FieldName

Data Type

Length

Constraints

Description

Pid

int

-

Primary Key

Profile Id

UserID

Varchar

30

Foregin Key

Emp.EmailId

Photo

Varchar(Max.)

-

Not null

Emp.Photo

Firstname

Varchar

20

Not null

Emp.F. Name

Middlename

Varchar

20

Not null

Emp.M.Name

Last Name

Varchar

20

Not null

Emp.L..Name

Gender

Varchar

6

Not null

Emp.Gender

Dateofbirth

Date/Time

-

Not null

Emp.BOD

City

Varchar

15

Not null

Emp.City

State

Varchar

20

Not null

Emp ct.state

Pin

Number

6

Not null

Emp.ct.Pin

Phoneno

Varchar

12

null

Emp.Phone no.

Mobileno.

Varchar

10

null

Emp.Mobile no.

Table Name:-tblprofile

Purpose:- Add the profile of emp.

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

26 of 68

FieldName

Data Type

Length

Constraints

Description

Rid

int

-

Primary Key

Profile Id

Reqfrom

Varchar

30

Not null

​

Req. friends send

ReqTo

Varchar

30

Not null

​

Req. friends Agree

Status

Varchar

1

Not null

Status of emp.

Table Name:-tblrequest

Purpose:- Send the req. for add fnds.

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

27 of 68

FieldName

Data Type

Length

Constraints

Description

Sid

Int

-

Primary Key

Scrap Id

Sname

Varchar

30

Foregin Key

From User

Sch

Varchar

20

Not null

To User

Sdetails

Varchar

100

Not null

Scrap Contain

Table Name:-tblscrap

Purpose:-send scrap

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

28 of 68

FieldName

Data Type

Length

Constraints

Description

Photid

Int

-

Primary Key

PhotoId

UserID

Varchar

30

Reference Key

Emp.EmailId

Photoparth

Varchar(MAX)

-

Not null

Emp photo

Comment

Varchar(MAX)

-

Not null

Emp.Comment

Table Name:-tblphoto

Purpose:-photoGallary

FieldName

Data Type

Length

Constraints

Description

Photid

Int

-

Primary Key

PhotoId

UserID

Varchar

30

Foreign Key

Emp.EmailId

Photoparth

Varchar(MAX)

-

Not null

Emp photo

Comment

Varchar(MAX)

-

Not null

Emp.Comment

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

29 of 68

FieldName

Data Type

Length

Constraints

Description

Fid

Int

-

Primary Key

Feed_Id

Name

Varchar

30

Notnull

Emp.Name

Address

Varchar

100

Not null

Emp_addes

City

Varchar

15

Not null

Emp.city

State

Varchar

20

Not null

Emp_state

Country

Varchar

20

Not Null

Emp Country

Phone

Varchar

12

Null

Emp Phone

Mobile

Varchar

10

Null

Emp_mobile

Fdate

Datetime

\-

NotNull

Emp_date

feedback

Varchar

200

NotNull

Emp_Query

Table Name:-tblFeedback

Purpose:-user Service Feedback

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

30 of 68

FieldName

Data Type

Length

Constraints

Description

UserID

varchar

30

Primary Key

Admin.EmailId

Password

Varchar

15

Not null

Admin .Pass

Table Name:-tbladmin

Purpose:-Admnistater

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

31 of 68

FieldName

Data Type

Length

Constraints

Description

Aaid

Int

-

Primary Key

Advertisement ID

Advertisement

Varchar

20

Not null

Advertisement

Adec.

Varchar

100

Not null

Advertisement dec.

Type

Varchar

20

Not null

Advertisement type

Photos

Varchar(MAX)

-

Not null

Adertisement Photos

Table Name:-tbladvertisement

Purpose:-send the Advertisement

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

32 of 68

FieldName

Data Type

Length

Constraints

Description

Anid

Int

-

Primary Key

Advertisement ID

News

Varchar

20

Not null

News

Newsdate

Date/time

-

Not null

News date

Newsdetails

Varchar

100

Not null

News details

Table Name:-tblnews

Purpose:-send the news

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

33 of 68

Screen layouts & Reports

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

34 of 68

Revolution Creation Community Site

Login.aspx

Swami Sachchidanand Polytechnic College , Visnagar

​

35 of 68

�Register.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

36 of 68

Login.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

37 of 68

Adminlogin.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

38 of 68

�Authentication.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

39 of 68

�Authentication.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

40 of 68

�

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

Forgetpass.aspx

41 of 68

Login.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

42 of 68

�profile.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

43 of 68

�Home.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

44 of 68

�Search.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

45 of 68

�Searchuser.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

46 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

�Requestuser.aspx

47 of 68

�Requestfriend.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

48 of 68

�Home.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

49 of 68

�Home.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

50 of 68

�Scrap.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

51 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

�Checkprofile.aspx

52 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

�Photo Gallary.aspx

53 of 68

�Deletefriends.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

54 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

�Feedback.aspx

55 of 68

�Chat.aspx

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

56 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

�Startchat.aspx

57 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

�Advertisement.aspx

58 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

�News.aspx

59 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

�Checkuser.aspx

60 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

�Adminfeedback.aspx

61 of 68

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

�Changepass.aspx

62 of 68

Conclusion

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

63 of 68

Limitation

​

  • This System is temporary not provide message, video gallery.

 

  • This system is temporary use from company employees.

​

​

​

​

​

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

64 of 68

Futures scope

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

65 of 68

  • In the features we build message, video gallery.
  • We also provide high security and reduces disadvantage.
  • Reduces high cost.
  •  Reduce the time consuming.

​

​

​

​

​

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

66 of 68

Bibliography

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

67 of 68

BOOKS

​

  • Professional ASP.NET 2.0

By: Bill,Evejen,Devin

  • Software Engineering

By: Roger Bresmen

  • Analysis and design of information Sytem

By:Jemes .A. Semn

Web site

www.google.com

​

​

​

​

​

​

​

​

​

Revolution Creation Community Site

Swami Sachchidanand Polytechnic College , Visnagar

​

68 of 68

Revolution Creation Community Site