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.
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:
- Abstract
- 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 |
|
