designing database for project tracker
Posted by: siri tanvi
Date: January 14, 2019 04:16AM

Hi friends,
we are designing an application for project tracking software which includes various teams.The project contains milestones and milestones contains tasks and tasks will have sub tasks.I need help in designing tables for the said proj.I am a newbie for this type of project.Can somebody post similar design tables and relations.The requirements are as follow

Like Milestone1->task1->subtask1->subsubtask1->so on....

Milestone2->task1->subtask1

Milestone3->task1 Milestone3->task2 Milestone3->task3

Milestone will complete after completion of all tasks

In a task multiple teams are involved.

Some tasks are to be completed by all teams

Manager must be able to assign task to teams.

Manager is capable of assigning same task to multiple teams and task completes only after completion of each team side.

Thanks in Advance friends

Options: ReplyQuote


Subject
Written By
Posted
designing database for project tracker
January 14, 2019 04:16AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.