We have given a project at school, we have to submit ERD next week... the project is as followes.....
Software Experts(SE) is a consulting firm that specialises in creating custom software application for clients. When a client approaches SE with a project, the management at SE determine the staffing needs in terms of the number of consultants needed ans required skill sets of the consultants. They then locate available consultant with necessary skils and assign them to the project. One of the consultants is assigned to be the Project Manager. When the project is completed, the project manager eveluates all the other consultants who worked on the project and all the other project consultants eveluate the project manager, A project can be subdivided into multiple projects
1.Consultant information
2.Description of Employee skills
3.Client information
4.Project Information
5.Time spent working on the project
6.Evaluation and score
I have spotted some entities
1.Client
2.Evaluation
3.Project
4.Skills
5.TimeOfProject
6.Consultant
If you can possible help me with the relationship and help me to normalise the table that would be highly appreciated
Thanx in advance