Online Project Management System Project  in asp.net is having a broad future scope as it can be extended to provide services to the customers (seekers or employers) online. This system can be implemented for online transactions without the intervention of the authority. 

Project Management System Project

This application can be useful for developing job portal related systems through which users from any location can update job updates and post to website and search for jobs and recruit employees in shot time.

Youtube video link to view design details.

http://www.youtube.com/watch?v=HFDJZrcuOlI&feature=youtu.be

How To Run Online Project Management System:

softwares required:
jdk 1.6.0
Tomcat 5.5
Oracle 10g

create user in oracle
user name:pmis
Password:pmis
syntax:
create user <username> identified by <password>
grant resource,connect to <username>
conn <username>/<password>
Copy all the tables

create dsn name -pmis

copy the application folder in tomcat webapps folder .
run tomcat server.
open the browser and type the localhost address i.e.,
http://localhost:<port number>/<application name>

 Project Report Overview:

  1. Abstract
  2. Introduction

            Introduction to Organization

            Introduction to Environment

            Software Used

            Hardware Used

Requirement Analysis

            Problem Analysis

Introduction to UML

            Feasibility Study

            Technical Feasibility

            Operational Feasibility

            Economic Feasibility

            Cost-Benefit Analysis

            Preparation of Requirement Specification

            Software Requirement Specification

Software Design

            Object Oriented Design Methodology

            Introduction

             Design Tools Utilized

            Activity Diagram

            Sequence Diagram

            Class Diagram

            Object Diagram

            State Chart Diagram

Database Design

            Introduction

            Table Description

Testing

            Levels of Testing

            White Box Testing

            Black Box Testing

            Testing Strategy

Implementation

            Algorithmic/Navigational Description

Database Design:

TABLE NAME: EMPLOYEE 

SNO

COLUMN NAME

DATA TYPE

DESCRIPTION

1

Eid

Varchar2(15)

PRIMARY KEY

2

Ename

Varchar2(50)

 

3

Esal

Number(10)

 

4

Desig

Varchar2(15)

 

5

Corp_id

Varchar2(30)

PRIMARY KEY

6

Pwd

Varchar2(8)

 

7

Sup_id

Varchar2(15)

 

8

Phno

Number(15)

 

9

Address

Varchar2(150)

 

 TABLE NAME: CLIENT 

SNO

COLUMN NAME

DATATYPE

DESCRIPTION

1

Cid

Varchar2(15)

PRIMARY KEY

2

Cname

Varchar2(50)

 

3

Mail_id

Varchar2(30)

 

4

Phno

Number(15)

 

5

Address

Varchar2(150)

 

 

TABLE NAME: PROJECT 

SNO

COLUMN NAME

DATATYPE

DESCRIPTION

1

Pid

Varchar2(15)

PRIMARY KEY

2

Pname

Varchar2(40)

 

3

cid

Varchar2(15)

REFERENCES CLIENT (Cid)

4

Pm_id

Varchar2(15)

REFERENCES EMPLOYEE (Eid)

5

Pl_id

Varchar2(15)

REFERENCES EMPLOYEE (Eid)

6

Approach_date

Date

 

7

C_req_date

Date

 

8

Platforms

Varchar2(25)

 

9

P_desc

Varchar2(300)

 

10

P_status

Varchar2(50)

 

11

Start_date

Date

 

12

Submit_date

Date

 

13

No_of_mod

Number(2)

 

 TABLE NAME: MODULE 

SNO

COLUMN NAME

DATATYPE

DESCRIPTION

1

Mid

Varchar2(15)

PRIMARY KEY

2

M_name

Varchar2(40)

 

3

Pid

Varchar2(15)

REFERENCES PROJECT (Pid)

4

Tl_id

Varchar2(15)

REFERENCES EMPLOYEE (Eid)

5

Assign_date

Date

 

6

Submit_date

Date

 

7

M_status

Varchar2(50)

 

8

M_desc

Varchar2(300)

 

 TABLE NAME: MAILS 

SNO COULMN NAME DATATYPE DESCRIPTION
1 Sid Varchar2(15) PRIMARY KEY
2 To_id Varchar2(50)  
3 From_id Varchar2(50)  
4 Subject Varchar2(100)  
5 Msg Varchar2(1000)  
6 Date_time Date  

TABLE NAME: WORKASSIGN 

SNO

COLUMN NAME

DATATYPE

DESCRIPTION

1

Wid

Varchar2(50)

PRIMARY KEY

2

Tl_id

Varchar2(15)

REFERENCES EMPLOYEE (Eid)

3

Tm_id

Varchar2(15)

REFERENCES EMPLOYEE (Eid)

4

Work

Varchar2(1000)

 

5

W_date

Date