Hi,
I'm working on one scenario to design project management system.
Scenario-Institute of research is keen to get lecturing staff to undertake consultancy work for outside companies.
The intention is to engage new staff to "sell" Institute of research expertise to companies.
Institute of research would appoint a member of the lecturing staff whose expertise covers the required problem.
He or she would investigate the job and decide upon the time scale required and the number of people required to work on the proposed project and hence the quoted price.;if the quote is acceptable he/she would become the project manager.
Based upon this information, Institute of research would present the company concerned with a quote and if accepted would appoint members of staff to work on the project. The staff concerned would be paid for each hour they work on the project.
In return Institute of research would take 15% of the quoted price upon completion of the project and hence, the hourly rate paid to staff will reflect this 'commission'.
Each project is for a specific client and has a project manager, usually the person who investigated the original job. Each project is divided into number of jobs and each employee bills their time and expenses against a particular job. Only approved expense claims are stored.
At any one time, each employee appointed to the project has a specific role or task. It is this task, e.g.programmer, which defines the hourly rate that person receives for the work they do.
Over time, an employee can work on several many jobs associated with the same project. In addition, many jobs will have a number of associated documents such as user manuals to produce for the customer. Each of these may involve one or more members of staff. Only documents which have been approved by the project manager are sent to the customer.
According to the above scenario-I've identified the entities to design project management system. Those are
1)Staff
2)Project
3)Salary/Wages
4)Job
5)Customer
6)Documents
7)Task
8)Hours
I want the feedback to identify whether it's right or wrong. or else please indicate the possible outcome of the entities and any weblinks-which is related to the above acenario to normalise the tables.
Thx.....
Start Free Trial
