Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smptech
Starting Member
1 Post |
 Posted - 2007-01-25 : 22:26:00
|
| I'm developing a database design that needs to keep track of assessment values for boats. I only want to have one record representing a boat, however I need to keep track of changes to things like engine type, engine horsepower, etc. Here's the catch, I need to historically track what these attributeswere at the time the assessment value was calculated for that fiscal year. These attributes can be different for each fiscal year than they were at the time of the assessment for a previous year. In other words if I store the assessed value for any given fiscal year I need to show what the boat attributes were at the time I used to calculate the value for it, all the while only have one master boat record (which is linked to owner(s) accross fiscal years.Thanks in advance for your help. |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2007-01-28 : 18:21:22
|
| I think your explaination pretty much solves the problem. A master "boat" record with the static attributes of that boat. Then you need the assessed attributes stored along with a value and fiscal year linked back to the boat record. Then owners and owners to boat records (with dates of ownership). |
 |
|
|
|
|
|
Design Help