Thread: Oracle Project
View Single Post
Join Date: Mar 2008
Posts: 269
Reputation: Traicey is an unknown quantity at this point 
Solved Threads: 19
Traicey's Avatar
Traicey Traicey is offline Offline
Posting Whiz in Training

Oracle Project

 
0
  #1
May 15th, 2008
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
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
Reply With Quote