help desiging database to store lots of numerical values
Posted by: Chris Bassett
Date: February 04, 2010 09:38PM

I need to develop a database that holds a series of numerical (floating-point) values. What I am looking to do is to track sales for various departments within a store on a daily basis. So the three major elements that need to be recorded are department (which I've assigned a number to each, which will be a primary key of the "departments" table).

Next would be the date, and third would be the sales figure (the actual floating-point value).

Problem is that I have 10 departments and there are 365-366 days per year (store is open nearly every day of the year). What would be the best way to store this type of information??

Options: ReplyQuote


Subject
Written By
Posted
help desiging database to store lots of numerical values
February 04, 2010 09:38PM


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.