datbase deisgn modeling
Posted by: angi web
Date: January 24, 2008 09:56PM

There are 4 entities

Consultant
Client
Project
Time Sheet

Now a Consultant can work for many clients at a time
One client may have many projects at a time
A consultant can work on many projects at a time.
the timesheet varies for each client as some clients have week from monday to sunday while other have from sunday to sunday
So in Short a employee can for many clients at a time and many projects of one client.
Time sheet is used to track how much a consultant worked for each client and each project for that client for that.
How can I design a database to design this.
Please help.

Options: ReplyQuote


Subject
Written By
Posted
datbase deisgn modeling
January 24, 2008 09:56PM
January 24, 2008 10:52PM


Sorry, you can't reply to this topic. It has been closed.

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.