Jump to content

Creating snapshots of data (multiple fields)


ken_s2007

This topic is 4254 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I've started building a database to track investments (stocks, mutual funds, bonds, etc.). What I'm after is to periodically duplicate all the records, set a date field with today's date, and update the quantities and prices of the investments. The investments have a field that describes their type (e.g., bond, international, risk, etc.). The outcome is to be able to see snapshots of investments over time, and compare them, as well as to see the current state.

I'm sure this is a very common type of database design. However I'm note sure of how to build it (there are probably a number of good ways to build it). Thinking in ERD terms, I was thinking of an investment table, a data table, and then a join table in the middle. Thanks.

Ken

Link to comment
Share on other sites

This topic is 4254 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.