Online project management System Project is an automation tool which provides an effective solution to reduce manual work of the projects in any educational organization. This tool enhances the efficiency and also saves a lot of time for faculty, teams. Initially, faculty and the teams has to register for utilizing various services included in this portal. Online Project management consists of services like view information of the teams, information of projects, scheduling notices, editing status.

Here we will explain about database design. Download online project management system project in java source code with project report.

Online project management System Database Details:

1.     Logindetails

Create table logindetails(loginname varchar2(40),password varchar2(40),logintype varchar2(40),regddt date,questionid number(5),answer varchar2(50),login_status number(2),firstlogin number(10),pwdmdfydt date);

LOGINNAME

PASSWORD

LOGINTYPE

REGDDT

QUESTIONID

ANSWER LOGIN_STATUS

FIRSTNAME

PWDMDFYDT

 2.     loginprofile

Create table loginprofile(loginid varchar2(40),firstname        varchar2(30),email varchar2(20)); 

LOGINID

FIRSTNAME

EMAIL

 3.     login_audit

Create table login_audit(loginid varchar2(40),logindate date,login_desc varchar2(40));

LOGINID

LOGINDATE

LOGIN_DESC

 4.     notice

create table notice(nid number(5),notice varchar2(500),ntdt date,ntby varchar2(40));

NID

NOTICE

NTDT

NTBY

 5.     projectdocs

create table projectdocs(docid number(5),prjid  number(5),doc blob);

DOCID

PRJID

DOC

 6.     projects

create table projects(prjid number(5),pname varchar2(100), technology varchar2(500),percent number(5,2), projtype varchar2(20),status varchar2(20),teamid varchar2(40));

PRJID

PNAME

TECHNOLOGY

PERCENT

PROJTYPE

STATUS

TEAMID

  7.     question_base

create table question_base(squestionid number(5),question varchar2(50));

SQUESTIONID

QUESTION

 

 8.     teammembers

create table teammembers(loginname varchar2(20), mname varchar2(40),memail varchar2(40),mregdno varchar2(40));

LOGINNAME

MNAME

MEMAIL

MREGDNO

  9.     teamprofile

create table teamprofile(teamid varchar2(40),batchno varchar2(30),year varchar2(4),gid varchar2(40));

TEAMID

BATCHNO

YEAR

GID

  10.                         timesheet

create table timesheet(teamid varchar2(40),tsdate date,hour varchar2(20),work varchar2(100),status varchar2(20));

TEAMID

TSDATE

HOUR

WORK

STATUS

 Download Online Project Management System Database Design ( DCL, DML,DDL ) files.

Link to download Project Manual