CareerCup

Can someone post the solution?

Where is the project state info stored?

I think if startdate > mar 26, state = planned
if startdate <= mar 26 && enddate >= mar 26, state = in progress
if enddate < mar 26, state = delivered

Depends on the data given due to the mising time project stage information.

A gant chart by programmer can indicate the stages of the project. Assuming that the stats are Planned, Codding, In progress and delivered (in that order), The graph per programer can show Time Vs Programer with a line for each project. Each line will show progress per project in time up to the last date per programmer with a color that depicts de status in time. Since time ends in Mar 24 but the project ends in Mar 26, that is a segmented line that represents the end of the project, while the continous line in 4 colors represents each state in time. Testers not included since thay are asking for developers graph. Nevertheless, on the same graph and once it reaches delivered state, on the graph bar the name if the tester can be included.

Assuming that this is not a programing questin since it is under the PM category.

To implement we need to crate an additional table that relates projname with the project status. I make an assumption that each projectname has the task status embeded in the name. For example, P1A means Project one in planning stage. then I can make a table with all the projects with a column that describes each stage and use it all three tables to create a flat table that gives me the necessary information to create the graph.