By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,529 Members | 824 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,529 IT Pros & Developers. It's quick & easy.

relational design normalisation

P: n/a
pdm
hey,

I have a relational design question.
In the first requierement I got a table [contact] and a lookup
reference field that set the [statue] of the contact.
eg .

[Peter Liber] [Employee]
[Marc Stam] [CEO]
[Linda Tram] [Project Manager]

To every contact and his statue there are other data related eg. Time
Spend, Wage. Up to the moment that the Statue didn't change this works
fine.

The new requierement asked that the statue of a person could change in
the time and that this should have no influence on the past data. eg.
wage calculations. Lets say Peter statue is moving from Employee to
CEO.
With the first design this should cause problems. Because past statue
data change to the new statue and the past wage calculations should
take the new wage and this produce incorrect past data.

How the I need to design my tables or relationsships to fit the new
requierement ?

Mar 17 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.