Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Table Design Question...simple (I think)

Re: Table Design Question...simple (I think)

From: Andreas Bauer <just.another_at_email.address.com>
Date: Fri, 05 Jan 2001 16:08:08 +0100
Message-ID: <934o56$9b2$02$1@news.t-online.com>

> I am trying to design a table(s) that will keep track of monthly sales.
> We receive sales information monthly and the field name every month is
> "clcsal"
>
> How do I design a table that will keep track of every months sales for
> 3-
> 5 years? I need to do queries for different sets of months, since a lot
>
> of our incentives do not run in a calendar year and also vary in length.
> I am pretty sure that I have the rest of the database designed
> properly, but I want to do this table the most efficient way possible.

Why not simply do something like this:

   Sales (_year_: integer, _month_: varchar, clcsal: float)

Or am I missing the point?

Andi. Received on Fri Jan 05 2001 - 09:08:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US