Project Presentation On
Mail Server
Presented To
Department of computer science
Ganpat Vidyanagar, Kherva-384012
Presented By
Patel Drashti P.(13084231109)
Patel Hardik J.(13084231112)
Group No : 54
Project Profile
Project Title: Mail Server
Objective: This application provide mailing facility to users. If user have
internet connection then he/she can send or receive their emails
through this application. They can manage their inbox,sentbox
and etc.
Front End: ASP.NET with C#(.NET Framework 4.0)
Back End: Microsoft SQL Server 2008
Others Tools: Microsoft Office 2007,Crystal Report
Type of Application: Web Application(Website)
Internal Guide: Jayesh A Patel
Project Duration: 90 Days
Existing System
There are many existing system like our Mail Server, but we are creating
this for privacy purpose.
By this mail server we can customize the rights given to different different
users.
So we can make secure our confidential data, which can be safely used on
internet by authorized person.
Need for new system
In proposed system we are able to send or receive mails to one or many
person.
You can also see,reply,forward or delete mails from your inbox.
You can look at news, or sport or connect to social networking site like
facebook.
Functional Specification
Module Name Description Users
Login Login module includes facility like user User , Admin
management, authentication, change
password, Forget Password etc.
Profile This modules include facility for editing, User , Admin
Management updating the profile of user.
Mail Mail management module provide facilities User , Admin
Management like compose mail, view mail , delete mail
etc.
Contact In this module you can add contact User
Management information like name, address, phone
number, E-mail address etc. and manage
those information.
User In this module admin can manage all the Admin
Management user. If he want to prevent any user for
using this application then he can prevent
that user by this module.
Module Name Description Users
Advertise Advertisement module provides facility for Admin
Management editing in present advertisement, adding
new advertisement, delete old
advertisement etc.
Feedback By using this module user can give his User , Admin
Management feedback regarding to this web application,
and admin can manage this feedback.
Hardware and Software Specification
Server Side:-
Minimum Hardware Requirement :-
Processor 1.0 GHz
Primary Memory 1 GB of RAM
Storage Space 1 GB(plus user wise storage space)
Minimum Software Requirement :-
Runtime Environment .NET Framework 4.0
Database Server Microsoft SQL Server 2008
Operating System Widows Server 2003
Web Server IIS 6.0 (Internet Information Services)
Reporting Tool Crystal Report 10
Client Side:-
Minimum Hardware Requirement :-
Processor 633 MHz
Primary Memory 256 MB
Storage Space 1 GB(in case of download)
Minimum Software Requirement :-
Operating System Window XP
Browser Internet Explorer 6.0 or any compatible browser.
System Flowcharts
Start
Is
No
Registered
?
Yes Registration
Authenticattion
Is
No
Valid
?
Yes
Is
Yes No
Admin
?
A B
A B
User Management Profile Management
Advertise Management Mail Management
Feedback Management Contact Management
News Management View News/Advertisement
Mail Mangement Give Feedback
Report
Generation
End
Gantt chart
Task Time Duration (In Days) Total Days
15 30 45 60 75 90
Requirement
(1-15)=15
Gathering & Analysis
Designing (16-45)=30
Coding (31-70)=40
Testing (41-80)=40
Deployment &
(81-90)=10
Implementation
Total 90
E-R Diagram
M M
Feedback
Manage Feedback_Id Username Give
Registration_Id Username
Registration_Id Username
Manage
1 1
1 M 1
Admin User
1
Password 1 1
Username
Edit
Attachment
1
Profile
M
Mail_Id
Registration_Id
Send/
Recieve
Has
M
Mail
1
Manage
M M
News View
Id Title
UML Diagram
Use Case Diagram :
Activity Diagram :
1. Activity Diagram of Admin:
2. Activity Diagram of User:
Class Diagram :
Sequence Diagram :
1. Sequence Diagram of Admin:
Mail Server Database
Top Package::Admin
Enter username & password Login information
Login successfully or not Acknowledgement
Enter details of users Approve details
Successfully updated or not Acknowledgement
Enter advertisement data insert advertisent data
Display Advertisement Acknowledgement
Enter News Information validates news data
Successfully set news or not acknowledgement
Give feedback send to approprite user
Display Feedback Acknowledgement
2. Sequence Diagram of User:
Mail Server Database
Top Package::User
Enter username & password Login information
Login successfully or not Acknowledgement
Enter details of Mail Approve mail data
Successfully send or not acknowledgement of mail
request for advertisement insert advertisent data
Display Advertisement Acknowledgement
request/update profile validates profile data
Successfully updated or not acknowledgement
Give feedback send to approprite user
Display Feedback Acknowledgement
Collaboration Diagram :
1. Collaboration Diagram of Admin:
1.1 Authentication
2.1 Perform Operation
3.1 Perform Operation
4.1 Perform Operation
5.1 Perform Operation
6.1 Perform Operation
System Database
1.1.1 Acknowledgement
2.1.1 Successfully Performed
3.1.1 Successfully Performed
4.1.1 Successfully Performed
5.1.1 Successfully Performed
1.1.1.1 Login/Wrong username or password
6.1.1 Successfully Performed
2.1.1.1 View user details
3.1.1.1 View Advertisement Detail
4.1.1.1 View News Detail
5.1.1.1 View Feedback
1.Login
6.1.1.1 View Mails
2.Manage User
3.Manage Advertisement
4.Manage News
5.Manage Feedback
6.Manage Mails
Admin
2. Collaboration Diagram of User:
1.1 Authentication
2.1 Perform Operation
3.1 Perform Operation
4.1 Perform Operation
5.1 Perform Operation
6.1 Perform Operation
System Database
1.1.1 Acknowledgement
2.1.1 Successfully Performed
3.1.1 Successfully Performed
4.1.1 Successfully Performed
5.1.1 Successfully Performed
1.1.1.1 Login/Wrong username or password
6.1.1 Successfully Send
2.1.1.1 View Profile Detail
3.1.1.1 View Mails
4.1.1.1 View Contact Detail
5.1.1.1 View Advertisement
1.Login
6.1.1.1 Successfully Give Feedback
2.Manage Profile
3.Manage Mail
4.Manage Contact
5.View Advertisement
6.Give Feedback
User
Data-Dictionary
Table Name : Registration
Primary Key : REGISTRATION_ID
Unique Key : USERNAME
Description : It contains information about Existing User.
Sr.no Field Name DataType(size) Constraints Description
It displays registration id of
1 REGISTARTION_ID Autogenerate Primary Key
user.
It displays firstname of
2 FNAME Nvarchar(max) Not Null
user.
It displays last name of
3 LNAME Nvarchar(max) -
user.
It displays username of
4 USERNAME Nvarchar(50) Unique key
user.
It displays password of
5 PASSWORD Nvarchar(max) Not Null
user.
It displays birthdate of
6 BDATE Date Not Null
user.
7 GENDER Varchar(50) Not Null It displays gender of user.
It displays language of
8 LANGUAGES Varchar(50) Not Null
user.
It displays UserRole. Ex. a
9 USERROLE Varchar(50) Not Null
for admin and u for user.
Table Name : Personal_Info
Primary Key : MOBILENO
Forign Key : REGISTRATION_ID
Description : It contains personal information about Existing User.
Sr.no Field Name DataType(size) Constraints Description
Foreign Key It displays registration id
1 REGISTARTION_ID Autogenerate
Table: Registration of user.
It displays mobile number
2 MOBILENO Numeric(18,0) -
of user.
It displays alternate email
3 ALTERNATEEMAIL Nvarchar(max) Not Null
of user.
It displays
4 SECURITYQUE1 Nvarchar(max) Not Null
securityquestion1.
It displays answer of
5 ANSWER1 Nvarchar(max) Not Null
security que1 given above.
It displays security
6 SECURITYQUE2 Nvarchar(max) Not Null
question2.
It displays answer of
7 ANSWER2 Nvarchar(max) Not Null
security que2
8 COUNTRY Varchar(50) Not Null It displays country of user.
It displays image selected
9 PHOTO Nvarchar(max) -
by user.
10 COUNTRY Varchar(50) Not Null It displays country of user.
Table Name : Mail
Primary Key : MAIL_ID
Foreign Key : REGISTRATION_ID , FOLDER_ID
Description : It is the common Inbox that contains receive mails of all
user.
Sr.no Field Name DataType(size) Constraints Description
1 MAIL_ID Autogenerate Primary Key It displays mail id.
Foreign Key It displays
2 REGISTRATION_ID Numeric(18,0)
Table: Registration registration_ID.
3 DESTINATION Varchar(50) - It displays destination id.
4 SOURCE Nvarchar(50) - It display source of mail.
5 CC Varchar(50) - It display carbon copy.
It displays blank carbon
6 BCC Varchar(50) -
copy.
7 SUBJECT Varchar(50) - It displays subject of mail.
It displays actual message
8 MESSAGE Nvarchar(max) -
of mail.
9 DATE Datetime -- It contain date of mail.
Foreign Key It contain folder id in
10 FOLDER_ID Numeric(18,0)
Table:FOLDER which it is saved.
It displays yes when mail
11 DELETE_MAIL Bit -
is deleted.
It displays yes when
12 READ_MAIL Bit -
message is readed.
It displays yes when we
13 REPLY Bit -
give reply mail.
It displays yes when we
14 FORWORD Bit -
forward the mail.
Table Name : FOLDER
Primary Key : FOLDER_ID
Foreign Key : REGISTRATION_ID
Description : It holds information of folders.
Sr. no FieldName DataType(size) Constraints Description
1 FOLDER_ID Numeric(18,0) Primary Key It displays folder id.
2 FOLDER_NAME Varchar(50) - It displays folder name.
Not Null,Foreign
3 REGISTRATION_ID Numeric(18,0) Key It display registration id.
Table: Registration
Table Name : News
Primary Key : ID
Description : It contains information of news like News title , Data , Created date.
Sr. no FieldName DataType(size) Constraints Description
1 ID Numeric(18,0) Primary Key It displays news ID.
2 TITLE Varchar(50) - It displays title of news.
It displays data containing
3 DATA Varchar(max) -
in news.
It display created date of
4 CREATED DATE Datetime -
news.
Table Name : ATTACH
Primary Key : ATTACH_ID
Foreign Key : MAIL_ID
Description : It contains Attachment which are user uploaded.
Sr. No FieldName DataType(size) Constraints Description
It displays attachment
1 ATTACH_ID Numeric(18,0) Primary Key
id.
Foreign Key
2 MAIL_ID Numeric(18,0) It displays mail id.
Table: Mail
3 FILENAME Varchar(50) Not Null It displays filename.
4 FILEPATH Varchar(max) Not Null It display file path.
Table Name : ADDRESSBOOK
Primary Key : CONTACT_ID
Foreign Key : REGISTRATION_ID
Description : It contains address, Contact of user.
Sr. no FeildName DataType(Size) Constraints Description
1 CONTACT_ID Numeric(18,0) Primary Key It displays contact id.
It displays contact
2 CONTACT_NAME Nvarchar(50) Not Null
name.
It displays email
3 CONTACT_EMAIL Nvarchar(max) Not Null
address.
Foreign key
4 REGISTRATION_ID Numeric(18,0) It display registration id.
Table:Registration
Table Name : FEEDBACK
Primary Key : FEEDBACK_ID
Foreign Key : REGISTRATION_ID
Description : It contains feedbacks given by user.
Sr. no FeildName DataType(Size) Constraints Description
1 FEEDBACK_ID Numeric(18,0) Primary Key It displays feedback id.
It displays feedback
2 FEEDBACK_DETAIL Nvarchar(50) Not Null
details.
Foreign key It display registration
3 REGISTRATION_ID Numeric(18,0)
Table:Registration id.
Input Design
Home Page: This is home page of our website.
Registration Page: this is registration page of our website.
Registration Page: Here validation are used in registration page of our website.
Registration Page: This is successfully registred user.
Login Page: This is login page of our website.
Login Page: This is login page of our website.
Inbox Page: This is inbox page of our website.
Inbox Page: This is main menus of our website.
Compose Mail: This is compose mail page of our website.
Compose Mail: This is compose mail page of our website.
Attachment Page: We can select multiple files in attachment.
Attachment Page: We can select multiple files in attachment.
Compose Mail : We can select multiple files in attachment.
Inbox : We can receive mails through this page.
Inbox Page: We can mark mail as read/unread as following.
Sent Mail: We can see all sent mails on this page.
Sent Mail: We can see any particular mail and sent reply to him.
Addressbook: This is addressbook of our user.
Addressbook: We can add new contact in our addressbook as follow.
Addressbook: We can add new contact in our addressbook as follow.
Addressbook: We can managecontact in our addressbook as follow.
Profile Page: User can update theirs profile.
Administration Login: This is admin login.
News: You can see news as follow.
News: This is manage news page.
News: This is manage news page.
Output Design
Send Mail Report:
Attachment Report:
Registration Report:
Testing
No Test cases Case type Expected Result Actual Result Pass/Fail
The system cant allow
1.1 Login Non register user They cant login Pass
to enter
The system prevent the
Wrong userID and user from enterin The system shows
1 1.2 Login pass
password wrong user name and the error massage.
password
Enter correct username The system redirect The system send
1.3 Login Pass
and Password page them at home page
You have to enter
2.1 Validation Test Mandatory field can
Requirefield Validation Some value in this Pass
case not be empty
field
You have to enter
2.2 Validation Test The field have
Rang validation values between given Pass
case predefined range
2 range
You have enter
2.3Validation Test Regular expression The system can take
values in proper Pass
case validation values in given format
format
Enter the same
2.4Validation Test The system compares
Compare validation values if not then Pass
case two values.
show error
No Test cases Case type Expected Result Actual Result Pass/Fail
If member is not login
If member is registered
3.1 Unit test Inbox Page then he/she can Pass
then he can enter
redirected to login page
If member is not login
If member is registered
3 3.2 Unit test tryCompose page then he/she can Pass
then he can enter
redirected to login page
User can not enter in
All the validations are
3.3Unit test Registration Page another form without Pass
applied
doing registration
All the sessions are
User can redirected to
4.1 System Testing After Logout deleted and redirected Pass
home page
to home page.
If you have internate Email send
4.2 System Testing Compose mail connection email can successfully and stored Pass
send. in Mail table
User can successfully
User can check mail as
4.3 System Testing Read/Unread mails ckecked as Pass
4 read/unread.
read/Unread.
If user can check any
mail and press delete Deletation can
4.4 System Testing Delete mails Pass
then that mail can be performed succesfully.
deleted.
User can put unwanted User can done this
4.5 System Testing Trash mails Pass
Post Implementation Review
This system is much more user friendly and provide user interface.
There are multiple facilities to support so it is better.
By this website can easily send or receive mails.
User can t enter without login.
By this website user can view other websites.
Future Enhancement
Emails Received which are sent from external mail server.
Emails can also sent to your Mobile no.
Emails can forward to more then one user.
Chat facility for internal as well as external members.
Bibliography
During development of project we have used the following books and Websites.
Reference Books:-
Sr. no Title Author
1 ASP.NET with C# Shyam N. Chavda
2 Pro ASP.NET 4 in C# 2010 Matthew MacDonald
3 Beginning ASP.NET 4:in C# and VB Imar Spaanjaars
4 The Elements of UML 2.0 Style Scott W. Ambler
Web Reference:-
http://www.expert-exchange.com
http://www.stackoverflow.com
http://www.snippers.com
