Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011

    Lightbulb Stock-Market database

    Hi Guys,

    I am trying to decide which concept is better. I am building a database of Stock market historical data in MS Access.

    In the attached file you can find 2 concepts I am considering (V1, V2).


    pro - flexibility. If I want to add new property I just add it into the table TBL_Value_Type_V1

    contra - more difficult queries, more records in the TBL_Values (8000000 and more)

    pro - simple queries, less records

    contra - when I want to add new value type I have to add new column into the table TBL_Values_V2. This makes is it less flexible. In addition I will have a lot of blanks in the database, since not all instruments have the same properties (for example Instr3 does not have open value)

    Could you please advise which one is more common for the data structure I am working with? Any new ideas are welcome.

    Attached Thumbnails Attached Thumbnails Schema.bmp  

  2. #2
    Join Date
    Mar 2007
    Are you using all of the columns as your primary key?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts