PROJECT ON DBMS

concepcionsockSoftware and s/w Development

Aug 15, 2012 (5 years and 3 months ago)

290 views

A

DATABASE PROJECT

ON

PROJECT MANAGEMENT


Members

:
-

Asim Shrestha

Prabesh Shrestha

Subodh Raj Satyal

OBJECTIVES



To help


software companies manage their
projects elegantly and efficiently


To be familiar with the concept of DBMS


To learn web programming and designing


Fulfillment of course requirement


INTRODUCTION


Used to manage the projects under an
organization


Two login mode (admin and user)


Addition of new projects


Deletion and modification of database by
the privileged user i.e. admin


Users restriction





INTRODUCTION


Used to manage the projects under an
organization


Two login mode (admin and user)


Addition of new projects


Deletion and modification of database by
the privileged user i.e. admin


Users restriction





Relational schemas


Group_member
(
g_id
,member_name
)


Group(
group_id
,group_name
)


Employee(
e_id
,
name,qualification,sex
)


Project(
p_id
,name,client,start_date,end_d
ate,priority,type
)


Login(
username
,password,e_id
)


Task(
t_id
,name,type,status
,
priority,elapsed_time
)


Forumpost
(
name,heading,description,repli
es
)


Forumreply
(
p_name,heading,description
)





SYSTEM

DESCRIPTION


Admin Access


List of projects ,tasks , employees


Addition and deletion of projects, employees,
tasks


User Access


Projects involved


Tasks allocated


Notice from admin


Forum




DEVELOPMENT TOOLS


Java


JSP (Java Server Page)


JDBC API


Mysql


Dreamweaver


Netbeans


CHALLENGES/LIMITATION

Original scope of the project was probably
too ambitious


leading to;


tension in workloads


lack of resources and time



Gantt Chart


GUI Design


Time Tracking


Automatic Report Generation

SUGGESTIONS

!!!